I was talking about PkGenerator.generatePkForDbEntity(DataNode,
DbEntity) method (PkGenerator instance is owned by DbAdapter that is
owned by DataNode). How you configure it is up to you. If you don't
care about the gaps in values, and only care about them being unique,
you can pass the real DbEntity to this method; if you want a separate
sequence, you may fake a "synthetic" DbEntity and add an extra row to
AUTO_PK_SUPPORT (or create an extra DB sequence if you are on oracle
or postgres).
Andrus
On May 23, 2006, at 7:39 PM, Marcin Skladaniec wrote:
> 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:47:51 EDT