Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.

Dismiss

Websphere MySql Connection Pools

3 views

Skip to first unread message

Tom O'Neil

unread,

Jan 7, 2003, 11:53:00 AM1/7/03

I have configured WAS Express 5.0 to connect to MySql 4.0, however I am
unable to open any connections. I know that the connection to the MySql
server works, because if I change any of the connection parameters (port,
database name, login), the JDBC driver returns the appropriate error
message. I have tried using both the MySql Connector 2.0.14 and 3.0.3 JDBC
drivers to connect. Within WAS 5.0, I have created a user-defined JDBC
provider and my datasource uses the
com.ibm.websphere.rsadapter.ConnectJDBCDataStoreHelper data source helper
class. The error I get is listed below (this was using MySql Connector
2.0.14). I get a similar error using 3.0.3, but that makes sense because the
beta documentation states that Connection.getTypeMap() has not been
implemented. Does anyone have any ideas as to what could be going on here?

Method createManagedConnctionWithMCWrapper caught an exception during
creation of the ManagedConnection for resource jdbc/raytheon, throwing
ResourceAllocationException. Original exception:
com.ibm.ws.exception.WsException: DSRA0080E: An exception was received by
the Data Store Adapter. See original exception message: null.
at
com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException.<init>(DataStoreAd
apterException.java:251)
at
com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException.<init>(DataStoreAd
apterException.java:172)
at
com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException.<init>(DataStoreAd
apterException.java:125)
at
com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.initializeConnectionProp
erties(WSRdbManagedConnectionImpl.java:584)
at
com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.<init>(WSRdbManagedConne
ctionImpl.java:359)
at
com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnect
ion(WSManagedConnectionFactoryImpl.java:506)
at
com.ibm.ejs.j2c.poolmanager.FreePool.createManagedConnectionWithMCWrapper(Fr
eePool.java:1106)
at
com.ibm.ejs.j2c.poolmanager.FreePool.createOrWaitForConnection(FreePool.java
:897)
at com.ibm.ejs.j2c.poolmanager.PoolManager.reserve(PoolManager.java:1065)
at
com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:5
60)
at
com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:
374)
at
com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.ja
va:205)
at
com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.ja
va:180)
at com.ds.data.ConnectionManager.getConnection(ConnectionManager.java:51)
at com.ds.business.navigation.NavControl.<init>(NavControl.java:57)
at com.ds.business.navigation.NavControl.init(NavControl.java:40)
at com.ds.business.util.AppSettings.init(AppSettings.java:33)
at com.ds.presentation.util.Application.init(Application.java:25)
at javax.servlet.GenericServlet.init(GenericServlet.java:258)
at
com.ibm.ws.webcontainer.servlet.StrictServletInstance.doInit(StrictServletIn
stance.java:82)
at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._init(StrictLifecycle
Servlet.java:147)
at
com.ibm.ws.webcontainer.servlet.PreInitializedServletState.init(StrictLifecy
cleServlet.java:270)
at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.init(StrictLifecycleS
ervlet.java:113)
at
com.ibm.ws.webcontainer.servlet.ServletInstance.init(ServletInstance.java:17
5)
at javax.servlet.GenericServlet.init(GenericServlet.java:258)
at
com.ibm.ws.webcontainer.webapp.WebAppServletManager.addServlet(WebAppServlet
Manager.java:761)
at
com.ibm.ws.webcontainer.webapp.WebAppServletManager.loadServlet(WebAppServle
tManager.java:257)
at
com.ibm.ws.webcontainer.webapp.WebAppServletManager.loadAutoLoadServlets(Web
AppServletManager.java:453)
at
com.ibm.ws.webcontainer.webapp.WebApp.loadServletManager(WebApp.java:1233)
at com.ibm.ws.webcontainer.webapp.WebApp.init(WebApp.java:273)
at com.ibm.ws.webcontainer.srt.WebGroup.loadWebApp(WebGroup.java:317)
at com.ibm.ws.webcontainer.srt.WebGroup.init(WebGroup.java:194)
at
com.ibm.ws.webcontainer.WebContainer.addWebApplication(WebContainer.java:950
)
at
com.ibm.ws.runtime.component.WebContainerImpl.install(WebContainerImpl.java:
133)
at
com.ibm.ws.runtime.component.WebContainerImpl.start(WebContainerImpl.java:36
0)
at
com.ibm.ws.runtime.component.ApplicationMgrImpl.start(ApplicationMgrImpl.jav
a:401)
at
com.ibm.ws.runtime.component.DeployedApplicationImpl.fireDeployedObjectStart
(DeployedApplicationImpl.java:743)
at
com.ibm.ws.runtime.component.DeployedModuleImpl.start(DeployedModuleImpl.jav
a:337)
at
com.ibm.ws.runtime.component.DeployedApplicationImpl.start(DeployedApplicati
onImpl.java:531)
at
com.ibm.ws.runtime.component.ApplicationMgrImpl.startApplication(Application
MgrImpl.java:254)
at
com.ibm.ws.runtime.component.ApplicationMgrImpl.start(ApplicationMgrImpl.jav
a:232)
at
com.ibm.ws.runtime.component.ContainerImpl.startComponents(ContainerImpl.jav
a:343)
at com.ibm.ws.runtime.component.ContainerImpl.start(ContainerImpl.java:234)
at
com.ibm.ws.runtime.component.ApplicationServerImpl.start(ApplicationServerIm
pl.java:117)
at
com.ibm.ws.runtime.component.ContainerImpl.startComponents(ContainerImpl.jav
a:343)
at com.ibm.ws.runtime.component.ContainerImpl.start(ContainerImpl.java:234)
at com.ibm.ws.runtime.component.ServerImpl.start(ServerImpl.java:182)
at com.ibm.ws.runtime.WsServer.start(WsServer.java:135)
at com.ibm.ws.runtime.WsServer.main(WsServer.java:232)
at java.lang.reflect.Method.invoke(Native Method)
at com.ibm.ws.bootstrap.WSLauncher.main(WSLauncher.java:94)
at
com.ibm.etools.websphere.tools.runner.api.ServerRunnerV5$1.run(ServerRunnerV
5.java:105)
---- Begin backtrace for nested exception
com.mysql.jdbc.jdbc2.NotImplemented
at com.mysql.jdbc.jdbc2.Connection.getTypeMap(Unknown Source)
at com.mysql.jdbc.jdbc2.optional.LogicalHandle.getTypeMap(Unknown Source)
at
com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.initializeConnectionProp
erties(WSRdbManagedConnectionImpl.java:579)
at
com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.<init>(WSRdbManagedConne
ctionImpl.java:359)
at
com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnect
ion(WSManagedConnectionFactoryImpl.java:506)
at
com.ibm.ejs.j2c.poolmanager.FreePool.createManagedConnectionWithMCWrapper(Fr
eePool.java:1106)
at
com.ibm.ejs.j2c.poolmanager.FreePool.createOrWaitForConnection(FreePool.java
:897)
at com.ibm.ejs.j2c.poolmanager.PoolManager.reserve(PoolManager.java:1065)
at
com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:5
60)
at
com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:
374)
at
com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.ja
va:205)
at
com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.ja
va:180)
at com.ds.data.ConnectionManager.getConnection(ConnectionManager.java:51)
at com.ds.business.navigation.NavControl.<init>(NavControl.java:57)
at com.ds.business.navigation.NavControl.init(NavControl.java:40)
at com.ds.business.util.AppSettings.init(AppSettings.java:33)
at com.ds.presentation.util.Application.init(Application.java:25)
at javax.servlet.GenericServlet.init(GenericServlet.java:258)
at
com.ibm.ws.webcontainer.servlet.StrictServletInstance.doInit(StrictServletIn
stance.java:82)
at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._init(StrictLifecycle
Servlet.java:147)
at
com.ibm.ws.webcontainer.servlet.PreInitializedServletState.init(StrictLifecy
cleServlet.java:270)
at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.init(StrictLifecycleS
ervlet.java:113)
at
com.ibm.ws.webcontainer.servlet.ServletInstance.init(ServletInstance.java:17
5)
at javax.servlet.GenericServlet.init(GenericServlet.java:258)
at
com.ibm.ws.webcontainer.webapp.WebAppServletManager.addServlet(WebAppServlet
Manager.java:761)
at
com.ibm.ws.webcontainer.webapp.WebAppServletManager.loadServlet(WebAppServle
tManager.java:257)
at
com.ibm.ws.webcontainer.webapp.WebAppServletManager.loadAutoLoadServlets(Web
AppServletManager.java:453)
at
com.ibm.ws.webcontainer.webapp.WebApp.loadServletManager(WebApp.java:1233)
at com.ibm.ws.webcontainer.webapp.WebApp.init(WebApp.java:273)
at com.ibm.ws.webcontainer.srt.WebGroup.loadWebApp(WebGroup.java:317)
at com.ibm.ws.webcontainer.srt.WebGroup.init(WebGroup.java:194)
at
com.ibm.ws.webcontainer.WebContainer.addWebApplication(WebContainer.java:950
)
at
com.ibm.ws.runtime.component.WebContainerImpl.install(WebContainerImpl.java:
133)
at
com.ibm.ws.runtime.component.WebContainerImpl.start(WebContainerImpl.java:36
0)
at
com.ibm.ws.runtime.component.ApplicationMgrImpl.start(ApplicationMgrImpl.jav
a:401)
at
com.ibm.ws.runtime.component.DeployedApplicationImpl.fireDeployedObjectStart
(DeployedApplicationImpl.java:743)
at
com.ibm.ws.runtime.component.DeployedModuleImpl.start(DeployedModuleImpl.jav
a:337)
at
com.ibm.ws.runtime.component.DeployedApplicationImpl.start(DeployedApplicati
onImpl.java:531)
at
com.ibm.ws.runtime.component.ApplicationMgrImpl.startApplication(Application
MgrImpl.java:254)
at
com.ibm.ws.runtime.component.ApplicationMgrImpl.start(ApplicationMgrImpl.jav
a:232)
at
com.ibm.ws.runtime.component.ContainerImpl.startComponents(ContainerImpl.jav
a:343)
at com.ibm.ws.runtime.component.ContainerImpl.start(ContainerImpl.java:234)
at
com.ibm.ws.runtime.component.ApplicationServerImpl.start(ApplicationServerIm
pl.java:117)
at
com.ibm.ws.runtime.component.ContainerImpl.startComponents(ContainerImpl.jav
a:343)
at com.ibm.ws.runtime.component.ContainerImpl.start(ContainerImpl.java:234)
at com.ibm.ws.runtime.component.ServerImpl.start(ServerImpl.java:182)
at com.ibm.ws.runtime.WsServer.start(WsServer.java:135)
at com.ibm.ws.runtime.WsServer.main(WsServer.java:232)
at java.lang.reflect.Method.invoke(Native Method)
at com.ibm.ws.bootstrap.WSLauncher.main(WSLauncher.java:94)
at
com.ibm.etools.websphere.tools.runner.api.ServerRunnerV5$1.run(ServerRunnerV
5.java:105)
Next Linked Exception:
com.mysql.jdbc.jdbc2.NotImplemented
at com.mysql.jdbc.jdbc2.Connection.getTypeMap(Unknown Source)
at com.mysql.jdbc.jdbc2.optional.LogicalHandle.getTypeMap(Unknown Source)
at
com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.initializeConnectionProp
erties(WSRdbManagedConnectionImpl.java:579)
at
com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.<init>(WSRdbManagedConne
ctionImpl.java:359)
at
com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnect
ion(WSManagedConnectionFactoryImpl.java:506)
at
com.ibm.ejs.j2c.poolmanager.FreePool.createManagedConnectionWithMCWrapper(Fr
eePool.java:1106)
at
com.ibm.ejs.j2c.poolmanager.FreePool.createOrWaitForConnection(FreePool.java
:897)
at com.ibm.ejs.j2c.poolmanager.PoolManager.reserve(PoolManager.java:1065)
at
com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:5
60)
at
com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:
374)
at
com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.ja
va:205)
at
com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.ja
va:180)
at com.ds.data.ConnectionManager.getConnection(ConnectionManager.java:51)
at com.ds.business.navigation.NavControl.<init>(NavControl.java:57)
at com.ds.business.navigation.NavControl.init(NavControl.java:40)
at com.ds.business.util.AppSettings.init(AppSettings.java:33)
at com.ds.presentation.util.Application.init(Application.java:25)
at javax.servlet.GenericServlet.init(GenericServlet.java:258)
at
com.ibm.ws.webcontainer.servlet.StrictServletInstance.doInit(StrictServletIn
stance.java:82)
at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._init(StrictLifecycle
Servlet.java:147)
at
com.ibm.ws.webcontainer.servlet.PreInitializedServletState.init(StrictLifecy
cleServlet.java:270)
at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.init(StrictLifecycleS
ervlet.java:113)
at
com.ibm.ws.webcontainer.servlet.ServletInstance.init(ServletInstance.java:17
5)
at javax.servlet.GenericServlet.init(GenericServlet.java:258)
at
com.ibm.ws.webcontainer.webapp.WebAppServletManager.addServlet(WebAppServlet
Manager.java:761)
at
com.ibm.ws.webcontainer.webapp.WebAppServletManager.loadServlet(WebAppServle
tManager.java:257)
at
com.ibm.ws.webcontainer.webapp.WebAppServletManager.loadAutoLoadServlets(Web
AppServletManager.java:453)
at
com.ibm.ws.webcontainer.webapp.WebApp.loadServletManager(WebApp.java:1233)
at com.ibm.ws.webcontainer.webapp.WebApp.init(WebApp.java:273)
at com.ibm.ws.webcontainer.srt.WebGroup.loadWebApp(WebGroup.java:317)
at com.ibm.ws.webcontainer.srt.WebGroup.init(WebGroup.java:194)
at
com.ibm.ws.webcontainer.WebContainer.addWebApplication(WebContainer.java:950
)
at
com.ibm.ws.runtime.component.WebContainerImpl.install(WebContainerImpl.java:
133)
at
com.ibm.ws.runtime.component.WebContainerImpl.start(WebContainerImpl.java:36
0)
at
com.ibm.ws.runtime.component.ApplicationMgrImpl.start(ApplicationMgrImpl.jav
a:401)
at
com.ibm.ws.runtime.component.DeployedApplicationImpl.fireDeployedObjectStart
(DeployedApplicationImpl.java:743)
at
com.ibm.ws.runtime.component.DeployedModuleImpl.start(DeployedModuleImpl.jav
a:337)
at
com.ibm.ws.runtime.component.DeployedApplicationImpl.start(DeployedApplicati
onImpl.java:531)
at
com.ibm.ws.runtime.component.ApplicationMgrImpl.startApplication(Application
MgrImpl.java:254)
at
com.ibm.ws.runtime.component.ApplicationMgrImpl.start(ApplicationMgrImpl.jav
a:232)
at
com.ibm.ws.runtime.component.ContainerImpl.startComponents(ContainerImpl.jav
a:343)
at com.ibm.ws.runtime.component.ContainerImpl.start(ContainerImpl.java:234)
at
com.ibm.ws.runtime.component.ApplicationServerImpl.start(ApplicationServerIm
pl.java:117)
at
com.ibm.ws.runtime.component.ContainerImpl.startComponents(ContainerImpl.jav
a:343)
at com.ibm.ws.runtime.component.ContainerImpl.start(ContainerImpl.java:234)
at com.ibm.ws.runtime.component.ServerImpl.start(ServerImpl.java:182)
at com.ibm.ws.runtime.WsServer.start(WsServer.java:135)
at com.ibm.ws.runtime.WsServer.main(WsServer.java:232)
at java.lang.reflect.Method.invoke(Native Method)
at com.ibm.ws.bootstrap.WSLauncher.main(WSLauncher.java:94)
at
com.ibm.etools.websphere.tools.runner.api.ServerRunnerV5$1.run(ServerRunnerV
5.java:105)

Rohit Singh

unread,

Jan 12, 2003, 10:04:35 PM1/12/03

Look at this

http://publib7b.boulder.ibm.com/wasinfo1/en/info/aes/ae/rdat_datstorexmp.html

Peter Nightingale

unread,

Jan 19, 2003, 5:04:55 PM1/19/03

Please tell me that someone has coded up the helper class for mysql by
now... the example looks like I would have to spend more then 5 minutes on
this...

Same as earlier post - no problems using a was 4.0 WTE/datasource, stuck
trying to get to the 5.0 WTE/datasource

Any tips appreciated..

peter

"Rohit Singh" <roh...@nospam.america.ibm.com> wrote in message
news:avta3s$3jci$1...@news.boulder.ibm.com...
> Look at this
>
>
http://publib7b.boulder.ibm.com/wasinfo1/en/info/aes/ae/rdat_datstorexmp.htm

0 new messages