Hi, I changed the default database to mysql did the changes in deploy dir to the xml as the getting started guide says and modified the conf/standardjbosscmp-jdbc.xml to reflect the default ds as mysql and when i restart jboss i get an error. How can i correct it, can't seem to find the xml that it says, heres the error from the server log :
| 2004-03-19 00:04:09,167 ERROR [org.jboss.mq.pm.jdbc2.PersistenceManager] Starting failed | org.jboss.mq.SpyJMSException: Could not resolve uncommited transactions. Message recovery may not be accurate; - nested throwable: (java.sql.SQLException: Syntax error or access violation, message from server: "You have an error in your SQL syntax near 'SELECT TXID FROM JMS_TRANSACTIONS) AND TXOP='A'' at line 1") | at org.jboss.mq.pm.jdbc2.PersistenceManager.resolveAllUncommitedTXs(PersistenceManager.java:336) | at org.jboss.mq.pm.jdbc2.PersistenceManager.startService(PersistenceManager.java:1356) | at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192) | at sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source) | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) | at java.lang.reflect.Method.invoke(Method.java:324) | at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284) | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546) | at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:976) | at $Proxy14.start(Unknown Source) | at org.jboss.system.ServiceController.start(ServiceController.java:394) | at org.jboss.system.ServiceController.start(ServiceController.java:411) | at org.jboss.system.ServiceController.start(ServiceController.java:411) | at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source) | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) | at java.lang.reflect.Method.invoke(Method.java:324) | at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284) | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546) | at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177) | at $Proxy4.start(Unknown Source) | at org.jboss.deployment.SARDeployer.start(SARDeployer.java:226) | at org.jboss.deployment.MainDeployer.start(MainDeployer.java:832) | at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:642) | at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:605) | at sun.reflect.GeneratedMethodAccessor18.invoke(Unknown Source) | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) | at java.lang.reflect.Method.invoke(Method.java:324) | at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284) | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546) | at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177) | at $Proxy6.deploy(Unknown Source) | at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:302) | at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:476) | at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:201) | at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:274) | at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192) | at sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source) | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) | at java.lang.reflect.Method.invoke(Method.java:324) | at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284) | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546) | at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:976) | at $Proxy0.start(Unknown Source) | at org.jboss.system.ServiceController.start(ServiceController.java:394) | at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source) | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) | at java.lang.reflect.Method.invoke(Method.java:324) | at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284) | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546) | at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177) | at $Proxy4.start(Unknown Source) | at org.jboss.deployment.SARDeployer.start(SARDeployer.java:226) | at org.jboss.deployment.MainDeployer.start(MainDeployer.java:832) | at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:642) | at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:605) | at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:589) | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) | at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) | at java.lang.reflect.Method.invoke(Method.java:324) | at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284) | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546) | at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177) | at $Proxy5.deploy(Unknown Source) | at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:384) | at org.jboss.system.server.ServerImpl.start(ServerImpl.java:291) | at org.jboss.Main.boot(Main.java:150) | at org.jboss.Main$1.run(Main.java:395) | at java.lang.Thread.run(Thread.java:534) | Caused by: java.sql.SQLException: Syntax error or access violation, message from server: "You have an error in your SQL syntax near 'SELECT TXID FROM JMS_TRANSACTIONS) AND TXOP='A'' at line 1" | at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1905) | at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1109) | at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1203) | at com.mysql.jdbc.Connection.execSQL(Connection.java:2090) | at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1680) | at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1527) | at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:324) | at org.jboss.mq.pm.jdbc2.PersistenceManager.resolveAllUncommitedTXs(PersistenceManager.java:309) | ... 68 more | 2004-03-19 00:04:09,187 WARN [org.jboss.system.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: Syntax error or access violation, message from server: "You have an error in your SQL syntax near 'SELECT TXID FROM JMS_TRANSACTIONS) AND TXOP='A'' at line 1") | at org.jboss.mq.pm.jdbc2.PersistenceManager.resolveAllUncommitedTXs(PersistenceManager.java:336) | at org.jboss.mq.pm.jdbc2.PersistenceManager.startService(PersistenceManager.java:1356) | at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192) | at sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source) | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) | at java.lang.reflect.Method.invoke(Method.java:324) | at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284) | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546) | at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:976) | at $Proxy14.start(Unknown Source) | at org.jboss.system.ServiceController.start(ServiceController.java:394) | at org.jboss.system.ServiceController.start(ServiceController.java:411) | at org.jboss.system.ServiceController.start(ServiceController.java:411) | at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source) | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) | at java.lang.reflect.Method.invoke(Method.java:324) | at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284) | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546) | at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177) | at $Proxy4.start(Unknown Source) | at org.jboss.deployment.SARDeployer.start(SARDeployer.java:226) | at org.jboss.deployment.MainDeployer.start(MainDeployer.java:832) | at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:642) | at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:605) | at sun.reflect.GeneratedMethodAccessor18.invoke(Unknown Source) | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) | at java.lang.reflect.Method.invoke(Method.java:324) | at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284) | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546) | at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177) | at $Proxy6.deploy(Unknown Source) | at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:302) | at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:476) | at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:201) | at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:274) | at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192) | at sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source) | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) | at java.lang.reflect.Method.invoke(Method.java:324) | at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284) | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546) | at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:976) | at $Proxy0.start(Unknown Source) | at org.jboss.system.ServiceController.start(ServiceController.java:394) | at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source) | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) | at java.lang.reflect.Method.invoke(Method.java:324) | at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284) | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546) | at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177) | at $Proxy4.start(Unknown Source) | at org.jboss.deployment.SARDeployer.start(SARDeployer.java:226) | at org.jboss.deployment.MainDeployer.start(MainDeployer.java:832) | at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:642) | at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:605) | at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:589) | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) | at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) | at java.lang.reflect.Method.invoke(Method.java:324) | at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284) | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546) | at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177) | at $Proxy5.deploy(Unknown Source) | at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:384) | at org.jboss.system.server.ServerImpl.start(ServerImpl.java:291) | at org.jboss.Main.boot(Main.java:150) | at org.jboss.Main$1.run(Main.java:395) | at java.lang.Thread.run(Thread.java:534) | Caused by: java.sql.SQLException: Syntax error or access violation, message from server: "You have an error in your SQL syntax near 'SELECT TXID FROM JMS_TRANSACTIONS) AND TXOP='A'' at line 1" | at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1905) | at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1109) | at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1203) | at com.mysql.jdbc.Connection.execSQL(Connection.java:2090) | at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1680) | at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1527) | at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:324) | at org.jboss.mq.pm.jdbc2.PersistenceManager.resolveAllUncommitedTXs(PersistenceManager.java:309) | ... 68 more | <a href="http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3826574#3826574">View the original post</a> <a href="http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3826574>Reply to the post</a> ------------------------------------------------------- This SF.Net email is sponsored by: IBM Linux Tutorials Free Linux tutorial presented by Daniel Robbins, President and CEO of GenToo technologies. Learn everything from fundamentals to system administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user