com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Unknown command

Question

Hi .. I'm trying to create datasource for connection pooling mysql database in Websphere Application Server.

I've set the JDBC Provider, I set the

Implementation class name   : com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource

my mysql driver version is 5.1.6.

but I got this error while I try to connect the datasource:

The test connection operation failed for data source btn_itb_ds on server server1 at node qnode with the following exception: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Unknown command. View JVM logs for further details.

I have read this http://bugs.mysql.com/bug.php?id=38388 trouble shooting. But they just suggest to upgrade mysql driver version 5.1.X and I have do that. but I've got the same error.

Answer 1

It helps if you post the JVM logs as that would contain information on the error.

Answer 2

Here's a stacktrace from our server.

[7/5/10 17:21:48:153 CDT] 0000000f SystemErr R com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Unknown command [7/5/10 17:21:48:153 CDT] 0000000f SystemErr R at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [7/5/10 17:21:48:153 CDT] 0000000f SystemErr R at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:44) [7/5/10 17:21:48:154 CDT] 0000000f SystemErr R at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:39) [7/5/10 17:21:48:154 CDT] 0000000f SystemErr R at java.lang.reflect.Constructor.newInstance(Constructor.java:516) [7/5/10 17:21:48:154 CDT] 0000000f SystemErr R at com.mysql.jdbc.Util.handleNewInstance(Util.java:409) [7/5/10 17:21:48:154 CDT] 0000000f SystemErr R at com.mysql.jdbc.Util.getInstance(Util.java:384) [7/5/10 17:21:48:154 CDT] 0000000f SystemErr R at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015) [7/5/10 17:21:48:154 CDT] 0000000f SystemErr R at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566) [7/5/10 17:21:48:154 CDT] 0000000f SystemErr R at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498) [7/5/10 17:21:48:154 CDT] 0000000f SystemErr R at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:919) [7/5/10 17:21:48:154 CDT] 0000000f SystemErr R at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4004) [7/5/10 17:21:48:154 CDT] 0000000f SystemErr R at com.mysql.jdbc.MysqlIO.changeUser(MysqlIO.java:874) [7/5/10 17:21:48:154 CDT] 0000000f SystemErr R at com.mysql.jdbc.ConnectionImpl.changeUser(ConnectionImpl.java:1136) [7/5/10 17:21:48:154 CDT] 0000000f SystemErr R at com.mysql.jdbc.ConnectionImpl.resetServerState(ConnectionImpl.java:4630) [7/5/10 17:21:48:154 CDT] 0000000f SystemErr R at com.mysql.jdbc.jdbc2.optional.MysqlPooledConnection.getConnection(MysqlPooledConnection.java:183) [7/5/10 17:21:48:154 CDT] 0000000f SystemErr R at com.mysql.jdbc.jdbc2.optional.MysqlPooledConnection.getConnection(MysqlPooledConnection.java:160) [7/5/10 17:21:48:154 CDT] 0000000f SystemErr R at com.ibm.ws.rsadapter.DSConfigurationHelper.getConnectionFromDSOrPooledDS(DSConfigurationHelper.java:3219) [7/5/10 17:21:48:155 CDT] 0000000f SystemErr R at com.ibm.ws.rsadapter.DSConfigurationHelper.testConnectionForGUI(DSConfigurationHelper.java:3892) [7/5/10 17:21:48:155 CDT] 0000000f SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [7/5/10 17:21:48:155 CDT] 0000000f SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:48) [7/5/10 17:21:48:155 CDT] 0000000f SystemErr R at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37) [7/5/10 17:21:48:155 CDT] 0000000f SystemErr R at java.lang.reflect.Method.invoke(Method.java:600) [7/5/10 17:21:48:155 CDT] 0000000f SystemErr R at com.ibm.ws.management.DataSourceConfigHelperMBean.testConnectionToDataSource2(DataSourceConfigHelperMBean.java:549) [7/5/10 17:21:48:155 CDT] 0000000f SystemErr R at com.ibm.ws.management.DataSourceConfigHelperMBean.testConnection(DataSourceConfigHelperMBean.java:477) [7/5/10 17:21:48:155 CDT] 0000000f SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [7/5/10 17:21:48:155 CDT] 0000000f SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:48) [7/5/10 17:21:48:155 CDT] 0000000f SystemErr R at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37) [7/5/10 17:21:48:155 CDT] 0000000f SystemErr R at java.lang.reflect.Method.invoke(Method.java:600) [7/5/10 17:21:48:155 CDT] 0000000f SystemErr R at sun.reflect.misc.Trampoline.invoke(MethodUtil.java:37) [7/5/10 17:21:48:155 CDT] 0000000f SystemErr R at sun.reflect.GeneratedMethodAccessor39.invoke(Unknown Source) [7/5/10 17:21:48:155 CDT] 0000000f SystemErr R at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37) [7/5/10 17:21:48:155 CDT] 0000000f SystemErr R at java.lang.reflect.Method.invoke(Method.java:600) [7/5/10 17:21:48:156 CDT] 0000000f SystemErr R at sun.reflect.misc.MethodUtil.invoke(MethodUtil.java:244) [7/5/10 17:21:48:156 CDT] 0000000f SystemErr R at javax.management.modelmbean.RequiredModelMBean.invokeMethod(RequiredModelMBean.java:1086) [7/5/10 17:21:48:156 CDT] 0000000f SystemErr R at javax.management.modelmbean.RequiredModelMBean.invoke(RequiredModelMBean.java:967) [7/5/10 17:21:48:156 CDT] 0000000f SystemErr R at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:848) [7/5/10 17:21:48:156 CDT] 0000000f SystemErr R at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:773) [7/5/10 17:21:48:156 CDT] 0000000f SystemErr R at com.ibm.ws.management.AdminServiceImpl$1.run(AdminServiceImpl.java:1320) [7/5/10 17:21:48:156 CDT] 0000000f SystemErr R at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java:118) [7/5/10 17:21:48:156 CDT] 0000000f SystemErr R at com.ibm.ws.management.AdminServiceImpl.invoke(AdminServiceImpl.java:1213) [7/5/10 17:21:48:156 CDT] 0000000f SystemErr R at com.ibm.ws.management.connector.AdminServiceDelegator.invoke(AdminServiceDelegator.java:181) [7/5/10 17:21:48:156 CDT] 0000000f SystemErr R at sun.reflect.GeneratedMethodAccessor51.invoke(Unknown Source) [7/5/10 17:21:48:156 CDT] 0000000f SystemErr R at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37) [7/5/10 17:21:48:156 CDT] 0000000f SystemErr R at java.lang.reflect.Method.invoke(Method.java:600) [7/5/10 17:21:48:156 CDT] 0000000f SystemErr R at com.ibm.ws.management.connector.soap.SOAPConnector.invoke(SOAPConnector.java:406) [7/5/10 17:21:48:156 CDT] 0000000f SystemErr R at com.ibm.ws.management.connector.soap.SOAPConnector.service(SOAPConnector.java:239) [7/5/10 17:21:48:156 CDT] 0000000f SystemErr R at com.ibm.ws.management.connector.soap.SOAPConnection.handleRequest(SOAPConnection.java:65) [7/5/10 17:21:48:157 CDT] 0000000f SystemErr R at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:733) [7/5/10 17:21:48:157 CDT] 0000000f SystemErr R at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:522) [7/5/10 17:21:48:157 CDT] 0000000f SystemErr R at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1550)

