Hi Kreecha,
Every database supports either an identity or a sequence. You'll need to change
the strategy if the other database doesn't support the identity, and provide the
sequence name. Or you can switch to a table-based identity and do not depend on
the particular database.
Note that if a database supports both, the identity and the sequence, TopLink
chooses only one way for historical reasons.
Regards,
-marina
kai pupha wrote:
> Hi Marina,
> Thank you for the link.
>
> I used this:
> @Id
> @GeneratedValue(strategy=GenerationType.IDENTITY)
>
> And now i can retrieve autoincremented ID, but just wonder what if i
> want to port my work to different dbms like: Microsoft SQL Server and
> Access. How can i do that to access generators? Do you know?
>
> Thank you,
> Kreecha
>
>
>> From: Marina Vatkina <Marina.Vatkina_at_Sun.COM>
>> Reply-To: persistence_at_glassfish.dev.java.net
>> To: persistence_at_glassfish.dev.java.net
>> Subject: Re: Retrive autoincrement value with MySQL connector 5.1
>> Date: Wed, 25 Jul 2007 16:12:44 -0700
>>
>> Hi Kreecha,
>>
>> Does this bug describe your problem:
>> https://glassfish.dev.java.net/issues/show_bug.cgi?id=3395
>>
>> If yes, did you try to call em.flush() before retrieving the value?
>>
>> thanks,
>> -marina
>>
>> kai pupha wrote:
>>
>>> Hi there,
>>>
>>> I am new and trying Java Persistence using J2SE and found one
>>> problem that you may be able to help. I have 2 tables let say: 1)
>>> tbCUSTOMER: ID(PK) and Name; and 2) tbORDER: ID(PK), Address and
>>> Customer_ID(FK). tbORDER.Customer_ID is a forign key of tbCustomer.ID.
>>>
>>> When i want to update the foriegn key (tbORDER.Customer_ID) obtained
>>> from newly generated value from tbCustomer.ID it just updates NULL
>>> value but the rest of the fields are updated successfully.
>>>
>>> I am using JDK 6, Netbeans M10 with Toplink and MySQL Connector 5.1.
>>> Do you know that autoincrement is supported in JPA or how can i work
>>> around to obtain a newly generated primary key please?
>>>
>>> Thank you,
>>> Kreecha
>>>
>>> _________________________________________________________________
>>> Watch all 9 Live Earth concerts live on MSN.
>>> http://liveearth.uk.msn.com
>
>
> _________________________________________________________________
> The next generation of Hotmail is here! http://www.newhotmail.co.uk