Re: Oracle Sequence Exception Question

From: Mike Kienenberger (mkienen..laska.net)
Date: Tue Oct 21 2003 - 15:20:23 EDT

  • Next message: Todd Costella: "RE: Oracle Sequence Exception Question"

    Todd Costella <Todd.Costell..ntero.com> wrote:
    > > org.objectstyle.cayenne.CayenneRuntimeException: [v.1.0.1 October 13
    2003] No suitable DataNode to handle primary key generation.
    > >
    > > Below is a snippet from the <project>.map.xml
    > >
    > > <db-entity name="OMNI_TRACK_NOTES">
    > > <db-attribute name="ID" type="INTEGER" isPrimaryKey="true"
    isMandatory="true"/>
    > > <db-attribute name="SEQ" type="INTEGER" isMandatory="true"/>
    > > <db-attribute name="TEXT" type="VARCHAR" length="2000"/>
    > > <db-attribute name="note_text" type="CLOB" length="40000"/>
    > > <db-key-generator>
    > > <db-generator-type>ORACLE</db-generator-type>
    > > <db-generator-name>note_id_seq</db-generator-name>
    > > <db-key-cache-size>20</db-key-cache-size>
    > > </db-key-generator>
    > > </db-entity>
    > >
    > > This sequence exists in the Oracle 8.1.7.0.4 DB.
    > >
    > > I have not generated primary key support through the modeling tool, I
    > > assume I don't need to as I have existing sequences in place for my
    > > entities. I assume that I just need to specify the name of the sequence
    > > in the db-entity as illustrated above.

    Did you set up an Oracle data node and attach it to your DataMap?
    The DataNode contains the info that would normally be in the EOModeler
    Adaptor Info.

    -Mike

    This archive was generated by hypermail 2.0.0 : Tue Oct 21 2003 - 15:19:32 EDT