Problem using mm mysql jdbc
I got a problem to establish a mm mysql jdbc connection with jboss. All kind of help is welcome. See settings and description
below
System configuration
--------------------
mysql-jdbc-mm-2.0.14
jdk-1.3.1p7_1
JBoss-2.4.9_Tomcat-4.0.4
Problem
--------
JBOSS seems to have a problem to establish the mysql link with datasource mySQLDS.
I got JBOSS errors ([INFO,mySQLDS] XA Connection pool mySQLDS bound to java:/mySQLDS [ERROR,mySQLDS] Stopped) and I don't see any attempt in the mysql log. I don't have any problem to connect to the mysql user with the login/pwd (with command line mysql client)
In server log
[...]
[INFO,JdbcProvider] Initializing
[INFO,JdbcProvider] Loaded JDBC-driver:org.gjt.mm.mysql.Driver
[INFO,JdbcProvider] Initialized
[INFO,mySQLDS] Initializing
[INFO,mySQLDS] Initialized
[...]
[INFO,JdbcProvider] Starting
[INFO,JdbcProvider] Started
[INFO,mySQLDS] Starting
[INFO,mySQLDS] XA Connection pool mySQLDS bound to java:/mySQLDS
[ERROR,mySQLDS] Stopped
java.lang.RuntimeException: No ManagedConnections Available!
at org.jboss.pool.ObjectPool.getObject(ObjectPool.java:687)
at org.jboss.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSource.java:242)
at org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java:445)
at org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:103)
at java.lang.reflect.Method.invoke(Native Method)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
at org.jboss.configuration.ConfigurationService$ServiceProxy.invoke(ConfigurationService.java:967)
at $Proxy0.start(Unknown Source)
at org.jboss.util.ServiceControl.start(ServiceControl.java:79)
at java.lang.reflect.Method.invoke(Native Method)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
at org.jboss.Main.(Main.java:209)
at org.jboss.Main$1.run(Main.java:110)
at java.security.AccessController.doPrivileged(Native Method)
at org.jboss.Main.main(Main.java:106)
[ERROR,ConfigurationService] Unexpected error
java.lang.RuntimeException: No ManagedConnections Available!
at org.jboss.pool.ObjectPool.getObject(ObjectPool.java:687)
at org.jboss.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSource.java:242)
at org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java:445)
at org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:103)
at java.lang.reflect.Method.invoke(Native Method)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
at org.jboss.configuration.ConfigurationService$ServiceProxy.invoke(ConfigurationService.java:967)
at $Proxy0.start(Unknown Source)
at org.jboss.util.ServiceControl.start(ServiceControl.java:79)
at java.lang.reflect.Method.invoke(Native Method)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
at org.jboss.Main.(Main.java:209)
at org.jboss.Main$1.run(Main.java:110)
at java.security.AccessController.doPrivileged(Native Method)
at org.jboss.Main.main(Main.java:106)
[...]
jboss.conf
----------
at the end of the file
[...]
jboss.jcml
----------
[...]
org.gjt.mm.mysql.Driver
org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl</attr
ibute>
mySQLDS
jdbc:mysql://localhost:3306/[db_name]
[db_user_name]
[db_pwd]
[...]
Thanks in advance