ORA-1000 and ORA-904 With JDBC 12.1.0.2 (Doc ID 2048420.1)

Last updated on AUGUST 30, 2023

Applies to:

Symptoms

On : 12.1.0.2 version, Thin JDBC driver

WebLogic 12.1.3 ojdbc7.jar does not behave the same as earlier versions of WebLogic.
After upgrading an application which has been running in WebLogic 10.3.2 to WebLogic 12.1.3, the application is getting too many open cursors from the database.
This worked on WebLogic 12.1.2, and only fails when moving to WebLogic 12.1.3.
As a workaround, trying to move ojdbc6.jar file from WebLogic 10.3.2 to the 12.1.3 box and put it in the pre classpath for a test, generates exceptions.

Database error:

ORA-01000: maximum open cursors exceeded

In application (JDBC logging):

DEBUG 4175 StatementCreatorUtils.setNull Could not check database or driver name
java.sql.SQLSyntaxErrorException: ORA-00904: "F": invalid identifier

  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:392)
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:385)
  at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:1018)
  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)
  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)
  at oracle.jdbc.driver.T4C8Odscrarr.doODNY(T4C8Odscrarr.java:96)
  at oracle.jdbc.driver.T4CPreparedStatement.doDescribe(T4CPreparedStatement.java:717)
  at oracle.jdbc.driver.OracleStatement.describe(OracleStatement.java:4404)
  at oracle.jdbc.driver.OracleResultSetMetaData.(OracleResultSetMetaData.java:52)
  at oracle.jdbc.driver.OracleStatement.getResultSetMetaData(OracleStatement.java:4387)
  at oracle.jdbc.driver.OraclePreparedStatement.getMetaData(OraclePreparedStatement.java:5581)
  at oracle.jdbc.driver.OraclePreparedStatementWrapper.getMetaData(OraclePreparedStatementWrapper.java:1509)
  at oracle.jdbc.driver.OracleParameterMetaData.getParameterMetaData(OracleParameterMetaData.java:70)
  at oracle.jdbc.driver.OraclePreparedStatement.getParameterMetaData(OraclePreparedStatement.java:12861)
  at oracle.jdbc.driver.OraclePreparedStatementWrapper.getParameterMetaData(OraclePreparedStatementWrapper.java:1551)
  at weblogic.jdbc.wrapper.PreparedStatement.getParameterMetaData(PreparedStatement.java:1668)
  at org.springframework.jdbc.core.StatementCreatorUtils.setNull(StatementCreatorUtils.java:234)
  at org.springframework.jdbc.core.StatementCreatorUtils.setParameterValueInternal(StatementCreatorUtils.java:214)
  at org.springframework.jdbc.core.StatementCreatorUtils.setParameterValue(StatementCreatorUtils.java:145)
  at org.springframework.jdbc.core.ArgPreparedStatementSetter.doSetValue(ArgPreparedStatementSetter.java:65)
  at org.springframework.jdbc.core.ArgPreparedStatementSetter.setValues(ArgPreparedStatementSetter.java:46)
  at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:816)
  at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:1)
  at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:587)
  at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:812)
  at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:868)
  at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:876)

STEPS
-----------------------
The issue can be reproduced after :
1. Upgrading WebLogic from 10.3.2 to WebLogic 12.1.2
2. Then, upgrading from 12.1.2 to WebLogic 12.1.3.
3. Running application in this new version.

Changes

 Upgrade from WebLogic 10.3.2 to WebLogic 12.1.3.

Cause

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