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

Common JPA explanations

**This is just for reference only, most of the source of these infor is taken from stackoverflow.  When to use eager loading In "one si...

Popular in last 30 days