Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EclipseLink » Optimization for sequence ID
Optimization for sequence ID [message #1075549] Mon, 29 July 2013 12:12
F C is currently offline F C
Messages: 12
Registered: June 2013
Junior Member
Hi, I have an entity with sequence ID like this

@GeneratedValue(strategy=GenerationType.TABLE, generator="sequence")
@SequenceGenerator(name="sequence",sequenceName="SQ_TABLE_X", allocationSize=1)
private Long id;

But SELECT SQ_TABLE_X.NEXTVAL FROM DUAL query is made for each persisting
operation and such operation is very slow (the operation insert
about 8000 record in 6/7 minutes). Is there a more quick method to do this?


Previous Topic:EclipseLink Bug in DatabaseQuery.checkPrepare
Next Topic:Problem with criteria
Goto Forum:

Current Time: Fri Aug 22 15:44:56 EDT 2014

Powered by FUDForum. Page generated in 0.01535 seconds