java.sql.SQLException: ORA-01000: maximum open cursors exceeded

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Oracle Community by 433880, 1 year ago
ORA-01000: maximum open cursors exceeded
via Oracle Community by 271872, 1 year ago
ORA-00904: "X1"."ST_PLACE": invalid identifier
via Oracle Community by 467820, 1 year ago
ORA-00904: "X1"."ST_PLACE": invalid identifier
via Oracle Community by 452043, 1 year ago
ORA-00904: "X1"."ST_PLACE": invalid identifier
via https://bugzilla.redhat.com/bugzilla/ by Petr Sklenar, 1 year ago
ORA-00904: "KICKSTARTD0_"."PARTITION_DATA": invalid identifier
via Oracle Community by 746915, 1 year ago
ORA-12899: value too large for column "PRD_7"."SUMMARY_TABLE"."PERIOD_END_DT" (actual: 40, maximum: 7)
java.sql.SQLException: ORA-01000: maximum open cursors exceeded
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:671)
at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:597)
at oracle.jdbc.driver.T2CPreparedStatement.executeForDescribe(T2CPreparedStatement.java:570)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1030)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1123)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3284)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3328)
at undefined.TestCursors.main(TestCursors.java:22)

Users with the same issue

4 times, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 8 months ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.