Eclipse Community Forums: EclipseLink » update allocationSize of Sequence table

Help

Home

Home » Eclipse Projects » EclipseLink » update allocationSize of Sequence table

Show: Today's Messages :: Show Polls :: Message Navigator

update allocationSize of Sequence table [message #756875]

Tue, 15 November 2011 07:20

Vera Paskaleva
Messages: 2
Registered: November 2011

Junior Member

Hello,

We're using a primary key generator of type TABLE. By now we used the default value of allocationSize 50. But we have some problems with concurrency and we want to update allocationSize to 1. We've tried doing this:
@Id
@TableGenerator(name = "ID_GENERATOR", table = "SEQUENCES", allocationSize=1)
@GeneratedValue(generator="ID_GENERATOR")
but the generator starts with id = 1 and we have already record in the database with id 1. Is there any way we can update allocationSize to primary key generator that exists already without the initial value to be 0?

Thank you.

Report message to a moderator

Re: update allocationSize of Sequence table [message #756919 is a reply to message #756875]

Tue, 15 November 2011 09:32

Chris Delahunt
Messages: 862
Registered: July 2009

Senior Member

Hello,

The SequenceGenerator annotation allows setting the initialValue which is used when the generator is created. If you already have the sequence table setup, you can change the value in the database directly, or you can modify the table using a native SQL query in the application.

Best Regards,
Chris

Report message to a moderator

Previous Topic:	update allocationSize of Sequence table
Next Topic:	IllegalArgumentException: eclipselink.profiler

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 19 10:36:17 EDT 2013