EJB3 and informix sequences
Posted in 2007
Hello! I try to get EJB3 (Hibernate), JBoss and Informix sequences to work. Here is my Entity Bean: package com.tresorband.yucatan.TabLagerBuchungen; //BD Tabellenname: lagerbuchungen import java.io.Serializable; import java.math.BigDecimal; import java.sql.Timestamp; import javax.persistence.Id; import javax.persistence.GeneratedValue; import javax.persistence.GenerationType; import javax.persistence.SequenceGenerator; import javax.persistence.Entity; import javax.persistence.Table; import javax.persistence.Column; @Entity @Table(name="lagerbuchungen") @SequenceGenerator(name="lagerbuchungen_seq",sequenceName="lagerbuchungen_seq") public class EJBLagerBuchung implements Serializable { private Integer labuId=null; private Integer labuLabeId=null; private String labuLbtyId=null; private BigDecimal labuStueck=null; private String labuBsk=null; private Integer labuUnpoId=null; private String labuUser=null; private Timestamp labuZslu=null; @Id @GeneratedValue(strategy=GenerationType.SEQUENCE,generator="lagerbuchungen_seq") @Column(name="labu_id",nullable=false,columnDefinition="integer") public Integer getLabuId(){ return labuId; } public void setLabuId(Integer arg){ labuId=arg; } @Column(name="labu_labe_id",nullable=false,columnDefinition="integer") public Integer getLabuLabeId(){ return labuLabeId; } public void setLabuLabeId(Integer arg){ labuLabeId=arg; } @Column(name="labu_lbty_id",nullable=false,columnDefinition="char",length=8) public String getLabuLbtyId(){ return labuLbtyId; } public void setLabuLbtyId(String arg){ labuLbtyId=arg; } @Column(name="labu_stueck",nullable=false,columnDefinition="decimal") public BigDecimal getLabuStueck(){ return labuStueck; } public void setLabuStueck(BigDecimal arg){ labuStueck=arg; } @Column(name="labu_bsk",nullable=true,columnDefinition="char",length=32) public String getLabuBsk(){ return labuBsk; } public void setLabuBsk(String arg){ labuBsk=arg; } @Column(name="labu_unpo_id",nullable=true,columnDefinition="integer") public Integer getLabuUnpoId(){ return labuUnpoId; } public void setLabuUnpoId(Integer arg){ labuUnpoId=arg; } @Column(name="labu_user",nullable=false,columnDefinition="char",length=8) public String getLabuUser(){ return labuUser; } public void setLabuUser(String arg){ labuUser=arg; } @Column(name="labu_zslu",nullable=false,columnDefinition="datetime") public Timestamp getLabuZslu(){ return labuZslu; } public void setLabuZslu(Timestamp arg){ labuZslu=arg; } } If I try to deploy it I get the following Error: Exception in thread "main" javax.persistence.PersistenceException: org.hibernate.HibernateException: Missing sequence or table: lagerbuchungen_seq at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:698) at org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:121) at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:51) at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:33) at com.tresorband.tests.EjbTestLocalObjects.main(EjbTestLocalObjects.java:25) Caused by: org.hibernate.HibernateException: Missing sequence or table: lagerbuchungen_seq at org.hibernate.cfg.Configuration.validateSchema(Configuration.java:1018) Has anybody successfully worked with EJB3 and informix sequences? Regards, Bernhard Donaubauer