auto-incrementing non-primary key field value needed

From: Mike Kienenberger (mkienen..mail.com)
Date: Mon May 22 2006 - 22:27:15 EDT

  • Next message: Marcin Skladaniec: "database trigger"

    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?

    This archive was generated by hypermail 2.0.0 : Mon May 22 2006 - 22:27:42 EDT