Bug #3932 Connector/J 3.0.13 not working with JBoss 3.2.4FC2
Submitted: 29 May 2004 16:52 Modified: 31 May 2004 22:11
Reporter: Tim Bauer Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / J Severity:S2 (Serious)
Version:3.0.13 OS:MacOS (Mac OS X 10.3.4)
Assigned to: Mark Matthews CPU Architecture:Any

[29 May 2004 16:52] Tim Bauer
Description:
Mark,  I just downloaded and installed the 3.0.13 jar into my lib directory and now when JBoss starts up 
it starts throwing a ton of errors.  If I stop it, and replace 3.0.13 with 3.0.11 then everything is fine 
again... Here is a small amount of the trace that JBoss is dumping...I can send more...

        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"'.)))

How to repeat:
Here is my JBoss datasource file...
<datasources>
  <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>xxxxx</user-name>
    <password>xxxxx</password>
    <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>
    
</datasources>
[29 May 2004 18:17] Tim Bauer
Here's a much more detailed description:

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

<datasources>
  <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>
    <password>1sqlmgr</password>
    <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>
    
</datasources>

>>> 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(Local
ManagedConnectionFactory.java:168)
	at 
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(
InternalManagedConnectionPool.java:504)
	at 
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManage
dConnectionPool.java:214)
	at 
org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossMa
nagedConnectionPool.java:532)
	at 
org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnecti
onManager2.java:442)
	at 
org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionMa
nager.java:312)
	at 
org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionM
anager2.java:494)
	at 
org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateCo
nnection(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(AbstractDeployment
Scanner.java:201)
	at 
org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.jav
a: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(Local
ManagedConnectionFactory.java:158)
	... 132 more
[31 May 2004 22:11] 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
[31 May 2004 23:51] Tim Bauer
Mark, thanks so much...I dropped 3.0.14 in the lib directory and all seems fine..

cheers, tim