Eclipse Community Forums: EclipseLink » Optimization for sequence ID

Help

Home

Home » Eclipse Projects » EclipseLink » Optimization for sequence ID

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

Optimization for sequence ID [message #1075549]

Mon, 29 July 2013 16:12

F C

Messages: 12
Registered: June 2013

Junior Member

Hi, I have an entity with sequence ID like this

@Id
@Column(name="ID")
@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?

Thanks

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 22:38:21 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter