persist entities problem

[alex_ro_bv]

Hi all, I'm new to seam, and I like it so far. I tried to develop a small project but I hit this exception: org.hibernate.exception: could not get nex sequence value. I have a entity with following annotations

@Entity
@Table(name="blv_user")
@Name("user")
public class User implements Serializable {
 private Long id;
 private Integer version;
 private String name;
 private String pass;
 @Id
 @GeneratedValue(strategy=GenerationType.SEQUENCE,generator="gen_user")
 @SequenceGenerator(name="gen_user", sequenceName="id_user", allocationSize=1)
 public Long getId() {
 return id;
 }

 public void setId(Long id) {
 this.id = id;
 }

when I do a query, it works , but with em.persist(user), raises that exception.
I did not find anything usefull on the documentation for seam, neither on how to save my queries in a xml file like in old hibernate style or how to call an store procedure. Can anyone help me please?

[thejavafreak]

Perhaps you can get a better support from
http://forum.hibernate.org

[trouby]

Yeah, Hibernate forum is better,

But just to give you directions, what DB type are you using? is your DB supports sequences at all? (if you'r using Mysql, better go for '@GeneratedValue' which will create the PK column with mysql's auto_incremental.


Asaf.

[alex_ro_bv]

yes, thejavafreak was right, I resolved the problem looking at the java forum. it seemed to have set the catalog name and schema, and as soon as I deleted those lines everything worked fine. Thank you!