ConnectionManager, getConnection() Error getting Connection SQL State = null, Error Code = 17

[shiv_ke...@yahoo.com]

Hi,

I have migrated the code from WSAD 4 to RAD 6 and I have corrected all the build errors. I have also configured oracle data source on admin console and the test connetion is successful.
But when I run the application, the application fails to load completly and the log file is as below:

I have been struggling with this problem since two days and I am unable to find a clue. Could someone please throw some light on any suggestions/hints/approaches?

[14 Jun 2007 13:39:18,331] DEBUG - Control KAPSUtils, getDataSource() jdbc/ORAKAPDB
[14 Jun 2007 13:39:18,628] DEBUG - Control KAPSUtils, getDataSource() jdbc/ORAKAPDB DataSource obtained
[14 Jun 2007 13:39:18,894] ERROR - DAO ConnectionManager, getConnection() Error getting Connection
java.sql.SQLException: invalid arguments in callDSRA0010E: SQL State = null, Error Code = 17,433DSRA0010E: SQL State = null, Error Code = 17,433
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:1160)
at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:184)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:371)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:551)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:351)
at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:169)

...........

[14 Jun 2007 13:39:18,894] DEBUG - DAO ConnectionManager, getConnection() Database connection already closed
[14 Jun 2007 13:39:18,941] ERROR - UserProfile com.keybank.kap.sec.utility.KapsUserProfile, getUserProfileFromDB() com.keybank.kap.control.ehf.KAPSException[ Nested by java.sql.SQLException: invalid arguments in callDSRA0010E: SQL State = null, Error Code = 17,433DSRA0010E: SQL State = null, Error Code = 17,433 ] << DAO - ConnectionManager, getConnection() >>
[14 Jun 2007 13:39:18,941] DEBUG - Control KAPSUtils, getErrorDetails() invalid a
[14 Jun 2007 13:39:18,941] DEBUG - Control KAPSUtils, getErrorDetails() Before parsing
[14 Jun 2007 13:39:18,956] DEBUG - Control KAPSUtils, getErrorDetails() after parsing
[14 Jun 2007 13:39:18,956] DEBUG - Control KAPSUtils, getErrorDetails() {}
[14 Jun 2007 13:39:18,956] ERROR - Control KAPSException After getting
[14 Jun 2007 13:39:18,956] ERROR - Control KAPSException null invalid arguments in callDSRA0010E: SQL State = null, Error Code = 17,433DSRA0010E: SQL State = null, Error Code = 17,433
[14 Jun 2007 13:39:18,956] FATAL - Control FrontController [ Forwarding Error ]
java.lang.NullPointerException
at com.keybank.kap.control.web.FrontController.performTask(FrontController.java:289)
at com.keybank.kap.control.web.FrontController.doPost(FrontController.java:67)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1212)

Thanks a lot,
G.

[Brian S Paskin]

Hi, you are receiving a "no suitable driver" error. Make sure that you are using the correct DB driver and that you are using the datasource lookup in the correct manner. This has changed from version 4 to version 5.

Brian

[Ben_]

Reasons for "invalid arguments in call" usually are around invalid
configuration (URL, user/pwd).

The full stacktrace would be helpful, because there is a "Caused by" close
normally at the end.