java.sql.SQLException: invalid arguments in call DSRA0010E: SQL State = null, Error Code = 17,433

Error:- java.sql.SQLException: invalid arguments in call DSRA0010E: SQL State = null, Error Code = 17,433

Server: Websphere 8.0

Full Error Log:

[3/19/13 23:54:01:021 CDT] 00000018 SystemErr     R java.sql.SQLException: invalid arguments in call DSRA0010E: SQL State = null, Error Code = 17,433
[3/19/13 23:54:01:021 CDT] 00000018 SystemErr     R at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
[3/19/13 23:54:01:021 CDT] 00000018 SystemErr     R at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
[3/19/13 23:54:01:021 CDT] 00000018 SystemErr     R at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
[3/19/13 23:54:01:021 CDT] 00000018 SystemErr     R at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:236)
[3/19/13 23:54:01:021 CDT] 00000018 SystemErr     R at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:414)
[3/19/13 23:54:01:021 CDT] 00000018 SystemErr     R at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:165)
[3/19/13 23:54:01:021 CDT] 00000018 SystemErr     R at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
[3/19/13 23:54:01:021 CDT] 00000018 SystemErr     R at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
[3/19/13 23:54:01:021 CDT] 00000018 SystemErr     R at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:297)
[3/19/13 23:54:01:021 CDT] 00000018 SystemErr     R at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:221)
[3/19/13 23:54:01:021 CDT] 00000018 SystemErr     R at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPhysicalConnection(OracleConnectionPoolDataSource.java:157)
[3/19/13 23:54:01:021 CDT] 00000018 SystemErr     R at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection(OracleConnectionPoolDataSource.java:94)
[3/19/13 23:54:01:021 CDT] 00000018 SystemErr     R at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection(OracleConnectionPoolDataSource.java:75)
[3/19/13 23:54:01:021 CDT] 00000018 SystemErr     R at com.ibm.ws.rsadapter.DSConfigHelper$1.run(DSConfigHelper.java:1231)
[3/19/13 23:54:01:021 CDT] 00000018 SystemErr     R at com.ibm.ws.security.auth.ContextManagerImpl.runAs(ContextManagerImpl.java:5277)
[3/19/13 23:54:01:021 CDT] 00000018 SystemErr     R at com.ibm.ws.security.auth.ContextManagerImpl.runAsSystem(ContextManagerImpl.java:5493)
[3/19/13 23:54:01:021 CDT] 00000018 SystemErr     R at com.ibm.ws.security.core.SecurityContext.runAsSystem(SecurityContext.java:255)
[3/19/13 23:54:01:021 CDT] 00000018 SystemErr     R at com.ibm.ws.rsadapter.DSConfigHelper$2.run(DSConfigHelper.java:1247)
[3/19/13 23:54:01:021 CDT] 00000018 SystemErr     R at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java:118)
[3/19/13 23:54:01:021 CDT] 00000018 SystemErr     R at com.ibm.ws.rsadapter.DSConfigHelper.getPooledConnection(DSConfigHelper.java:1259)
[3/19/13 23:54:01:021 CDT] 00000018 SystemErr     R at com.ibm.ws.rsadapter.DSConfigHelper.getPooledConnection(DSConfigHelper.java:1154)
[3/19/13 23:54:01:021 CDT] 00000018 SystemErr     R at com.ibm.ws.rsadapter.DSConfigurationHelper.getConnectionFromDSOrPooledDS(DSConfigurationHelper.java:1958)
[3/19/13 23:54:01:021 CDT] 00000018 SystemErr     R at com.ibm.ws.rsadapter.DSConfigurationHelper.getConnectionFromDSOrPooledDS(DSConfigurationHelper.java:1834)
[3/19/13 23:54:01:021 CDT] 00000018 SystemErr     R at com.ibm.ws.rsadapter.DSConfigurationHelper.testConnectionForGUI(DSConfigurationHelper.java:2692)

I have encountered the above error when I tried to Test Connection, after I am done creating the datasource in Websphere Admin console.

Root Cause of the error : I forgot to select
'Component-managed authentication alias' (Make sure to create it first with your username/password for database)



2 comments:

Anonymous said...

Thanks for your info... It helps me to solve my issue...

Unknown said...

Note: I get the same error if both the Component-managed authentication alias and Container-managed authentication alias are set. Have found that If I set Container-managed to (none) then the problem will go away

 My Attempt to learn AI  GPT Generative Pretrained Transformer Created by Google in 2017 with the publication of the paper "Attention ...

Popular in last 30 days