Re: [eclipselink-users] Problem in ID generation and Allocation Size

[James Sutherland <jamesssss@xxxxxxxxx>]

Ensure that you SEQUENCE object's INCREMENT matches your sequence
preallocation size.

You can turn logging on FINEST to have detailed sequencing info logged.


nishitv02 wrote:
> 
>  If I understand correctly EclipseLink implements sequencing in the
> following way : Sequencing is implemented such that EclipseLink will
> reserve the current sequence number and the next X sequence numbers; X
> being the sequence allocation size.
> 
> I changed the allocation Size in the local database and Id generation was
> working fine.
> 
> I changed the allocation Size on some other databse and the Id generation
> was not correct and this problem could only be reproduced sometimes. 
> 
> I looked at the definition of sequences in all those databases and they
> were the same.
> 
> What can be the cause of the problem.
> 


-----
http://wiki.eclipse.org/User:James.sutherland.oracle.com James Sutherland 
http://www.eclipse.org/eclipselink/
 EclipseLink ,  http://www.oracle.com/technology/products/ias/toplink/
TopLink 
Wiki:  http://wiki.eclipse.org/EclipseLink EclipseLink , 
http://wiki.oracle.com/page/TopLink TopLink 
Forums:  http://forums.oracle.com/forums/forum.jspa?forumID=48 TopLink , 
http://www.nabble.com/EclipseLink-f26430.html EclipseLink 
Book:  http://en.wikibooks.org/wiki/Java_Persistence Java Persistence 
-- 
View this message in context: http://www.nabble.com/Problem-in-ID-generation-and-Allocation-Size-tp25291051p25385345.html
Sent from the EclipseLink - Users mailing list archive at Nabble.com.