ORA-1000 and ORA-904 With JDBC 12.1.0.2
(Doc ID 2048420.1)
Last updated on AUGUST 30, 2023
Applies to:
JDBC - Version 12.1.0.2.0 and laterOracle 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.
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 |