JBoss 4.0 and MySQL Configuration
osganian Feb 6, 2004 7:12 AMI'm having a problem configuring MySQL with JBoss 4.0. The same configuration that works for JBoss 3.2.3 doesn't work. I get the following exceptions when deploying the mysql-ds.xml file in the default/deploy directory:
<local-tx-datasource>
<jndi-name>DefaultDS</jndi-name>
<connection-url>jdbc:mysql://localhost:3306/X</connection-url>
<driver-class>org.gjt.mm.mysql.Driver</driver-class>
<user-name>root</user-name>
</local-tx-datasource>
Exception:
2004-02-05 15:40:02,893 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: (org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (java.sql.SQLException: Can not issue empty query); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Can not issue empty query)))
2004-02-05 15:40:02,893 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: (org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (java.sql.SQLException: Can not issue empty query); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Can not issue empty query)))
at org.jboss.mq.pm.jdbc2.PersistenceManager.resolveAllUncommitedTXs(PersistenceManager.java:287)
at org.jboss.mq.pm.jdbc2.PersistenceManager.startService(PersistenceManager.java:1255)
at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:233)
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.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:72)
...
Caused by: org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (java.sql.SQLException: Can not issue empty query); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Can not issue empty query))
Caused by: org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Can not issue empty query)
Caused by: java.sql.SQLException: Can not issue empty query
Now, 3.2.3 had a mysql-jdbc2-service.xml file deployed in the default/deploy/jms directory but I don't see a corresponding one for the 4.0 installation.
Anybody have any ideas or has successfully configured 4.0 with mySQL?
Thanks for any help,
Mike