On Fri, 2003-09-26 at 12:43, FUHRER Patrik wrote: > 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? >
I guess you modified java:/DefaultDS to be mysql? You'll also need to modify JMS's jdbc2 persistence manager sql. Here's some examples: http://cvs.sourceforge.net/viewcvs.py/jboss/jbossmq/src/etc/server/examples/deploy/ Regards, Adrian > 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 -- xxxxxxxxxxxxxxxxxxxxxxxx Adrian Brock Director of Support Back Office JBoss Group, LLC xxxxxxxxxxxxxxxxxxxxxxxx ------------------------------------------------------- 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