Comments (4)
  • Add a Comment
  • Edit
  • More Actions v
  • Quarantine this Entry

1 jin commented Permalink

Hi <br /> Thanks for the post but I get an error : <div>&nbsp;</div> 00000020 DataSourceCon E DSRA8040I: No se ha podido conectar con DataSource. Se ha encontrado "": com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Unknown command <br /> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) <br /> at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:56) <br /> at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:39) <br /> at java.lang.reflect.Constructor.newInstance(Constructor.java:527) <br /> at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) <br /> at com.mysql.jdbc.Util.getInstance(Util.java:382) <br /> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1013) <br /> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3603) <br /> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3535) <br /> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:934) <br /> at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4104) <br /> at com.mysql.jdbc.MysqlIO.changeUser(MysqlIO.java:889) <br /> at com.mysql.jdbc.ConnectionImpl.changeUser(ConnectionImpl.java:1156) <br /> at com.mysql.jdbc.ConnectionImpl.resetServerState(ConnectionImpl.java:4696) <br /> at com.mysql.jdbc.jdbc2.optional.MysqlPooledConnection.getConnection(MysqlPooledConnection.java:181) <br /> at com.mysql.jdbc.jdbc2.optional.MysqlPooledConnection.getConnection(MysqlPooledConnection.java:158) <br /> at com.ibm.ws.rsadapter.DSConfigurationHelper.getConnectionFromDSOrPooledDS(DSConfigurationHelper.java:3222) <br /> at com.ibm.ws.rsadapter.DSConfigurationHelper.testConnectionForGUI(DSConfigurationHelper.java:3895) <br /> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) <br /> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60) <br /> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37) <br /> at java.lang.reflect.Method.invoke(Method.java:611) <br /> at com.ibm.ws.management.DataSourceConfigHelperMBean.testConnectionToDataSource2(DataSourceConfigHelperMBean.java:556) <br /> at com.ibm.ws.management.DataSourceConfigHelperMBean.testConnection(DataSourceConfigHelperMBean.java:484) <br /> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) <br /> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60) <br /> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37) <br /> at java.lang.reflect.Method.invoke(Method.java:611) <br /> at sun.reflect.misc.Trampoline.invoke(MethodUtil.java:49) <br /> at sun.reflect.GeneratedMethodAccessor15.invoke(Unknown Source) <br /> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37) <br /> at java.lang.reflect.Method.invoke(Method.java:611) <br /> at sun.reflect.misc.MethodUtil.invoke(MethodUtil.java:256) <br /> at javax.management.modelmbean.RequiredModelMBean.invokeMethod(RequiredModelMBean.java:1085) <br /> at javax.management.modelmbean.RequiredModelMBean.invoke(RequiredModelMBean.java:966) <br /> at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:848) <br /> at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:773) <br /> at com.ibm.ws.management.AdminServiceImpl$1.run(AdminServiceImpl.java:1332) <br /> at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java:118) <br /> at com.ibm.ws.management.AdminServiceImpl.invoke(AdminServiceImpl.java:1225) <br /> at com.ibm.ws.management.commands.AdminServiceCommands$InvokeCmd.execute(AdminServiceCommands.java:251) <br /> at com.ibm.ws.console.core.mbean.MBeanHelper.invoke(MBeanHelper.java:239)

2 kcibmer commented Permalink

I always get an exception if I don't restart WAS before testing the connection. I don't remember if it's the same exception you saw.

3 pdenton commented Permalink

I got the same error but it did go away after I restarted the WAS server. I'm using WAS 6.1

4 2BS5_Anuroop_Sirothia commented Permalink

This is perfect. I was able to successfully establish connection with MySQL DB. Thanks, you made my day!