Eclipse Community Forums: EclipseLink » Ignoring oracle sequence

Help

Home

Home » Eclipse Projects » EclipseLink » Ignoring oracle sequence

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

Ignoring oracle sequence [message #686107]

Tue, 21 June 2011 18:19

Mauro Flores

Messages: 84
Registered: September 2009
Location: Brasil

Member

I have an entity with the following id configuration:

  @Id
  @Column(name = "NRO_INT_FOO")
  @SequenceGenerator(name = "Foo_SEQ", sequenceName = "ID_FOO_SEQ", allocationSize = 10)
  @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "Foo_SEQ")
  Long               nroIntFoo;

For some reason the last number of the oracle seguence ID_FOO_SEQ is ignored and sometimes I get an ORA-00001 (unique constraint violated)

Any help is appreciated

Thanks. Mauro.

Report message to a moderator

Re: Ignoring oracle sequence [message #686116 is a reply to message #686107]

Tue, 21 June 2011 19:01

Chris Delahunt

Messages: 1389
Registered: July 2009

Senior Member

Is the oracle sequence object incrementing by 10 to match the allocation size you set in the annotation? Try turning logging on to see the SQL that is generated using <property name="eclipselink.logging.level" value="FINEST"/>

Best Regards,
Chris

Report message to a moderator

Previous Topic:	eclipselink-orm.xml and Eclipse JPA views
Next Topic:	(no subject)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 10:04:56 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter