Eclipse Community Forums: EclipseLink » Optimization for sequence ID

Home » Eclipse Projects » EclipseLink » Optimization for sequence ID

Optimization for sequence ID [message #1075549]

Mon, 29 July 2013 12:12

Eclipse User

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

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

Goto Forum:

-=] Back to Top [=-

Current Time: Sun Jul 20 12:17:51 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter