JDBC THIN 12c: getParameterMetaData() Reports java.lang.ArrayIndexOutOfBoundsException

(Doc ID 2322392.1)

Last updated on OCTOBER 31, 2017

Applies to:

JDBC - Version 12.1.0.2.0 to 12.2.0.0.0 [Release 12.1 to 12c]
Information in this document applies to any platform.

Symptoms

A java application using JDBC THIN 12.1.0.2.0 driver (and Oracle database 12c) reports the following exception:

java.lang.ArrayIndexOutOfBoundsException: 50
at oracle.jdbc.driver.OracleParameterMetaDataParser.getParameterMetaDataSql(OracleParameterMetaDataParser.java:468)
at oracle.jdbc.driver.OracleParameterMetaData.getParameterMetaData(OracleParameterMetaData.java:65)
at oracle.jdbc.driver.OraclePreparedStatement.getParameterMetaData(OraclePreparedStatement.java:10541)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.getParameterMetaData(OraclePreparedStatementWrapper.java:1199)
:::::::::

 

Observations

* PreparedStatement is unable to process a complex SQL while fetching meta-data using getParameterMetaData().
* This issue is reproducible even with JDBC THIN 12.2.0.1.0.
* This issue never occurred with JDBC THIN 11.2.0.4.0.

 

  

Changes

 JDBC THIN driver was upgraded from 11.2.0.4.0 to 12.1.0.2.0.

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