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)

    26 unregistered visitors
    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