8 Replies Latest reply on May 31, 2004 7:37 PM by Adrian Brock

    Connection errors using Connector/J 3.0.13 with JBoss/MySQL

    Tim Bauer Novice

      I was previously using Connector/J 3.0.11 and have been for a long time...I just replaced the 3.0.11 jar with 3.0.13 and now JBoss 3.2.4RC2 barfs big time.....I know my configuration is correct, so I'm wondering if this is a JBoss problem with that jdbc driver or one that should be submitted to mysql.org??

      at java.lang.Thread.run(Thread.java:552)
      Caused by: java.sql.SQLException: Cannot load connection class because of underlying exception: 'java.lang.NumberFormatException: For input string: "localhost"'.
      at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:409)
      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:158)
      ... 132 more
      07:10:17,749 ERROR [EntityContainer] Starting failed jboss.j2ee:jndiName=icsCorp/CorpTZLocales,service=EJB
      org.jboss.deployment.DeploymentException: Error while fixing table name; - nested throwable: (org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (java.sql.SQLException: Cannot load connection class because of underlying exception: 'java.lang.NumberFormatException: For input string: "localhost"'.); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Cannot load connection class because of underlying exception: 'java.lang.NumberFormatException: For input string: "localhost"'.)))

        • 1. Re: Connection errors using Connector/J 3.0.13 with JBoss/My
          Adrian Brock Master

          Thanks for the information, although I'm not sure what you want me to do with it?

          Care to post something useful like your config?

          PLEASE make an effort to understand the problem and what we might need
          to help you.

          We do not play 20 questions here.

          • 2. Re: Connection errors using Connector/J 3.0.13 with JBoss/My
            Tim Bauer Novice

            Uhh, well, what I want to know is whether there is a bug in Connector/J 3.0.13 or is there another NEW "feature" in jboss 3.2.4FC2 that causes the connections to fail??????????

            With Connector/J 3.0.13 I get a connection errors...If I stop the server, and replace it with 3.0.11 everything works fine....

            Here's my datasource config:


            <local-tx-datasource>
            <jndi-name>ICSRegDS</jndi-name>
            <connection-url>jdbc:mysql://localhost/icsboomerang?useUnicode=true&amp;characterEncoding=UTF8</connection-url>
            <driver-class>com.mysql.jdbc.Driver</driver-class>
            <user-name>icsbisadmin</user-name>
            1sqlmgr
            <min-pool-size>50</min-pool-size>
            <max-pool-size>100</max-pool-size>
            <blocking-timeout-millis>10000</blocking-timeout-millis>
            <idle-timeout-minutes>15</idle-timeout-minutes>
            </local-tx-datasource>



            • 3. Re: Connection errors using Connector/J 3.0.13 with JBoss/My
              Adrian Brock Master

              I think from the error message (it is hard to tell since you don't post the full stacktrace)
              that the mysql driver is trying to parse "localhost" as a number.

              So either:
              1) you have the url wrong
              2) it is a bug in their driver

              • 4. Re: Connection errors using Connector/J 3.0.13 with JBoss/My
                Tim Bauer Novice

                1). I doubt it.
                2). Possibly. I have submitted a bug to Mark Mathews at mysql.org

                • 5. Re: Connection errors using Connector/J 3.0.13 with JBoss/My
                  Tim Bauer Novice

                  Here's some more detailed information....Hopefully someone can actually look into the code rather than just post terse(snippy) comments:

                  >>> Here's my datasource configuration: works with Connector/J 3.0.11


                  <local-tx-datasource>
                  <jndi-name>ICSRegDS</jndi-name>
                  <connection-url>jdbc:mysql://localhost/icsboomerang?useUnicode=true&amp;characterEncoding=UTF8</connection-url>
                  <driver-class>com.mysql.jdbc.Driver</driver-class>
                  <user-name>icsbisadmin</user-name>
                  1sqlmgr
                  <min-pool-size>50</min-pool-size>
                  <max-pool-size>100</max-pool-size>
                  <blocking-timeout-millis>10000</blocking-timeout-millis>
                  <idle-timeout-minutes>15</idle-timeout-minutes>
                  </local-tx-datasource>



                  >>> Here's the errors throw using Connector/J 3.0.13

                  2004-05-29 09:10:51,529 DEBUG [class org.jboss.cache.invalidation.InvalidationManager$InvalidationGroupImpl.CorpTZLocalesBean] Counter reference value (++): 1
                  2004-05-29 09:10:52,393 WARN [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Throwable while attempting to get a new connection: null
                  org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Cannot load connection class because of underlying exception: 'java.lang.NumberFormatException: For input string: "localhost"'.)
                  at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:168)
                  at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:504)
                  at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:214)
                  at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:532)
                  at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:442)
                  at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:312)
                  at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:494)
                  at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:885)
                  at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:102)
                  at org.jboss.ejb.plugins.cmp.jdbc.SQLUtil.fixTableName(SQLUtil.java:128)
                  at org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCEntityBridge.init(JDBCEntityBridge.java:147)
                  at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.initStoreManager(JDBCStoreManager.java:428)
                  at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:365)
                  at org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:147)
                  at org.jboss.ejb.EntityContainer.startService(EntityContainer.java:337)
                  at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:271)
                  at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:221)
                  at sun.reflect.GeneratedMethodAccessor2.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:60)
                  at org.jboss.mx.server.Invocation.dispatch(Invocation.java:61)
                  at org.jboss.mx.server.Invocation.dispatch(Invocation.java:53)
                  at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
                  at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:186)
                  at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:466)
                  at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:837)
                  at $Proxy16.start(Unknown Source)
                  at org.jboss.system.ServiceController.start(ServiceController.java:367)
                  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:60)
                  at org.jboss.mx.server.Invocation.dispatch(Invocation.java:61)
                  at org.jboss.mx.server.Invocation.dispatch(Invocation.java:53)
                  at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
                  at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:186)
                  at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:466)
                  at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:174)
                  at $Proxy49.start(Unknown Source)
                  at org.jboss.ejb.EjbModule.startService(EjbModule.java:331)
                  at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:271)
                  at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:221)
                  at sun.reflect.GeneratedMethodAccessor2.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:60)
                  at org.jboss.mx.server.Invocation.dispatch(Invocation.java:61)
                  at org.jboss.mx.server.Invocation.dispatch(Invocation.java:53)
                  at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
                  at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:186)
                  at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:466)
                  at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:837)
                  at $Proxy16.start(Unknown Source)
                  at org.jboss.system.ServiceController.start(ServiceController.java:367)
                  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:60)
                  at org.jboss.mx.server.Invocation.dispatch(Invocation.java:61)
                  at org.jboss.mx.server.Invocation.dispatch(Invocation.java:53)
                  at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
                  at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:186)
                  at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:466)
                  at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:174)
                  at $Proxy14.start(Unknown Source)
                  at org.jboss.ejb.EJBDeployer.start(EJBDeployer.java:546)
                  at org.jboss.deployment.MainDeployer.start(MainDeployer.java:836)
                  at org.jboss.deployment.MainDeployer.start(MainDeployer.java:828)
                  at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:645)
                  at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:608)
                  at sun.reflect.GeneratedMethodAccessor16.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:60)
                  at org.jboss.mx.server.Invocation.dispatch(Invocation.java:61)
                  at org.jboss.mx.server.Invocation.dispatch(Invocation.java:53)
                  at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
                  at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:186)
                  at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:466)
                  at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:174)
                  at $Proxy7.deploy(Unknown Source)
                  at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:304)
                  at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:478)
                  at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:201)
                  at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:274)
                  at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:271)
                  at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:221)
                  at sun.reflect.GeneratedMethodAccessor2.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:60)
                  at org.jboss.mx.server.Invocation.dispatch(Invocation.java:61)
                  at org.jboss.mx.server.Invocation.dispatch(Invocation.java:53)
                  at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
                  at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:186)
                  at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:466)
                  at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:837)
                  at $Proxy0.start(Unknown Source)
                  at org.jboss.system.ServiceController.start(ServiceController.java:367)
                  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:60)
                  at org.jboss.mx.server.Invocation.dispatch(Invocation.java:61)
                  at org.jboss.mx.server.Invocation.dispatch(Invocation.java:53)
                  at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
                  at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:186)
                  at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:466)
                  at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:174)
                  at $Proxy4.start(Unknown Source)
                  at org.jboss.deployment.SARDeployer.start(SARDeployer.java:251)
                  at org.jboss.deployment.MainDeployer.start(MainDeployer.java:836)
                  at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:645)
                  at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:608)
                  at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:592)
                  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                  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:60)
                  at org.jboss.mx.server.Invocation.dispatch(Invocation.java:61)
                  at org.jboss.mx.server.Invocation.dispatch(Invocation.java:53)
                  at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
                  at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:186)
                  at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:466)
                  at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:174)
                  at $Proxy5.deploy(Unknown Source)
                  at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:404)
                  at org.jboss.system.server.ServerImpl.start(ServerImpl.java:311)
                  at org.jboss.Main.boot(Main.java:144)
                  at org.jboss.Main$1.run(Main.java:389)
                  at java.lang.Thread.run(Thread.java:552)
                  Caused by: java.sql.SQLException: Cannot load connection class because of underlying exception: 'java.lang.NumberFormatException: For input string: "localhost"'.
                  at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:409)
                  at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:158)
                  ... 132 more

                  • 6. Re: Connection errors using Connector/J 3.0.13 with JBoss/My
                    Adrian Brock Master

                    If you post terse/snippy/incomplete questions you get terse/snippy/incomplete
                    answers.

                    http://www.jboss.org/wiki/Wiki.jsp?page=JBossForums

                    Yes, the problem is in the mysql driver:

                    Caused by: java.sql.SQLException: Cannot load connection class because of underlying exception: 'java.lang.NumberFormatException: For input string: "localhost"'.
                    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:409)
                    at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:158)

                    I bet you it works if you use 127.0.0.1 :-)

                    • 7. Re: Connection errors using Connector/J 3.0.13 with JBoss/My
                      Tim Bauer Novice

                      [31 May 1:11pm] Mark Matthews
                      This is a known issue which was solved in 3.0.14 which was posted the same day
                      as the release of 3.0.13

                      BTW, in review of dozens of responses in THIS forum, I'd say I'm not the one with the attitude problem...Look at your responses to users who are just asking honest/valid questions.

                      • 8. Re: Connection errors using Connector/J 3.0.13 with JBoss/My
                        Adrian Brock Master

                        You missed the adjectives repeated and incomplete.

                        Read "READ THIS FIRST" or the FAQ in the JBossMQ forum if you are
                        in any doubt about my attitude towards lazy users.