jdbc - websphere test connection failed java.sql.SQLException: invalid arguments in callDSRA0010E -
server 1 : dmgr server (6.1 version)
server 2 : 6.1 installed , used node application server (ojdbc14.jar file copied server)
server 3: oracle 10gr2 installed , listeners , tns setup correctly
what have done:
- created user (appli_01) in database wasdb02 resdies @ server3.
- telnet server3 1521 server2 server1 success.
- created jaas - j2c authentication alias alias=sample1 username = appli_01 (database username) password=password of database user
- created jdbc provider
created datasource , gave values follows
jndi name :jdbc/sample1 component-managed authentication alias : sample1 url = jdbc:oracle:thin:@server3:1521:wasdb02
then saved , sync changes.
and if click test connection got below error:
the test connection operation failed data source sampledb on server nodeagent @ node server3node03 following exception: java.sql.sqlexception: invalid arguments in calldsra0010e: sql state = null, error code = 17,433. view jvm logs further details.
and systemout log follows.
10/7/13 15:02:00:482 ist] 000011d5 datasourcecon e dsra8040i: failed connect datasource. encountered "": java.sql.sqlexception: invalid arguments in calldsra0010e: sql state = null, error code = 17,433 @ oracle.jdbc.driver.databaseerror.throwsqlexception(databaseerror.java:145) @ oracle.jdbc.driver.databaseerror.throwsqlexception(databaseerror.java:190) @ oracle.jdbc.driver.databaseerror.throwsqlexception(databaseerror.java:286) @ oracle.jdbc.driver.t4cconnection.logon(t4cconnection.java:250) @ oracle.jdbc.driver.physicalconnection.<init>(physicalconnection.java:441) @ oracle.jdbc.driver.t4cconnection.<init>(t4cconnection.java:165) @ oracle.jdbc.driver.t4cdriverextension.getconnection(t4cdriverextension.java:35) @ oracle.jdbc.driver.oracledriver.connect(oracledriver.java:839) @ oracle.jdbc.pool.oracledatasource.getphysicalconnection(oracledatasource.java:389) @ oracle.jdbc.xa.client.oraclexadatasource.getpooledconnection(oraclexadatasource.java:557) @ oracle.jdbc.xa.client.oraclexadatasource.getxaconnection(oraclexadatasource.java:177) @ oracle.jdbc.xa.client.oraclexadatasource.getxaconnection(oraclexadatasource.java:163) @ oracle.jdbc.xa.client.oraclexadatasource.getxaconnection(oraclexadatasource.java:112) @ com.ibm.ws.rsadapter.dsconfigurationhelper$1.run(dsconfigurationhelper.java:1137) @ com.ibm.ws.security.util.accesscontroller.doprivileged(accesscontroller.java:118) @ com.ibm.ws.rsadapter.dsconfigurationhelper.getpooledconnection(dsconfigurationhelper.java:1132) @ com.ibm.ws.rsadapter.dsconfigurationhelper.testconnectionforgui(dsconfigurationhelper.java:2355) @ sun.reflect.nativemethodaccessorimpl.invoke0(native method) @ sun.reflect.nativemethodaccessorimpl.invoke(nativemethodaccessorimpl.java:64) @ sun.reflect.delegatingmethodaccessorimpl.invoke(delegatingmethodaccessorimpl.java:43) @ java.lang.reflect.method.invoke(method.java:615) @ com.ibm.ws.management.datasourceconfighelpermbean.testconnectiontodatasource2(datasourceconfighelpermbean.java:532) @ com.ibm.ws.management.datasourceconfighelpermbean.testconnection(datasourceconfighelpermbean.java:460) @ sun.reflect.nativemethodaccessorimpl.invoke0(native method) @ sun.reflect.nativemethodaccessorimpl.invoke(nativemethodaccessorimpl.java:64) @ sun.reflect.delegatingmethodaccessorimpl.invoke(delegatingmethodaccessorimpl.java:43) @ java.lang.reflect.method.invoke(method.java:615) @ sun.reflect.misc.trampoline.invoke(methodutil.java:62) @ sun.reflect.generatedmethodaccessor25.invoke(unknown source) @ sun.reflect.delegatingmethodaccessorimpl.invoke(delegatingmethodaccessorimpl.java:43) @ java.lang.reflect.method.invoke(method.java:615) @ sun.reflect.misc.methodutil.invoke(methodutil.java:265) @ javax.management.modelmbean.requiredmodelmbean.invokemethod(requiredmodelmbean.java:1089) @ javax.management.modelmbean.requiredmodelmbean.invoke(requiredmodelmbean.java:971) @ com.sun.jmx.mbeanserver.dynamicmetadataimpl.invoke(dynamicmetadataimpl.java:231) @ com.sun.jmx.mbeanserver.metadataimpl.invoke(metadataimpl.java:238) @ com.sun.jmx.interceptor.defaultmbeanserverinterceptor.invoke(defaultmbeanserverinterceptor.java:833) @ com.sun.jmx.mbeanserver.jmxmbeanserver.invoke(jmxmbeanserver.java:802) @ com.ibm.ws.management.adminserviceimpl$1.run(adminserviceimpl.java:1055) @ com.ibm.ws.security.util.accesscontroller.doprivileged(accesscontroller.java:118) @ com.ibm.ws.management.adminserviceimpl.invoke(adminserviceimpl.java:948) @ com.ibm.ws.management.connector.adminservicedelegator.invoke(adminservicedelegator.java:139) @ sun.reflect.nativemethodaccessorimpl.invoke0(native method) @ sun.reflect.nativemethodaccessorimpl.invoke(nativemethodaccessorimpl.java:64) @ sun.reflect.delegatingmethodaccessorimpl.invoke(delegatingmethodaccessorimpl.java:43) @ java.lang.reflect.method.invoke(method.java:615) @ com.ibm.ws.management.connector.soap.soapconnector.invoke(soapconnector.java:338) @ com.ibm.ws.management.connector.soap.soapconnector.service(soapconnector.java:204) @ com.ibm.ws.management.connector.soap.soapconnection.handlerequest(soapconnection.java:55) @ com.ibm.ws.http.httpconnection.readandhandlerequest(httpconnection.java:680) @ com.ibm.ws.http.httpconnection.run(httpconnection.java:484) @ com.ibm.ws.util.threadpool$worker.run(threadpool.java:1498)
i used lot in websphere 6.1 , resolved restarting nodeagent , server processes. unfortunately, never got chance diagnose root cause.
Comments
Post a Comment