-----Ursprüngliche Nachricht-----
Von:
[EMAIL PROTECTED] im Auftrag
von [EMAIL PROTECTED]
Gesendet: Di 20.01.2004 12:47
An: [EMAIL PROTECTED]
Cc:
Betreff: [JBoss-user] JBoss MQ doesnt create tables on
mySQL
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
