0 Replies Latest reply on Dec 4, 2002 11:25 AM by Bergmans Emmanuel

    Problem using mm mysql jdbc

    Bergmans Emmanuel Newbie

      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