Could you please look at the below errors and suggest what is going on and how to fix it?
javax.ejb.EJBException: javax.persistence.PersistenceException:
org.hibernate.exception.GenericJDBCException: could not get next sequence value
at org.jboss.ejb3.tx.Ejb3TxPolicy.handleExceptionInOurTx(Ejb3TxPolicy.java:69)
The EJB is annotated as:
==== class
@Entity
@Table(name="equifax_request")
@TransactionManagement(TransactionManagementType.CONTAINER)
==== pk id annotation
@Id
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator="WW")
@SequenceGenerator(name="WW", sequenceName="my_seq")
@Column(name="eqrq_no", nullable=false, insertable=true )
This is an informix 9.4 DB with the IBM informix drivers and Hibernate Persistence in
JBoss 4.04 I have verified that the sequence exists. I have also successfully used iSQL
(java sourceforge sql tool) to run the logged hibernate query of:
select my_seq.nextval from systables where tabid=1
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3967602#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...