"SQLException: ORA-01000: maximum open cursors exceeded" in JBoss EAP

Solution Verified - Updated -

Issue

  • Encountering ORA-01000 when executing a query in JBoss

    java.sql.SQLException: ORA-01000: maximum open cursors exceeded
        ...
        at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3887)
        at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4230)
        at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1079)
        at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.execute(WrappedPreparedStatement.java:442)
        ...
    

Environment

  • Red Hat JBoss Enterprise Application Platform (EAP)
    • 7
    • 6
  • Oracle

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In