| 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: | |
| 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 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&
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
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& 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>