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:[EMAIL PROTECTED] Sent: Friday, June 15, 2007 3:48 PM To: [email protected] 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 > <[EMAIL PROTECTED]> 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. >> ------------------------------------------------------------------ >> >> >> >
