-
1. Re: Connection errors using Connector/J 3.0.13 with JBoss/My
adrian.brock May 29, 2004 11:28 AM (in response to tbauer)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
tbauer May 29, 2004 11:32 AM (in response to tbauer)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&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 May 29, 2004 11:55 AM (in response to tbauer)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
tbauer May 29, 2004 12:00 PM (in response to tbauer)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
tbauer May 29, 2004 12:17 PM (in response to tbauer)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&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 May 29, 2004 12:22 PM (in response to tbauer)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
tbauer May 31, 2004 5:54 PM (in response to tbauer)[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 May 31, 2004 7:37 PM (in response to tbauer)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.