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

Oracle Community | 3004 | 1 decade ago
  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