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#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...