My Oracle Support Banner

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

Last updated on JANUARY 31, 2019

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 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.


NOTE: This issue is not particular to WebLogic application server. It can happen with Oracle JDBC standalone or third-party application servers using JDBC 12.1.0.2.

Changes

 Upgrade from WebLogic 10.3.2 to WebLogic 12.1.3.

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
Changes
Cause
Solution
References


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