My Oracle Support Banner

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 AUGUST 10, 2018

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
  Symptoms
  Cause
  Solution

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

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