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:

  1. created user (appli_01) in database wasdb02 resdies @ server3.
  2. telnet server3 1521 server2 server1 success.
  3. created jaas - j2c authentication alias alias=sample1 username = appli_01 (database username) password=password of database user
  4. created jdbc provider
  5. created datasource , gave values follows

    jndi name :jdbc/sample1   component-managed authentication alias : sample1   url = jdbc:oracle:thin:@server3:1521:wasdb02 
  6. 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

Popular posts from this blog

java.util.scanner - How to read and add only numbers to array from a text file -

rewrite - Trouble with Wordpress multiple custom querystrings -