Sorry. I know this is slightly off topic of your question - please forgive me. but I am still having the same problem whereby, it says the sequence does not exists... I am using jboss-4.0.5.GA w/EJB installed on Window XP runing 10g XE on same machine.
This one issue is enough to kill my project in SEAM, and I really wanted to give this a try. I need to be able to use SEQUENCE directly or before insert triggers (which invoke the sequence before actual insert). I don't care which way I go, but if I use the method proposed here, I get: --- MBeans waiting for other MBeans --- | ObjectName: persistence.units:ear=naturalmed2.ear,unitName=naturalmed2 | State: FAILED | Reason: javax.persistence.PersistenceException: org.hibernate.HibernateException: Missing sequence or table: NM.LISTINGTYPE_SEQ | I Depend On: | jboss.jca:service=DataSourceBinding,name=naturalmed2Datasource | | --- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM --- | ObjectName: persistence.units:ear=naturalmed2.ear,unitName=naturalmed2 | State: FAILED | Reason: javax.persistence.PersistenceException: org.hibernate.HibernateException: Missing sequence or table: NM.LISTINGTYPE_SEQ | I Depend On: | jboss.jca:service=DataSourceBinding,name=naturalmed2Datasource and again, the sequence is there (double checked). Also, I should mention that I am working with the code generated by SEAM generate-entities. Thank you for any help you can give. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4045659#4045659 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4045659 _______________________________________________ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user