RE: EJB3 and informix sequences

Sorry, I have worked a bit with Hibernate + the EJB3, but I did not use the sequences. > -----Original Message----- > From: informix-list-bounces@iiug.org [mailto:informix-list- > bounces@iiug.org] On Behalf Of Donaubauer Bernhard > Sent: Thursday, February 22, 2007 18:23 > To: informix-list@iiug.org > Subject: EJB3 and informix sequences > > 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(Ejb3Configur > ation.java:698) > at > org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(Hibernat > ePersistence.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 > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list