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>(DataStoreAdapterException.java:251) at com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException.<init>(DataStoreAdapterException.java:172) at com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException.<init>(DataStoreAdapterException.java:125) at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.initializeConnectionProperties(WSRdbManagedConnectionImpl.java:584) at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.<init>(WSRdbManagedConnectionImpl.java:359) at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnection(WSManagedConnectionFactoryImpl.java:506) at com.ibm.ejs.j2c.poolmanager.FreePool.createManagedConnectionWithMCWrapper(FreePool.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:560) at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:374) at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:205) at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java: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(StrictServletInstance.java:82) at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._init(StrictLifecycleServlet.java:147) at com.ibm.ws.webcontainer.servlet.PreInitializedServletState.init(StrictLifecycleServlet.java:270) at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.init(StrictLifecycleServlet.java:113) at com.ibm.ws.webcontainer.servlet.ServletInstance.init(ServletInstance.java:175) at javax.servlet.GenericServlet.init(GenericServlet.java:258) at com.ibm.ws.webcontainer.webapp.WebAppServletManager.addServlet(WebAppServletManager.java:761) at com.ibm.ws.webcontainer.webapp.WebAppServletManager.loadServlet(WebAppServletManager.java:257) at com.ibm.ws.webcontainer.webapp.WebAppServletManager.loadAutoLoadServlets(WebAppServletManager.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:360) at com.ibm.ws.runtime.component.ApplicationMgrImpl.start(ApplicationMgrImpl.java:401) at com.ibm.ws.runtime.component.DeployedApplicationImpl.fireDeployedObjectStart(DeployedApplicationImpl.java:743) at com.ibm.ws.runtime.component.DeployedModuleImpl.start(DeployedModuleImpl.java:337) at com.ibm.ws.runtime.component.DeployedApplicationImpl.start(DeployedApplicationImpl.java:531) at com.ibm.ws.runtime.component.ApplicationMgrImpl.startApplication(ApplicationMgrImpl.java:254) at com.ibm.ws.runtime.component.ApplicationMgrImpl.start(ApplicationMgrImpl.java:232) at com.ibm.ws.runtime.component.ContainerImpl.startComponents(ContainerImpl.java:343) at com.ibm.ws.runtime.component.ContainerImpl.start(ContainerImpl.java:234) at com.ibm.ws.runtime.component.ApplicationServerImpl.start(ApplicationServerImpl.java:117) at com.ibm.ws.runtime.component.ContainerImpl.startComponents(ContainerImpl.java: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(ServerRunnerV5.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.initializeConnectionProperties(WSRdbManagedConnectionImpl.java:579) at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.<init>(WSRdbManagedConnectionImpl.java:359) at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnection(WSManagedConnectionFactoryImpl.java:506) at com.ibm.ejs.j2c.poolmanager.FreePool.createManagedConnectionWithMCWrapper(FreePool.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:560) at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:374) at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:205) at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java: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(StrictServletInstance.java:82) at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._init(StrictLifecycleServlet.java:147) at com.ibm.ws.webcontainer.servlet.PreInitializedServletState.init(StrictLifecycleServlet.java:270) at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.init(StrictLifecycleServlet.java:113) at com.ibm.ws.webcontainer.servlet.ServletInstance.init(ServletInstance.java:175) at javax.servlet.GenericServlet.init(GenericServlet.java:258) at com.ibm.ws.webcontainer.webapp.WebAppServletManager.addServlet(WebAppServletManager.java:761) at com.ibm.ws.webcontainer.webapp.WebAppServletManager.loadServlet(WebAppServletManager.java:257) at com.ibm.ws.webcontainer.webapp.WebAppServletManager.loadAutoLoadServlets(WebAppServletManager.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:360) at com.ibm.ws.runtime.component.ApplicationMgrImpl.start(ApplicationMgrImpl.java:401) at com.ibm.ws.runtime.component.DeployedApplicationImpl.fireDeployedObjectStart(DeployedApplicationImpl.java:743) at com.ibm.ws.runtime.component.DeployedModuleImpl.start(DeployedModuleImpl.java:337) at com.ibm.ws.runtime.component.DeployedApplicationImpl.start(DeployedApplicationImpl.java:531) at com.ibm.ws.runtime.component.ApplicationMgrImpl.startApplication(ApplicationMgrImpl.java:254) at com.ibm.ws.runtime.component.ApplicationMgrImpl.start(ApplicationMgrImpl.java:232) at com.ibm.ws.runtime.component.ContainerImpl.startComponents(ContainerImpl.java:343) at com.ibm.ws.runtime.component.ContainerImpl.start(ContainerImpl.java:234) at com.ibm.ws.runtime.component.ApplicationServerImpl.start(ApplicationServerImpl.java:117) at com.ibm.ws.runtime.component.ContainerImpl.startComponents(ContainerImpl.java: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(ServerRunnerV5.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.initializeConnectionProperties(WSRdbManagedConnectionImpl.java:579) at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.<init>(WSRdbManagedConnectionImpl.java:359) at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnection(WSManagedConnectionFactoryImpl.java:506) at com.ibm.ejs.j2c.poolmanager.FreePool.createManagedConnectionWithMCWrapper(FreePool.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:560) at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:374) at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:205) at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java: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(StrictServletInstance.java:82) at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._init(StrictLifecycleServlet.java:147) at com.ibm.ws.webcontainer.servlet.PreInitializedServletState.init(StrictLifecycleServlet.java:270) at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.init(StrictLifecycleServlet.java:113) at com.ibm.ws.webcontainer.servlet.ServletInstance.init(ServletInstance.java:175) at javax.servlet.GenericServlet.init(GenericServlet.java:258) at com.ibm.ws.webcontainer.webapp.WebAppServletManager.addServlet(WebAppServletManager.java:761) at com.ibm.ws.webcontainer.webapp.WebAppServletManager.loadServlet(WebAppServletManager.java:257) at com.ibm.ws.webcontainer.webapp.WebAppServletManager.loadAutoLoadServlets(WebAppServletManager.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:360) at com.ibm.ws.runtime.component.ApplicationMgrImpl.start(ApplicationMgrImpl.java:401) at com.ibm.ws.runtime.component.DeployedApplicationImpl.fireDeployedObjectStart(DeployedApplicationImpl.java:743) at com.ibm.ws.runtime.component.DeployedModuleImpl.start(DeployedModuleImpl.java:337) at com.ibm.ws.runtime.component.DeployedApplicationImpl.start(DeployedApplicationImpl.java:531) at com.ibm.ws.runtime.component.ApplicationMgrImpl.startApplication(ApplicationMgrImpl.java:254) at com.ibm.ws.runtime.component.ApplicationMgrImpl.start(ApplicationMgrImpl.java:232) at com.ibm.ws.runtime.component.ContainerImpl.startComponents(ContainerImpl.java:343) at com.ibm.ws.runtime.component.ContainerImpl.start(ContainerImpl.java:234) at com.ibm.ws.runtime.component.ApplicationServerImpl.start(ApplicationServerImpl.java:117) at com.ibm.ws.runtime.component.ContainerImpl.startComponents(ContainerImpl.java: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(ServerRunnerV5.java:105) ===== --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php