Answer 3

I am having exactly the same error. I am using Mysql version 5.5 on Win 7 64 bit. And I was trying to create a Datasource within Websphere App server. Although i was successful to add the datasource, however, when i try to connect, i am getting the above described error. Below is the detailed JVM logs : **** Start Display Current Environment **** Log file started at: [2010/7/16 17:49:34:640 CST] ***** End Display Current Environment ***** [2010/7/19 10:19:34:364 CST] 0000001b SystemErr R javax.management.MBeanException: Exception thrown in RequiredModelMBean while trying to invoke operation register [2010/7/19 10:19:34:380 CST] 0000001b SystemErr R at javax.management.modelmbean.RequiredModelMBean.invokeMethod(RequiredModelMBean.java:1113) [2010/7/19 10:19:34:380 CST] 0000001b SystemErr R at javax.management.modelmbean.RequiredModelMBean.invoke(RequiredModelMBean.java:967) [2010/7/19 10:19:34:380 CST] 0000001b SystemErr R at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:848) [2010/7/19 10:19:34:380 CST] 0000001b SystemErr R at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:773) [2010/7/19 10:19:34:380 CST] 0000001b SystemErr R at com.ibm.ws.management.AdminServiceImpl$1.run(AdminServiceImpl.java:1320) [2010/7/19 10:19:34:380 CST] 0000001b SystemErr R at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java:118) [2010/7/19 10:19:34:380 CST] 0000001b SystemErr R at com.ibm.ws.management.AdminServiceImpl.invoke(AdminServiceImpl.java:1213) [2010/7/19 10:19:34:380 CST] 0000001b SystemErr R at com.ibm.ws.tpv.engine.TPVProxyEngine.localInvoke(TPVProxyEngine.java:843) [2010/7/19 10:19:34:380 CST] 0000001b SystemErr R at com.ibm.ws.tpv.engine.TPVProxyEngine.invoke(TPVProxyEngine.java:788) [2010/7/19 10:19:34:380 CST] 0000001b SystemErr R at com.ibm.ws.tpv.engine.TPVProxyEngine.register(TPVProxyEngine.java:395) [2010/7/19 10:19:34:380 CST] 0000001b SystemErr R at com.ibm.ws.console.tpv.action.UploadAction.initLogViewing(UploadAction.java:324) [2010/7/19 10:19:34:380 CST] 0000001b SystemErr R at com.ibm.ws.console.tpv.action.UploadAction.execute(UploadAction.java:121) [2010/7/19 10:19:34:380 CST] 0000001b SystemErr R at org.apache.struts.action.RequestProcessor.processActionPerform(Unknown Source) [2010/7/19 10:19:34:380 CST] 0000001b SystemErr R at org.apache.struts.action.RequestProcessor.process(Unknown Source) [2010/7/19 10:19:34:380 CST] 0000001b SystemErr R at org.apache.struts.action.ActionServlet.process(Unknown Source) [2010/7/19 10:19:34:380 CST] 0000001b SystemErr R at org.apache.struts.action.ActionServlet.doPost(Unknown Source) [2010/7/19 10:19:34:380 CST] 0000001b SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:738) [2010/7/19 10:19:34:380 CST] 0000001b SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:831) [2010/7/19 10:19:34:380 CST] 0000001b SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1655) [2010/7/19 10:19:34:380 CST] 0000001b SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1595) [2010/7/19 10:19:34:380 CST] 0000001b SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:131) [2010/7/19 10:19:34:380 CST] 0000001b SystemErr R at com.ibm.ws.console.core.servlet.WSCUrlFilter.setUpCommandAssistence(WSCUrlFilter.java:927) [2010/7/19 10:19:34:380 CST] 0000001b SystemErr R at com.ibm.ws.console.core.servlet.WSCUrlFilter.continueStoringTaskState(WSCUrlFilter.java:494) [2010/7/19 10:19:34:380 CST] 0000001b SystemErr R at com.ibm.ws.console.core.servlet.WSCUrlFilter.doFilter(WSCUrlFilter.java:315) [2010/7/19 10:19:34:380 CST] 0000001b SystemErr R at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:188) [2010/7/19 10:19:34:380 CST] 0000001b SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:116) [2010/7/19 10:19:34:380 CST] 0000001b SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:77) [2010/7/19 10:19:34:380 CST] 0000001b SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:895) [2010/7/19 10:19:34:380 CST] 0000001b SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:932) [2010/7/19 10:19:34:380 CST] 0000001b SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:500) [2010/7/19 10:19:34:380 CST] 0000001b SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178) [2010/7/19 10:19:34:380 CST] 0000001b SystemErr R at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:91) [2010/7/19 10:19:34:380 CST] 0000001b SystemErr R at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:864) [2010/7/19 10:19:34:380 CST] 0000001b SystemErr R at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1583) [2010/7/19 10:19:34:380 CST] 0000001b SystemErr R at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:183) [2010/7/19 10:19:34:380 CST] 0000001b SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:455) [2010/7/19 10:19:34:380 CST] 0000001b SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:384) [2010/7/19 10:19:34:380 CST] 0000001b SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:83) [2010/7/19 10:19:34:380 CST] 0000001b SystemErr R at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165) [2010/7/19 10:19:34:380 CST] 0000001b SystemErr R at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217) [2010/7/19 10:19:34:380 CST] 0000001b SystemErr R at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161) [2010/7/19 10:19:34:380 CST] 0000001b SystemErr R at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138) [2010/7/19 10:19:34:380 CST] 0000001b SystemErr R at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204) [2010/7/19 10:19:34:380 CST] 0000001b SystemErr R at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775) [2010/7/19 10:19:34:380 CST] 0000001b SystemErr R at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905) [2010/7/19 10:19:34:380 CST] 0000001b SystemErr R at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1550) [2010/7/19 10:19:34:380 CST] 0000001b SystemErr R Caused by: java.lang.Exception: invalid file extension: .log [2010/7/19 10:19:34:380 CST] 0000001b SystemErr R at com.ibm.ws.tpv.engine.parser.ParsingController.parse(ParsingController.java:59) [2010/7/19 10:19:34:380 CST] 0000001b SystemErr R at com.ibm.ws.tpv.engine.filter.TPVFilter.register(TPVFilter.java:92) [2010/7/19 10:19:34:380 CST] 0000001b SystemErr R at com.ibm.ws.tpv.engine.TPVCollaborator.register(TPVCollaborator.java:128) [2010/7/19 10:19:34:380 CST] 0000001b SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [2010/7/19 10:19:34:380 CST] 0000001b SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:48) [2010/7/19 10:19:34:380 CST] 0000001b SystemErr R at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37) [2010/7/19 10:19:34:380 CST] 0000001b SystemErr R at java.lang.reflect.Method.invoke(Method.java:600) [2010/7/19 10:19:34:380 CST] 0000001b SystemErr R at sun.reflect.misc.Trampoline.invoke(MethodUtil.java:37) [2010/7/19 10:19:34:380 CST] 0000001b SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [2010/7/19 10:19:34:380 CST] 0000001b SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:48) [2010/7/19 10:19:34:380 CST] 0000001b SystemErr R at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37) [2010/7/19 10:19:34:380 CST] 0000001b SystemErr R at java.lang.reflect.Method.invoke(Method.java:600) [2010/7/19 10:19:34:380 CST] 0000001b SystemErr R at sun.reflect.misc.MethodUtil.invoke(MethodUtil.java:244) [2010/7/19 10:19:34:396 CST] 0000001b SystemErr R at javax.management.modelmbean.RequiredModelMBean.invokeMethod(RequiredModelMBean.java:1086) [2010/7/19 10:19:34:396 CST] 0000001b SystemErr R ... 45 more [2010/7/19 10:50:32:121 CST] 00000023 SystemErr R com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Unknown command [2010/7/19 10:50:32:121 CST] 00000023 SystemErr R at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [2010/7/19 10:50:32:121 CST] 00000023 SystemErr R at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:44) [2010/7/19 10:50:32:121 CST] 00000023 SystemErr R at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:39) [2010/7/19 10:50:32:121 CST] 00000023 SystemErr R at java.lang.reflect.Constructor.newInstance(Constructor.java:516) [2010/7/19 10:50:32:121 CST] 00000023 SystemErr R at com.mysql.jdbc.Util.handleNewInstance(Util.java:409) [2010/7/19 10:50:32:121 CST] 00000023 SystemErr R at com.mysql.jdbc.Util.getInstance(Util.java:384) [2010/7/19 10:50:32:121 CST] 00000023 SystemErr R at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015) [2010/7/19 10:50:32:121 CST] 00000023 SystemErr R at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566) [2010/7/19 10:50:32:121 CST] 00000023 SystemErr R at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498) [2010/7/19 10:50:32:121 CST] 00000023 SystemErr R at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:919) [2010/7/19 10:50:32:121 CST] 00000023 SystemErr R at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4004) [2010/7/19 10:50:32:121 CST] 00000023 SystemErr R at com.mysql.jdbc.MysqlIO.changeUser(MysqlIO.java:874) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at com.mysql.jdbc.ConnectionImpl.changeUser(ConnectionImpl.java:1136) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at com.mysql.jdbc.ConnectionImpl.resetServerState(ConnectionImpl.java:4630) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at com.mysql.jdbc.jdbc2.optional.MysqlPooledConnection.getConnection(MysqlPooledConnection.java:183) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at com.mysql.jdbc.jdbc2.optional.MysqlPooledConnection.getConnection(MysqlPooledConnection.java:160) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at com.ibm.ws.rsadapter.DSConfigurationHelper.getConnectionFromDSOrPooledDS(DSConfigurationHelper.java:3191) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at com.ibm.ws.rsadapter.DSConfigurationHelper.testConnectionForGUI(DSConfigurationHelper.java:3864) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:48) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at java.lang.reflect.Method.invoke(Method.java:600) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at com.ibm.ws.management.DataSourceConfigHelperMBean.testConnectionToDataSource2(DataSourceConfigHelperMBean.java:549) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at com.ibm.ws.management.DataSourceConfigHelperMBean.testConnection(DataSourceConfigHelperMBean.java:477) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:48) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at java.lang.reflect.Method.invoke(Method.java:600) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at sun.reflect.misc.Trampoline.invoke(MethodUtil.java:37) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at sun.reflect.GeneratedMethodAccessor34.invoke(Unknown Source) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at java.lang.reflect.Method.invoke(Method.java:600) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at sun.reflect.misc.MethodUtil.invoke(MethodUtil.java:244) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at javax.management.modelmbean.RequiredModelMBean.invokeMethod(RequiredModelMBean.java:1086) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at javax.management.modelmbean.RequiredModelMBean.invoke(RequiredModelMBean.java:967) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:848) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:773) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at com.ibm.ws.management.AdminServiceImpl$1.run(AdminServiceImpl.java:1320) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java:118) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at com.ibm.ws.management.AdminServiceImpl.invoke(AdminServiceImpl.java:1213) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at com.ibm.ws.management.commands.AdminServiceCommands$InvokeCmd.execute(AdminServiceCommands.java:251) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at com.ibm.ws.console.core.mbean.MBeanHelper.invoke(MBeanHelper.java:239) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at com.ibm.ws.console.core.mbean.ResourceMBeanHelper.testNode(ResourceMBeanHelper.java:822) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at com.ibm.ws.console.core.mbean.ResourceMBeanHelper.testConnection(ResourceMBeanHelper.java:260) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at com.ibm.ws.console.resources.database.jdbc.DataSourceCollectionAction.execute(DataSourceCollectionAction.java:349) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at org.apache.struts.action.RequestProcessor.processActionPerform(Unknown Source) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at org.apache.struts.action.RequestProcessor.process(Unknown Source) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at org.apache.struts.action.ActionServlet.process(Unknown Source) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at org.apache.struts.action.ActionServlet.doPost(Unknown Source) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:738) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:831) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1655) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1595) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:104) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:77) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:895) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:932) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:500) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:341) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at org.apache.struts.action.RequestProcessor.doForward(Unknown Source) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at org.apache.struts.tiles.TilesRequestProcessor.doForward(Unknown Source) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at org.apache.struts.action.RequestProcessor.processForwardConfig(Unknown Source) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at org.apache.struts.tiles.TilesRequestProcessor.processForwardConfig(Unknown Source) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at com.ibm.isclite.container.controller.InformationController.processForwardConfig(InformationController.java:217) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at org.apache.struts.action.RequestProcessor.process(Unknown Source) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at org.apache.struts.action.ActionServlet.process(Unknown Source) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at org.apache.struts.action.ActionServlet.doPost(Unknown Source) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:738) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:831) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1655) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1595) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:131) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at com.ibm.ws.console.core.servlet.WSCUrlFilter.setUpCommandAssistence(WSCUrlFilter.java:927) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at com.ibm.ws.console.core.servlet.WSCUrlFilter.continueStoringTaskState(WSCUrlFilter.java:494) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at com.ibm.ws.console.core.servlet.WSCUrlFilter.doFilter(WSCUrlFilter.java:315) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:184) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:116) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:77) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:895) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:932) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:500) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:91) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:864) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1583) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:183) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:455) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:384) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:83) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905) [2010/7/19 10:50:32:137 CST] 00000023 SystemErr R at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1550) [2010/7/19 10:50:32:153 CST] 00000023 SystemErr R com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Unknown command [2010/7/19 10:50:32:153 CST] 00000023 SystemErr R at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [2010/7/19 10:50:32:153 CST] 00000023 SystemErr R at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:44) [2010/7/19 10:50:32:153 CST] 00000023 SystemErr R at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:39) [2010/7/19 10:50:32:153 CST] 00000023 SystemErr R at java.lang.reflect.Constructor.newInstance(Constructor.java:516) [2010/7/19 10:50:32:153 CST] 00000023 SystemErr R at com.mysql.jdbc.Util.handleNewInstance(Util.java:409) [2010/7/19 10:50:32:153 CST] 00000023 SystemErr R at com.mysql.jdbc.Util.getInstance(Util.java:384) [2010/7/19 10:50:32:153 CST] 00000023 SystemErr R at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015) [2010/7/19 10:50:32:153 CST] 00000023 SystemErr R at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566) [2010/7/19 10:50:32:153 CST] 00000023 SystemErr R at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498) [2010/7/19 10:50:32:168 CST] 00000023 SystemErr R at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:919) [2010/7/19 10:50:32:168 CST] 00000023 SystemErr R at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4004) [2010/7/19 10:50:32:168 CST] 00000023 SystemErr R at com.mysql.jdbc.MysqlIO.changeUser(MysqlIO.java:874) [2010/7/19 10:50:32:168 CST] 00000023 SystemErr R at com.mysql.jdbc.ConnectionImpl.changeUser(ConnectionImpl.java:1136) [2010/7/19 10:50:32:168 CST] 00000023 SystemErr R at com.mysql.jdbc.ConnectionImpl.resetServerState(ConnectionImpl.java:4630) [2010/7/19 10:50:32:168 CST] 00000023 SystemErr R at com.mysql.jdbc.jdbc2.optional.MysqlPooledConnection.getConnection(MysqlPooledConnection.java:183) [2010/7/19 10:50:32:168 CST] 00000023 SystemErr R at com.mysql.jdbc.jdbc2.optional.MysqlPooledConnection.getConnection(MysqlPooledConnection.java:160) [2010/7/19 10:50:32:168 CST] 00000023 SystemErr R at com.ibm.ws.rsadapter.DSConfigurationHelper.getConnectionFromDSOrPooledDS(DSConfigurationHelper.java:3191) [2010/7/19 10:50:32:168 CST] 00000023 SystemErr R at com.ibm.ws.rsadapter.DSConfigurationHelper.testConnectionForGUI(DSConfigurationHelper.java:3864) [2010/7/19 10:50:32:168 CST] 00000023 SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [2010/7/19 10:50:32:168 CST] 00000023 SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:48) [2010/7/19 10:50:32:168 CST] 00000023 SystemErr R at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37) [2010/7/19 10:50:32:168 CST] 00000023 SystemErr R at java.lang.reflect.Method.invoke(Method.java:600) [2010/7/19 10:50:32:168 CST] 00000023 SystemErr R at com.ibm.ws.management.DataSourceConfigHelperMBean.testConnectionToDataSource2(DataSourceConfigHelperMBean.java:549) [2010/7/19 10:50:32:168 CST] 00000023 SystemErr R at com.ibm.ws.management.DataSourceConfigHelperMBean.testConnection(DataSourceConfigHelperMBean.java:477) [2010/7/19 10:50:32:168 CST] 00000023 SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [2010/7/19 10:50:32:168 CST] 00000023 SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:48) [2010/7/19 10:50:32:168 CST] 00000023 SystemErr R at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37) [2010/7/19 10:50:32:168 CST] 00000023 SystemErr R at java.lang.reflect.Method.invoke(Method.java:600) [2010/7/19 10:50:32:168 CST] 00000023 SystemErr R at sun.reflect.misc.Trampoline.invoke(MethodUtil.java:37) [2010/7/19 10:50:32:168 CST] 00000023 SystemErr R at sun.reflect.GeneratedMethodAccessor34.invoke(Unknown Source) [2010/7/19 10:50:32:168 CST] 00000023 SystemErr R at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37) [2010/7/19 10:50:32:168 CST] 00000023 SystemErr R at java.lang.reflect.Method.invoke(Method.java:600) [2010/7/19 10:50:32:168 CST] 00000023 SystemErr R at sun.reflect.misc.MethodUtil.invoke(MethodUtil.java:244) [2010/7/19 10:50:32:168 CST] 00000023 SystemErr R at javax.management.modelmbean.RequiredModelMBean.invokeMethod(RequiredModelMBean.java:1086) [2010/7/19 10:50:32:168 CST] 00000023 SystemErr R at javax.management.modelmbean.RequiredModelMBean.invoke(RequiredModelMBean.java:967) [2010/7/19 10:50:32:168 CST] 00000023 SystemErr R at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:848) [2010/7/19 10:50:32:168 CST] 00000023 SystemErr R at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:773) [2010/7/19 10:50:32:168 CST] 00000023 SystemErr R at com.ibm.ws.management.AdminServiceImpl$1.run(AdminServiceImpl.java:1320) [2010/7/19 10:50:32:168 CST] 00000023 SystemErr R at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java:118) [2010/7/19 10:50:32:168 CST] 00000023 SystemErr R at com.ibm.ws.management.AdminServiceImpl.invoke(AdminServiceImpl.java:1213) [2010/7/19 10:50:32:168 CST] 00000023 SystemErr R at com.ibm.ws.management.commands.AdminServiceCommands$InvokeCmd.execute(AdminServiceCommands.java:251) [2010/7/19 10:50:32:168 CST] 00000023 SystemErr R at com.ibm.ws.console.core.mbean.MBeanHelper.invoke(MBeanHelper.java:239) [2010/7/19 10:50:32:168 CST] 00000023 SystemErr R at com.ibm.ws.console.core.mbean.ResourceMBeanHelper.testNode(ResourceMBeanHelper.java:822) [2010/7/19 10:50:32:168 CST] 00000023 SystemErr R at com.ibm.ws.console.core.mbean.ResourceMBeanHelper.testConnection(ResourceMBeanHelper.java:260) [2010/7/19 10:50:32:168 CST] 00000023 SystemErr R at com.ibm.ws.console.resources.database.jdbc.DataSourceCollectionAction.execute(DataSourceCollectionAction.java:349)