ORA-1000 and ORA-904 After WebLogic Upgrade to 12.1.3 With JDBC 12.1.0.2 (Doc ID 2048420.1)

Last updated on AUGUST 10, 2017

Applies to:

JDBC - Version 12.1.0.2.0 and later
Oracle WebLogic Server - Version 12.1.3.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.0.2 version, Thin JDBC driver

WebLogic 12.1.3 ojdbc7.jar not behaving the same as earlier versions of WebLogic, causing ora-1000 maximum open cursors exceeded.

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:

dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x0, level=3, mask=0x0)
----- Error Stack Dump -----
ORA-01000: maximum open cursors exceeded


In application (JDBC logging):

1.0 2015-07-29 19:31:34,409 GMT-0500 WTC-392092-L1 [pool-3-thread-2] 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

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