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 MARCH 08, 2017

Applies to:

Oracle Containers for J2EE - Version: 10.1.2.0.2 - Release: AS10gR2
Information in this document applies to any platform.

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 ("pwdtestuser").
- 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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms