Eclipse Community Forums: EclipseLink » update allocationSize of Sequence table

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

update allocationSize of Sequence table [message #756875]

Tue, 15 November 2011 07:20

Eclipse User

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.

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

Tue, 15 November 2011 09:32

Eclipse User

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

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

Goto Forum:

-=] Back to Top [=-

Current Time: Wed Jul 09 09:53:14 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter