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

Oracle Community | 3004 | 1 decade ago
  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 | 2 months ago | Shrikant Dande
    java.sql.SQLException: ORA-01000: maximum open cursors exceeded

    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: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