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

Oracle Community | 3004 | 1 decade ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    stale db cursors

    Oracle Community | 1 decade ago | 3004
    java.sql.SQLException: ORA-01000: maximum open cursors exceeded
  2. 0

    Open cursor error in Oracle

    Oracle Community | 2 decades ago | 14272
    java.sql.SQLException: ORA-01000: maximum open cursors exceeded
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    catching all unclosed statements/prepared Statements of a Connection

    Oracle Community | 1 decade ago | 843854
    java.sql.SQLException: ORA-01000: maximum open cursors exceeded
  5. 0

    java.lang.NullPointerException when using reestablishConnection

    Oracle Community | 10 years ago | 575987
    java.sql.SQLException: ORA-00028: your session has been killed Error Code: 28 Call:SELECT PART_NBR, PART_DESC, WHOLESALE_PRICE, SUPERSESSION_IND FROM PARTSPRICEBOOKGUIDE WHERE PART_NBR = ? bind => [07129952117] Query:ReadAllQuery(com.bmw.etl.parts.pricebook.entity.dcs.DCSPartPriceBookEntity)
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.sql.SQLException

    ORA-01000: maximum open cursors exceeded

    at oracle.jdbc.dbaccess.DBError.throwSqlException()
  2. oracle.jdbc.dbaccess
    DBError.throwSqlException
    1. oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
    1 frame
  3. oracle.jdbc.ttc7
    TTC7Protocol.open
    1. oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
    2. oracle.jdbc.ttc7.Oopen.receive(Oopen.java:118)
    3. oracle.jdbc.ttc7.TTC7Protocol.open(TTC7Protocol.java:466)
    3 frames
  4. Oracle jdbc
    OracleConnection.prepareStatement
    1. oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:413)
    2. oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:432)
    3. oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.java:182)
    4. oracle.jdbc.driver.OracleConnection.privatePrepareStatement(OracleConnection..java:602)
    5. oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnection.java:538)
    5 frames
  5. com.solarmetric.datasource
    ConnectionWrapper.prepareStatement
    1. com.solarmetric.datasource.ConnectionWrapper.prepareStatement(ConnectionWrapper.java:420)
    2. com.solarmetric.datasource.PreparedStatementCache$CacheAwareConnection.prepareStatement(PreparedStatementCache.java:208)
    3. com.solarmetric.datasource.ConnectionWrapper.prepareStatement(ConnectionWrapper.java:420)
    3 frames
  6. com.solarmetric.kodo
    StateManagerImpl.loadField
    1. com.solarmetric.kodo.impl.jdbc.schema.dict.AbstractDictionary.prepareStatement(AbstractDictionary.java:2049)
    2. com.solarmetric.kodo.impl.jdbc.SQLExecutionManagerImpl.prepareStatementInternal(SQLExecutionManagerImpl.java:727)
    3. com.solarmetric.kodo.impl.jdbc.SQLExecutionManagerImpl.executePreparedQueryInternal(SQLExecutionManagerImpl.java:691)
    4. com.solarmetric.kodo.impl.jdbc.SQLExecutionManagerImpl.executeQueryInternal(SQLExecutionManagerImpl.java:600)
    5. com.solarmetric.kodo.impl.jdbc.SQLExecutionManagerImpl.executeQuery(SQLExecutionManagerImpl.java:355)
    6. com.solarmetric.kodo.impl.jdbc.SQLExecutionManagerImpl.executeQuery(SQLExecutionManagerImpl.java:339)
    7. com.solarmetric.kodo.impl.jdbc.ormapping.ClassMapping.selectPrimaryMappings(ClassMapping.java:1334)
    8. com.solarmetric.kodo.impl.jdbc.ormapping.ManyToManyMapping.load(ManyToManyMapping.java:136)
    9. com.solarmetric.kodo.impl.jdbc.runtime.JDBCStoreManager.load(JDBCStoreManager.java:454)
    10. com.solarmetric.kodo.runtime.StateManagerImpl.loadField(StateManagerImpl.java:2238)
    10 frames