I am worried about the test.jms_messages thing in deploy/jms/jbossmq-service.xml you have the definition of the persistence manager which points to a MySQL DB. Do you have a test DB? Normally the user provided in the datasource should be able to create tables. If not that might me be the problem
FYI, the persistence manager will create the jms_messages and jms_transactions table if needed. Now if the user provided in the DS does not have the right to do that, that might be the problem Check your DS configuration and that the account you use can create tables Cheers, Stephane -----Original Message----- From: FUHRER Patrik [mailto:[EMAIL PROTECTED] Sent: Friday, September 26, 2003 12:44 PM To: [EMAIL PROTECTED] Subject: [JBoss-user] Exception staring Persistence Manager for JBoss3.2.2 with MySQL 4 .1 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") at org.jboss.mq.pm.jdbc2.PersistenceManager.resolveAllUncommitedTXs(Persistence Manager.java:295) at org.jboss.mq.pm.jdbc2.PersistenceManager.startService(PersistenceManager.jav a:1315) at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192) ... ... Caused by: java.sql.SQLException: General error, message from server: "Table 'test.jms_messages' doesn't exist" at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1651) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:889) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:956) at com.mysql.jdbc.Connection.execSQL(Connection.java:1874) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1700) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1569) at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(Wrapp edPreparedStatement.java:308) at org.jboss.mq.pm.jdbc2.PersistenceManager.resolveAllUncommitedTXs(Persistence Manager.java:268) ... 68 more 10:47:20,769 WARN [ServiceController] Problem starting service jboss.mq:service=PersistenceManager 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") at org.jboss.mq.pm.jdbc2.PersistenceManager.resolveAllUncommitedTXs(Persistence Manager.java:295) at org.jboss.mq.pm.jdbc2.PersistenceManager.startService(PersistenceManager.jav a:1315) at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192) ... ... Caused by: java.sql.SQLException: General error, message from server: "Table 'test.jms_messages' doesn't exist" at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1651) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:889) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:956) at com.mysql.jdbc.Connection.execSQL(Connection.java:1874) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1700) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1569) at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(Wrapp edPreparedStatement.java:308) at org.jboss.mq.pm.jdbc2.PersistenceManager.resolveAllUncommitedTXs(Persistence Manager.java:268) ... 68 more 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 ------------------------------------------------------- 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 +,~wzf+,좷o$yyzW(h礅zxm&,ǫx%I,ǫ+-.ǟ alb,y+b?+-w6ˬz
