"create cached table" is a hypersonic specific feature. Look in docs/examples/jms for the mysql configuration
Regards, Adrian On Tue, 2004-01-20 at 11:47, [EMAIL PROTECTED] wrote: > Hi, > > I configured Jboss to use MySQL to persist JMS messages. > On startup, I get the following message: > > --------------------------------------- > 12:39:29,515 ERROR [PersistenceManager] Starting failed > org.jboss.mq.SpyJMSException: Could not resolve uncommited transactions. > Messag > e recovery may not be accurate; - nested throwable: > (java.sql.SQLException: Gene > ral error, message from server: "Table 'test.jms_messages' doesn't exist") > at > org.jboss.mq.pm.jdbc2.PersistenceManager.resolveAllUncommitedTXs(Pers > istenceManager.java:336) > at > org.jboss.mq.pm.jdbc2.PersistenceManager.startService(PersistenceMana > ger.java:1356) > at > org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:1 > 92) > at sun.reflect.GeneratedMethodAccessor20.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces > sorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:324) > at > org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBea > nDispatcher.java:284) > at > org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546) > at > org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceControl > ler.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.GeneratedMethodAccessor5.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces > sorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:324) > at > org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBea > nDispatcher.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.GeneratedMethodAccessor22.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces > sorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:324) > at > org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBea > nDispatcher.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(URLDeploymen > tScanner.java:302) > at > org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentS > canner.java:476) > at > org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread. > doScan(AbstractDeploymentScanner.java:201) > at > org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(A > bstractDeploymentScanner.java:274) > at > org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:1 > 92) > at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces > sorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:324) > at > org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBea > nDispatcher.java:284) > at > org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546) > at > org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceControl > ler.java:976) > at $Proxy0.start(Unknown Source) > at > org.jboss.system.ServiceController.start(ServiceController.java:394) > at sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces > sorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:324) > at > org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBea > nDispatcher.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(DelegatingMethodAcces > sorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:324) > at > org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBea > nDispatcher.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: General error, message from server: > "Table 't > est.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.executeUpdat > e(WrappedPreparedStatement.java:321) > at > org.jboss.mq.pm.jdbc2.PersistenceManager.resolveAllUncommitedTXs(Pers > istenceManager.java:309) > ... 68 more > 12:39:29,999 WARN [ServiceController] Problem starting service > jboss.mq:service > =PersistenceManager > org.jboss.mq.SpyJMSException: Could not resolve uncommited transactions. > Messag > e recovery may not be accurate; - nested throwable: > (java.sql.SQLException: Gene > ral error, message from server: "Table 'test.jms_messages' doesn't exist") > at > org.jboss.mq.pm.jdbc2.PersistenceManager.resolveAllUncommitedTXs(Pers > istenceManager.java:336) > at > org.jboss.mq.pm.jdbc2.PersistenceManager.startService(PersistenceMana > ger.java:1356) > at > org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:1 > 92) > at sun.reflect.GeneratedMethodAccessor20.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces > sorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:324) > at > org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBea > nDispatcher.java:284) > at > org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546) > at > org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceControl > ler.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.GeneratedMethodAccessor5.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces > sorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:324) > at > org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBea > nDispatcher.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.GeneratedMethodAccessor22.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces > sorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:324) > at > org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBea > nDispatcher.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(URLDeploymen > tScanner.java:302) > at > org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentS > canner.java:476) > at > org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread. > doScan(AbstractDeploymentScanner.java:201) > at > org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(A > bstractDeploymentScanner.java:274) > at > org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:1 > 92) > at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces > sorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:324) > at > org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBea > nDispatcher.java:284) > at > org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546) > at > org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceControl > ler.java:976) > at $Proxy0.start(Unknown Source) > at > org.jboss.system.ServiceController.start(ServiceController.java:394) > at sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces > sorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:324) > at > org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBea > nDispatcher.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(DelegatingMethodAcces > sorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:324) > at > org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBea > nDispatcher.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: General error, message from server: > "Table 't > est.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.executeUpdat > e(WrappedPreparedStatement.java:321) > at > org.jboss.mq.pm.jdbc2.PersistenceManager.resolveAllUncommitedTXs(Pers > istenceManager.java:309) > ... 68 more > ------------------------------------------------------ > > I seems like JBoss is not even attemping to create the tables, > because inserting a error in the line CREATE_MESSAGE_TABLE = ... > doesn't result in an error message. > > The configuration is as follows: > ------------------------------------------------------ > <mbean code="org.jboss.mq.pm.jdbc2.PersistenceManager" > name="jboss.mq:service=PersistenceManager"> > <depends > optional-attribute-name="ConnectionManager">jboss.jca:service=LocalTxCM,name=mySQL_jms</depends> > <attribute name="SqlProperties"> > BLOB_TYPE=OBJECT_BLOB > INSERT_TX = INSERT INTO JMS_TRANSACTIONS (TXID) values(?) > INSERT_MESSAGE = INSERT INTO JMS_MESSAGES (MESSAGEID, DESTINATION, > MESSAGEBLOB, TXID, TXOP) VALUES(?,?,?,?,?) > SELECT_ALL_UNCOMMITED_TXS = SELECT TXID FROM JMS_TRANSACTIONS > SELECT_MAX_TX = SELECT MAX(TXID) FROM JMS_MESSAGES > SELECT_MESSAGES_IN_DEST = SELECT MESSAGEID, MESSAGEBLOB FROM > JMS_MESSAGES WHERE DESTINATION=? > SELECT_MESSAGE = SELECT MESSAGEID, MESSAGEBLOB FROM JMS_MESSAGES > WHERE MESSAGEID=? AND DESTINATION=? > MARK_MESSAGE = UPDATE JMS_MESSAGES SET TXID=?, TXOP=? WHERE > MESSAGEID=? AND DESTINATION=? > UPDATE_MESSAGE = UPDATE JMS_MESSAGES SET MESSAGEBLOB=? WHERE > MESSAGEID=? AND DESTINATION=? > UPDATE_MARKED_MESSAGES = UPDATE JMS_MESSAGES SET TXID=?, TXOP=? > WHERE TXOP=? > UPDATE_MARKED_MESSAGES_WITH_TX = UPDATE JMS_MESSAGES SET TXID=?, > TXOP=? WHERE TXOP=? AND TXID=? > DELETE_MARKED_MESSAGES_WITH_TX = DELETE JMS_MESSAGES FROM > JMS_MESSAGES,JMS_TRANSACTIONS WHERE \ > JMS_MESSAGES.TXID=JMS_TRANSACTIONS.TXID AND JMS_MESSAGES.TXOP=? > DELETE_TX = DELETE FROM JMS_TRANSACTIONS WHERE TXID = ? > DELETE_MARKED_MESSAGES = DELETE FROM JMS_MESSAGES WHERE TXID=? AND > TXOP=? > DELETE_MESSAGE = DELETE FROM JMS_MESSAGES WHERE MESSAGEID=? AND > DESTINATION=? > CREATE_MESSAGE_TABLE = CREATE CACHED TABLE JMS_MESSAGES ( MESSAGEID > INTEGER NOT NULL, \ > DESTINATION VARCHAR(255) NOT NULL, TXID INTEGER, TXOP CHAR(1), \ > MEDIUMBLOB OBJECT, PRIMARY KEY (MESSAGEID, DESTINATION) ) > CREATE_TX_TABLE = CREATE CACHED TABLE JMS_TRANSACTIONS ( TXID INTEGER ) > CREATE_TABLES_ON_STARTUP = TRUE > </attribute> > </mbean> > --------------------------------- > The datasource is configured as follows: > ----------------------------------------- > <local-tx-datasource> > <jndi-name>mySQL_jms</jndi-name> > <connection-url>jdbc:mysql://xcaew319.rwg/test</connection-url> > <driver-class>org.gjt.mm.mysql.Driver</driver-class> > <user-name>jboss</user-name> > <password>jboss</password> > </local-tx-datasource> > > Any help is really appreciated! > > btw. I used the "test" database in mySQL because this db allows > anything for everybody by default. > > Thanks in advance > > Stefan > > > ------------------------------------------------------- > The SF.Net email is sponsored by EclipseCon 2004 > Premiere Conference on Open Tools Development and Integration > See the breadth of Eclipse activity. February 3-5 in Anaheim, CA. > http://www.eclipsecon.org/osdn > _______________________________________________ > 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 ------------------------------------------------------- The SF.Net email is sponsored by EclipseCon 2004 Premiere Conference on Open Tools Development and Integration See the breadth of Eclipse activity. February 3-5 in Anaheim, CA. http://www.eclipsecon.org/osdn _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user