Password Indirection In Data-sources.xml in Oracle Application Server 10.1.2.0.2 Fails With java.sql.SQLException: invalid arguments in call (Doc ID 987624.1)

Last updated on OCTOBER 21, 2024

Applies to:

Symptoms

In OC4J 10.1.2.0.2, there is failure to get database connection from datasource configured with indirect password, even though:

- there is a "testuser" defined in the application jazn-data with correct password to the database.
- in datasource the password of the datasource is "->testuser" (so password indirection to the testuser is defined).
- when the application is invoked, the database connection is not obtained, getting in the log file the error:

ERROR
---------
Caused by: java.sql.SQLException: invalid arguments in call
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:137)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:174)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:239)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:205)

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.