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
