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

Oracle Community | 3004 | 1 decade ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    oracle max cursors problem

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

    ORA-01000 maximum open cursor WLS 6.0sp2 and Oracle 8.1.7

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

    JDBC - ORA-01000: maximum open cursors exceeded

    Oracle Community | 1 decade ago | 3004
    java.sql.SQLException: ORA-01000: maximum open cursors exceeded
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    problem while inserting into oracle

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

    maximum open cursors exceeded exception in java code

    Stack Overflow | 6 months ago | Shrikant Dande
    java.sql.SQLException: ORA-01000: maximum open cursors exceeded
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:180)
    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:472)
    3 frames
  4. Oracle jdbc
    OracleConnection.createStatement
    1. oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:499)
    2. oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:518)
    3. oracle.jdbc.driver.OracleConnection.privateCreateStatement(OracleConnection.java:680)
    4. oracle.jdbc.driver.OracleConnection.createStatement(OracleConnection.java:582)
    4 frames
  5. com.solarmetric.datasource
    PoolConnection.createStatement
    1. com.solarmetric.datasource.ConnectionWrapper.createStatement(ConnectionWrapper.java:368)
    2. com.solarmetric.datasource.PoolConnection.createStatement(PoolConnection.java:62)
    2 frames
  6. com.solarmetric.kodo
    StateManagerImpl.isLoaded
    1. com.solarmetric.kodo.impl.jdbc.SQLExecutionManagerImpl.createStatement(SQLExecutionManagerImpl.java:742)
    2. com.solarmetric.kodo.impl.jdbc.SQLExecutionManagerImpl.executeNonPreparedQueryInternal(SQLExecutionManagerImpl.java:715)
    3. com.solarmetric.kodo.impl.jdbc.SQLExecutionManagerImpl.executeQueryInternal(SQLExecutionManagerImpl.java:693)
    4. com.solarmetric.kodo.impl.jdbc.SQLExecutionManagerImpl.executeQuery(SQLExecutionManagerImpl.java:372)
    5. com.solarmetric.kodo.impl.jdbc.SQLExecutionManagerImpl.executeQuery(SQLExecutionManagerImpl.java:356)
    6. com.solarmetric.kodo.impl.jdbc.ormapping.ClassMapping.selectPrimaryMappings(ClassMapping.java:1221)
    7. com.solarmetric.kodo.impl.jdbc.ormapping.OneToManyMapping.load(OneToManyMapping.java:80)
    8. com.solarmetric.kodo.impl.jdbc.runtime.JDBCStoreManager.load(JDBCStoreManager.java:375)
    9. com.solarmetric.kodo.runtime.StateManagerImpl.loadField(StateManagerImpl.java:2035)
    10. com.solarmetric.kodo.runtime.StateManagerImpl.isLoaded(StateManagerImpl.java:720)
    10 frames
  7. de.siemens.med
    ArrayListProxy.size
    1. de.siemens.med.pacs.pfw.om.composite.PPatient.jdoGetOtherPatientNames(PPatient.java)
    2. de.siemens.med.pacs.pfw.om.composite.PPatient.access$000(PPatient.java:17)
    3. de.siemens.med.pacs.pfw.om.composite.PPatient$1.getList(PPatient.java:517)
    4. de.siemens.med.pacs.pfw.ArrayListProxy.size(ArrayListProxy.java:46)
    4 frames
  8. Java RT
    AbstractList$Itr.hasNext
    1. java.util.AbstractList$Itr.hasNext(AbstractList.java:411)
    1 frame
  9. de.siemens.med
    PNReadHandler.read
    1. de.siemens.med.pacs.businessproc.generic.read.PNReadHandler.read(PNReadHandler.java:54)
    1 frame