getParameterMetaData Causes ArrayIndexOutOfBoundsException After Upgrade To JDBC 12C (Doc ID 2064720.1)

Last updated on AUGUST 09, 2023

Applies to:

Symptoms

 After upgrade JDBC Driver to 12.1.0.x, getParameterMetaData causes ArrayIndexOutOfBoundsException.

 Stack examples:

   java.lang.ArrayIndexOutOfBoundsException: -5
    at oracle.jdbc.driver.OracleParameterMetaDataParser.computeBasicInfo(OracleParameterMetaDataParser.java:277)
    at oracle.jdbc.driver.OracleParameterMetaDataParser.getParameterMetaDataSql(OracleParameterMetaDataParser.java:433)
    at oracle.jdbc.driver.OracleParameterMetaData.getParameterMetaData(OracleParameterMetaData.java:58)
    at oracle.jdbc.driver.OraclePreparedStatement.getParameterMetaData(OraclePreparedStatement.java:12861)
    at oracle.jdbc.driver.OraclePreparedStatementWrapper.getParameterMetaData(OraclePreparedStatementWrapper.java:1551)
    at ConsoleTestForBug.doTest(ConsoleTestForBug.java:78)
    at ConsoleTestForBug.main(ConsoleTestForBug.java:30)

 
 java.lang.ArrayIndexOutOfBoundsException: -5
   at oracle.jdbc.driver.OracleParameterMetaDataParser.computeBasicInfo(OracleParameterMetaDataParser.java:276)
   at oracle.jdbc.driver.OracleParameterMetaDataParser.getParameterMetaDataSql(OracleParameterMetaDataParser.java:432)
   at oracle.jdbc.driver.OracleParameterMetaData.getParameterMetaData(OracleParameterMetaData.java:58)
   at oracle.jdbc.driver.OraclePreparedStatement.getParameterMetaData(OraclePreparedStatement.java:11621)
   at oracle.jdbc.driver.OraclePreparedStatementWrapper.getParameterMetaData(OraclePreparedStatementWrapper.java:1552)
   at Ojdbc7Error.main(Ojdbc7Error.java:70)

 
 java.lang.ArrayIndexOutOfBoundsException: 128
   at oracle.jdbc.driver.OracleParameterMetaDataParser.computeBasicInfo(OracleParameterMetaDataParser.java:327)
   at oracle.jdbc.driver.OracleParameterMetaDataParser.getParameterMetaDataSql(OracleParameterMetaDataParser.java:433)
   at oracle.jdbc.driver.OracleParameterMetaData.getParameterMetaData(OracleParameterMetaData.java:60)
   at oracle.jdbc.driver.OraclePreparedStatement.getParameterMetaData(OraclePreparedStatement.java:12861)
   at oracle.jdbc.driver.OraclePreparedStatementWrapper.getParameterMetaData(OraclePreparedStatementWrapper.java:1551)
   at JdbcTest.main(JdbcTest.java:58)


It works fine if you use JDBC drivers version 11.2.0.x.

Changes

 Upgrade JDBC Driver to 12c.

Cause

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