Re: Fetching a NextVal to be used in an insert

From: Bryan Lewis (brya..aine.rr.com)
Date: Mon Nov 01 2004 - 16:02:13 EST

  • Next message: Michael Sacket: "Re: Setting Connection information"

    Williams, Beth wrote:
    > The name of the Oracle sequence is PERSON_ID. The name of the DB Attribute name in the modeler is PERSON_ID. The obj Attribute name is personId. Is there somewhere in the modeler that you can specify what the sequence name is? Looking through the documentation I see a section for Generate Primary Key Support. This section refers to the Generate Database Schema option where you can specify to "Drop Primary Key Support" and "Create Primary Key Support". Does this pertain to what I am trying to do? Any additional info you can give to point me in the right direction is greatly appeciated. Thanks.

    Sounds like both issues will need fixing, the primary key being exposed
    as an object attribute, and specifying the right sequence name. In the
    DbEntity's page in the modeler, you'll see a section "PK Generation".
    If you check the "Customize" box you can fill in the name of your sequence.

    The "Generate Primary Key Support" that you saw in the docs is for
    creating a database to match your model. The "PK Generation" section of
    the DbEntity page specifies how to ask an existing Oracle database for
    the next value. It isn't yet described in the docs as far as I know.



    This archive was generated by hypermail 2.0.0 : Mon Nov 01 2004 - 16:02:33 EST