sequence does not exist exception using eclipseLink with oracle db

Question

I've got the following JPA entity:

@Entity
@Table(schema = "myschema")
@SequenceGenerator(schema = "myschema", name = "seqGenerator", 
                   sequenceName  = "person_s1", allocationSize = 1)
public class Person {

@Id
@GeneratedValue(generator = "seqGenerator", strategy = GenerationType.AUTO)
private long id;

the following exceptions are thrown:

Call: DROP SEQUENCE myschema.person_s1
Query: DataModifyQuery(sql="DROP SEQUENCE myschema.person_s1")
[EL Warning]: 2010-11-01 17:21:51.051--ServerSession(10605044)--Exception [EclipseLink-    4002] (Eclipse Persistence Services - 2.1.1.v20100817-r8050): 
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: ORA-02289: sequence does not exist

Error Code: 2289
Call: SELECT myschema.person_s1.NEXTVAL FROM DUAL
Query: ValueReadQuery(sql="SELECT myschema.person_s1.NEXTVAL FROM DUAL")

The sequence is genrated by EclipseLink and the query:

SELECT myschema.person_s1.NEXTVAL FROM DUAL

works fine when used directly...

Any help appreciated

Regards Marcel

Pascal Thivent · Accepted Answer · 2010-11-01 21:28:07Z

3

the following exceptions are thrown (...)

These traces are generated during schema creation when a particular database object doesn't exist and thus can't be dropped. EclipseLink report such cases as Warning (which are not Error), they can be ignored (you get your sequence, right?).

PS: Why do you use an allocation size of 1, don't you want to benefit from the high/low optimization?

answered Nov 1, 2010 at 21:28

Pascal Thivent

572k140 gold badges1.1k silver badges1.1k bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Marcel Menz Over a year ago

Merci beaucoup Pascal. What is high/ low optimization? Might you drop me a line on that? Marcel

peterh Over a year ago

FWIW I've logged it as a bug in EclipseLink: bugs.eclipse.org/bugs/show_bug.cgi?id=487795. Motivation for calling it a bug is in the bug report.

lscoughlin · Accepted Answer · 2010-11-01 16:51:50Z

0

I know this is going to sound really silly, but here it is anyway.

@Entity
@Table(schema = "myschema")
public class Person {

   @Id
   @SequenceGenerator(schema = "myschema", name = "seqGenerator", sequenceName  = "person_s1", allocationSize = 1)
   @GeneratedValue(generator = "seqGenerator", strategy = GenerationType.AUTO)
   private Long id;
}

answered Nov 1, 2010 at 16:51

lscoughlin

2,41318 silver badges23 bronze badges

Collectives™ on Stack Overflow

sequence does not exist exception using eclipseLink with oracle db

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related