[jboss-user] [JBoss Messaging] - Re: Problem after mcving from 1.3 to 1.4

[HibsMax]

When I run my test I get lots of these messages on the stdout:
2007-07-26 15:14:35,820 WARN  [org.jboss.messaging.core.impl.JDBCPersistenceManager] SQLException caught - assuming deadlock detected, try:1
java.sql.SQLException: ORA-02291: integrity constraint (MANDERSO.SYS_C0011668) violated - parent key not found

I hacked the DB and removed the referential integrity constraint (JBM_MSG_REF.MESSAGE_ID -> JBM_MSG.MESSAGE_ID) just to see what would happen i.e. not considering it a legitimate fix, and I ceased getting the messages and the test ran.  I started getting other stack traces instead.

I know that the database schema changed between 1.3 and 1.4.  Is there some other configuration required to avoid the SQLException above?  When I googled I only found one issue and that was re: duplicate keys, not parent key not found.

Thanks, Anders

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4068003#4068003

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4068003