[PersistenceException: Error getting sequence nextval]

Question

i am getting this error while trying to save data into model in db.

@Entity
public class User extends Model {
   @Required
   public String name; 
   @Email
   public String email; 
   @Required @MaxLength(value=10)
   public String username;
   @Required @MinLength(value=4)
   public String password;
   @Id 
   public int id;
}

this is my Class.

this is the error while i am trying to save the model into db.

enter image description here

i will appreciate any effort for help! many thanks.

EDIT: table structure is here enter image description here

Please show your table structure (sql file which creates tables). And tell us on what db you're working, because, if it is on MySQL, it does not support sequences. — ndeverge
– ndeverge, Commented Jun 29, 2012 at 11:15
yeah, it generated itself. but my suspect is that i have also an ID of my class. should i delete this as Ebean will create an ID automatically? — doniyor
– doniyor, Commented Jun 29, 2012 at 11:27
Possible duplicate of this : stackoverflow.com/questions/9999107/… — ndeverge
– ndeverge, Commented Jun 29, 2012 at 19:04

John Kane · Accepted Answer · 2012-06-29 11:20:57Z

10

I think with ebean you have to physically name and annotate your id. You may also have to tell it the name of the backing sequencer as well (I dont remember). This shows how to do it.

answered Jun 29, 2012 at 11:20

John Kane

4,4531 gold badge27 silver badges46 bronze badges

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

4 Comments

doniyor Over a year ago

John, thanks alot! that was the point. Great Stackoverflower! ;)

duma Over a year ago

This solution also worked for me (Play 2.0.4). The key was adding this annotation to my User model: @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "users_id_seq"). I dunno if Play isn't identifying the sequence correctly or what, but it works now. Frustrating.

Adrien Over a year ago

I also had to define the sequence, otherwise Hibernate would tell me it doesn't know about users_id_seq:

@SequenceGenerator(name="seq_gen_name", sequenceName="task_seq") @GeneratedValue(strategy=GenerationType.SEQUENCE, generator="seq_gen_name") @Id public Long id;

Guerry Over a year ago

These example worked for me except I had to add my schema: sequenceName="myschema.my_seq" A simple thing, but easy to miss. It is mentioned in the code in the answer below.

Leo · Accepted Answer · 2014-07-10 06:53:01Z

2

This worked for me:

@Entity
@Table(name = "table", schema = "schema")
public class Bean extends Model{

   @Id
   @Column(name = "idcolumn")
   @SequenceGenerator(name="gen", sequenceName="schema.table_idcolumn_seq",allocationSize=1) 
   @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "gen")
   private int id;
}

When using the SequenceGenerator, please mind this bug in Hibernate: https://hibernate.atlassian.net/browse/HHH-7232

It forces you to write the schema directly into the sequenceName instead of using the schema field in the SequenceGenerator annotation.

answered Jul 10, 2014 at 6:53

Leo

1012 silver badges6 bronze badges

Comments

Welinton Carvalho · Accepted Answer · 2015-07-10 03:45:29Z

1

This worked for me on class annotation:

@SequenceGenerator(name = "SEQUENCE_NAME", sequenceName = "PST_BUSINESS.S_BUSINESS_DOMAIN")
@Entity
@Table(name = "TB_BUSINESS_DOMAIN", schema = "PST_BUSINESS")
public class PstBusinessDomain extends PstAbstractBaseMappedEntity {

As Leo said, this strategy works for annotation in the field and also in the class.

answered Jul 10, 2015 at 3:45

Welinton Carvalho

111 bronze badge

Collectives™ on Stack Overflow

[PersistenceException: Error getting sequence nextval]

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related