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

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Tue May 23 2006 - 19:20:48 EDT

  • Next message: Marcin Skladaniec: "Re: auto-incrementing non-primary key field value needed"

    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

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