Hi,
While starting the persistence manager, JBoss throws the following exception... 10:47:19,988 INFO [PersistenceManager] Starting 10:47:20,759 ERROR [PersistenceManager] Starting failed org.jboss.mq.SpyJMSException: Could not resolve uncommited transactions. Message recovery may not be accurate; - nested throwable: (java.sql.SQLException: General error, message from server: "Table 'test.jms_messages' doesn't exist") .....
What does this mean? Is there an xml file somewhere which would be responsible for this. Do I have to change some parameters? Can anybody explain this?
Thanks a lot!
Patrik Fuhrer
You'll find a file named hsqldb-jdbc2-service.xml in $JBOSS_HOME/server/<config>/deploy/jms.
If you want to use mysql I'd recommend to
- rename this file to mysql-jdbc2-service.xml
- possibly replace the datasource name DefaultDS with your name (line 56)
- create the tables jms_messages and jms_transactions by hand. Look for CREATE_MEESAGE_TABLE and CREATE_TX_TABLE
If everything was correct, you will not see the error messages again.
Regards - Frank
------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
