Re: auto-incrementing non-primary key field value needed

From: Marcin Skladaniec (marci..sh.com.au)
Date: Tue May 23 2006 - 19:39:14 EDT

  • Next message: Andrus Adamchik: "Re: auto-incrementing non-primary key field value needed"

    On 24/05/2006, at 9:20 AM, Andrus Adamchik wrote:

    >
    > On May 22, 2006, at 10:27 PM, Mike Kienenberger wrote:
    >
    >> What's the best way to go about generating a non-primary-key
    >> auto-incrementing field value (unique, but eventually will be
    >> meaningful to the end users)?
    >>
    >> The database is Oracle (although I'd like it to work on HSQLDB too).
    >>
    >> Do I have to do this with a separate out-of-transaction database
    >> query, or is there some way I can make Cayenne assign a sequence
    >> value
    >> to this column?
    >
    > Cayenne won't assign values to non-pk columns, but you can still
    > reuse the Cayenne PK mechanism to obtain a sequence of values and
    > set the values manually.
    >
    > Andrus

    Andrus, could you explain a bit how to use Cayenne PK mechanism ?
    Would that require creating extra row in AUTO_PK_SUPPORT ? I would
    like to use auto-incrementation on non PK field too.

    Thank you.
    Marcin

    -------------------------->
    ish
    http://www.ish.com.au
    Level 1, 30 Wilson Street Newtown 2042 Australia
    phone +61 2 9550 5001 fax +61 2 9550 4001

    This archive was generated by hypermail 2.0.0 : Tue May 23 2006 - 19:39:39 EDT