Thank you !
Marcin
On 24/05/2006, at 9:47 AM, Andrus Adamchik wrote:
> 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
>
-------------------------->
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 - 20:26:31 EDT