Yes, it is autogenerated by the DB. I'm using MS SQLServer.
In fact, I would like to have the PK value before the commit ! Is there
any way to do that ?
Thank you
Marc
-----Original Message-----
From: Andrus Adamchik [mailto:andru..bjectstyle.org]
Sent: Friday, June 15, 2007 3:48 PM
To: use..ayenne.apache.org
Subject: Re: Identity PK value
BTW, is "identity column" autogenerated by DB by any chance? And
which DB is that?
Maybe you can use this mechanism:
http://cayenne.apache.org/doc20/generated-columns.html
Andrus
On Jun 15, 2007, at 4:32 PM, Mike Kienenberger wrote:
> It's relatively easy to build your own custom PK generator, using
> whatever logic you want.
> Take a look at the various database implementations for examples, such
> as the OpenBase one.
>
> On 6/14/07, Marc Gabriel-Willem
> <marc.gabriel-wille..ide-international.com> wrote:
>> Dear all,
>>
>>
>>
>> We have a problem regarding the PK value access.
>>
>> My db schema and my business logic require me to get the next
>> identity
>> of a particular table before inserting the new record.
>>
>>
>>
>> We must use the identity column defined at the table level (cannot
>> use a
>> stored procedure pk specific table management).
>>
>>
>>
>> May be the PkGenerator class could be useful for us, but it seems a
>> stored procedure is required (not a good option for us).
>>
>>
>>
>> So, is there a way to get the current identity value ( 1) defined
>> on a
>> particular table using cayenne ?
>>
>> We know this is not a good practise, but we cannot change our model
>> easily.
>>
>>
>>
>> Thank you in advance for your help.
>>
>>
>>
>> Marc Gabriel
>>
>>
>> ------------------------------------------------------------------
>> CONFIDENTIALITY: This e-mail and any files transmitted with it are
>> confidential and intended solely for the use of the recipient(s)
>> only. Any review, retransmission, dissemination or other use of,
>> or taking any action in reliance upon this information by persons
>> or entities other than the intended recipient(s) is prohibited. If
>> you have received this e-mail in error please notify the sender
>> immediately and destroy the material whether stored on a computer
>> or otherwise.
>>
>> DISCLAIMER: Any views or opinions presented within this e-mail are
>> solely those of the author and do not necessarily represent those
>> of SIDE International S.A. - EastNets Group, unless otherwise
>> specifically stated.
>> ------------------------------------------------------------------
>>
>>
>>
>
This archive was generated by hypermail 2.0.0 : Fri Jun 15 2007 - 09:56:56 EDT