WAS数据源配置问题
我在集群上上配置了数据源,但是在测试连接时候报以下错误:节点 was2Node01 上的服务器 nodeagent 上，对数据源 custServDS 执行的测试连接操作由于以下异常 java.sql.SQLException: 调用中无效的参数DSRA0010E: SQL 状态 = null，错误代码 = 17,433 而失败。 查看 JVM 日志 ...显示全部
我在集群上上配置了数据源,但是在测试连接时候报以下错误:节点 was2Node01 上的服务器 nodeagent 上，对数据源 custServDS 执行的测试连接操作由于以下异常 java.sql.SQLException: 调用中无效的参数DSRA0010E: SQL 状态 = null，错误代码 = 17,433 而失败。 查看 JVM 日志 获取进一步的详细信息。
在节点 was1Node01 上的服务器 nodeagent 上，对数据源 custServDS 执行的测试连接操作由于以下异常 java.sql.SQLException: 调用中无效的参数DSRA0010E: SQL 状态 = null，错误代码 = 17,433 而失败。 查看 JVM 日志 获取进一步的详细信息。
日志为:
Host Operating System is Windows Server 2003, version 5.2 build 3790 Service Pack 2
Java version = 1.5.0, Java Compiler = j9jit23, Java VM name = IBM J9 VM
was.install.root = D:IBMWebSphereAppServer
user.install.root = D:IBMWebSphereAppServerprofilesAppSrv01
Java Home = D:IBMWebSphereAppServerjavajre
ws.ext.dirs = D:IBMWebSphereAppServer/java/lib;D:IBMWebSphereAppServerprofilesAppSrv01/classes;D:IBMWebSphereAppServer/classes;D:IBMWebSphereAppServer/lib;D:IBMWebSphereAppServer/installedChannels;D:IBMWebSphereAppServer/lib/ext;D:IBMWebSphereAppServer/web/help;D:IBMWebSphereAppServer/deploytool/itp/plugins/com.ibm.etools.ejbdeploy/runtime
Classpath = D:IBMWebSphereAppServerprofilesAppSrv01/properties;D:IBMWebSphereAppServer/properties;D:IBMWebSphereAppServer/lib/startup.jar;D:IBMWebSphereAppServer/lib/bootstrap.jar;D:IBMWebSphereAppServer/lib/j2ee.jar;D:IBMWebSphereAppServer/lib/lmproxy.jar;D:IBMWebSphereAppServer/lib/urlprotocols.jar;D:IBMWebSphereAppServer/deploytool/itp/batchboot.jar;D:IBMWebSphereAppServer/deploytool/itp/batch2.jar;D:IBMWebSphereAppServer/java/lib/tools.jar
Java Library path = D:IBMWebSphereAppServerjavajrebin;.;D:IBMWebSphereAppServerbin;D:IBMWebSphereAppServerjavabin;D:IBMWebSphereAppServerjavajrebin;D:oracleproduct10.2.0db_1bin;C:Program FilesHPNCU;C:WINDOWSsystem32;C:WINDOWS;C:WINDOWSSystem32Wbem;C:Program Files (x86)SSH Communications SecuritySSH Secure Shell
************* End Display Current Environment *************
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R java.sql.SQLException: 调用中无效的参数DSRA0010E: SQL 状态 = null，错误代码 = 17,433
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:1160)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:184)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at oracle.jdbc.driver.OracleConnection.(OracleConnection.java:371)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:551)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:351)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:169)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPhysicalConnection(OracleConnectionPoolDataSource.java:149)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection(OracleConnectionPoolDataSource.java:95)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection(OracleConnectionPoolDataSource.java:63)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at com.ibm.ws.rsadapter.DSConfigurationHelper$1.run(DSConfigurationHelper.java:1254)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java:118)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at com.ibm.ws.rsadapter.DSConfigurationHelper.getPooledConnection(DSConfigurationHelper.java:1286)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at com.ibm.ws.rsadapter.DSConfigurationHelper.testConnectionForGUI(DSConfigurationHelper.java:2607)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at java.lang.reflect.Method.invoke(Method.java:618)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at com.ibm.ws.management.DataSourceConfigHelperMBean.testConnectionToDataSource2(DataSourceConfigHelperMBean.java:534)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at com.ibm.ws.management.DataSourceConfigHelperMBean.testConnection(DataSourceConfigHelperMBean.java:462)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at java.lang.reflect.Method.invoke(Method.java:618)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at sun.reflect.misc.Trampoline.invoke(MethodUtil.java:62)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at java.lang.reflect.Method.invoke(Method.java:618)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at sun.reflect.misc.MethodUtil.invoke(MethodUtil.java:265)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at javax.management.modelmbean.RequiredModelMBean.invokeMethod(RequiredModelMBean.java:1092)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at javax.management.modelmbean.RequiredModelMBean.invoke(RequiredModelMBean.java:973)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at com.sun.jmx.mbeanserver.DynamicMetaDataImpl.invoke(DynamicMetaDataImpl.java:231)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at com.sun.jmx.mbeanserver.MetaDataImpl.invoke(MetaDataImpl.java:238)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:833)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:802)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at com.ibm.ws.management.AdminServiceImpl$1.run(AdminServiceImpl.java:1082)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java:118)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at com.ibm.ws.management.AdminServiceImpl.invoke(AdminServiceImpl.java:975)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at com.ibm.ws.management.connector.AdminServiceDelegator.invoke(AdminServiceDelegator.java:139)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at java.lang.reflect.Method.invoke(Method.java:618)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at com.ibm.ws.management.connector.soap.SOAPConnector.invoke(SOAPConnector.java:351)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at com.ibm.ws.management.connector.soap.SOAPConnector.service(SOAPConnector.java:207)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at com.ibm.ws.management.connector.soap.SOAPConnection.handleRequest(SOAPConnection.java:55)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:680)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:484)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1473)
[09-1-15 18:34:19:328 CST] 0000001d收起
在节点 was1Node01 上的服务器 nodeagent 上，对数据源 custServDS 执行的测试连接操作由于以下异常 java.sql.SQLException: 调用中无效的参数DSRA0010E: SQL 状态 = null，错误代码 = 17,433 而失败。 查看 JVM 日志 获取进一步的详细信息。
日志为:
Host Operating System is Windows Server 2003, version 5.2 build 3790 Service Pack 2
Java version = 1.5.0, Java Compiler = j9jit23, Java VM name = IBM J9 VM
was.install.root = D:IBMWebSphereAppServer
user.install.root = D:IBMWebSphereAppServerprofilesAppSrv01
Java Home = D:IBMWebSphereAppServerjavajre
ws.ext.dirs = D:IBMWebSphereAppServer/java/lib;D:IBMWebSphereAppServerprofilesAppSrv01/classes;D:IBMWebSphereAppServer/classes;D:IBMWebSphereAppServer/lib;D:IBMWebSphereAppServer/installedChannels;D:IBMWebSphereAppServer/lib/ext;D:IBMWebSphereAppServer/web/help;D:IBMWebSphereAppServer/deploytool/itp/plugins/com.ibm.etools.ejbdeploy/runtime
Classpath = D:IBMWebSphereAppServerprofilesAppSrv01/properties;D:IBMWebSphereAppServer/properties;D:IBMWebSphereAppServer/lib/startup.jar;D:IBMWebSphereAppServer/lib/bootstrap.jar;D:IBMWebSphereAppServer/lib/j2ee.jar;D:IBMWebSphereAppServer/lib/lmproxy.jar;D:IBMWebSphereAppServer/lib/urlprotocols.jar;D:IBMWebSphereAppServer/deploytool/itp/batchboot.jar;D:IBMWebSphereAppServer/deploytool/itp/batch2.jar;D:IBMWebSphereAppServer/java/lib/tools.jar
Java Library path = D:IBMWebSphereAppServerjavajrebin;.;D:IBMWebSphereAppServerbin;D:IBMWebSphereAppServerjavabin;D:IBMWebSphereAppServerjavajrebin;D:oracleproduct10.2.0db_1bin;C:Program FilesHPNCU;C:WINDOWSsystem32;C:WINDOWS;C:WINDOWSSystem32Wbem;C:Program Files (x86)SSH Communications SecuritySSH Secure Shell
************* End Display Current Environment *************
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R java.sql.SQLException: 调用中无效的参数DSRA0010E: SQL 状态 = null，错误代码 = 17,433
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:1160)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:184)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at oracle.jdbc.driver.OracleConnection.
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:551)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:351)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:169)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPhysicalConnection(OracleConnectionPoolDataSource.java:149)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection(OracleConnectionPoolDataSource.java:95)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection(OracleConnectionPoolDataSource.java:63)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at com.ibm.ws.rsadapter.DSConfigurationHelper$1.run(DSConfigurationHelper.java:1254)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java:118)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at com.ibm.ws.rsadapter.DSConfigurationHelper.getPooledConnection(DSConfigurationHelper.java:1286)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at com.ibm.ws.rsadapter.DSConfigurationHelper.testConnectionForGUI(DSConfigurationHelper.java:2607)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at java.lang.reflect.Method.invoke(Method.java:618)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at com.ibm.ws.management.DataSourceConfigHelperMBean.testConnectionToDataSource2(DataSourceConfigHelperMBean.java:534)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at com.ibm.ws.management.DataSourceConfigHelperMBean.testConnection(DataSourceConfigHelperMBean.java:462)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at java.lang.reflect.Method.invoke(Method.java:618)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at sun.reflect.misc.Trampoline.invoke(MethodUtil.java:62)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at java.lang.reflect.Method.invoke(Method.java:618)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at sun.reflect.misc.MethodUtil.invoke(MethodUtil.java:265)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at javax.management.modelmbean.RequiredModelMBean.invokeMethod(RequiredModelMBean.java:1092)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at javax.management.modelmbean.RequiredModelMBean.invoke(RequiredModelMBean.java:973)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at com.sun.jmx.mbeanserver.DynamicMetaDataImpl.invoke(DynamicMetaDataImpl.java:231)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at com.sun.jmx.mbeanserver.MetaDataImpl.invoke(MetaDataImpl.java:238)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:833)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:802)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at com.ibm.ws.management.AdminServiceImpl$1.run(AdminServiceImpl.java:1082)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java:118)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at com.ibm.ws.management.AdminServiceImpl.invoke(AdminServiceImpl.java:975)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at com.ibm.ws.management.connector.AdminServiceDelegator.invoke(AdminServiceDelegator.java:139)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at java.lang.reflect.Method.invoke(Method.java:618)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at com.ibm.ws.management.connector.soap.SOAPConnector.invoke(SOAPConnector.java:351)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at com.ibm.ws.management.connector.soap.SOAPConnector.service(SOAPConnector.java:207)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at com.ibm.ws.management.connector.soap.SOAPConnection.handleRequest(SOAPConnection.java:55)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:680)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:484)
[09-1-15 18:34:19:312 CST] 0000001d SystemErr R at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1473)
[09-1-15 18:34:19:328 CST] 0000001d收起