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

Hibernate JIRA | Erik vH | 1 decade ago
  1. 0

    During 'Reverse engineer from JDBC connection' (might be related to the fact that the database contains about 9000 tables... a PeopleSoft environment... I only want to use 100 tables or so, but I did not see a way to select them). java.sql.SQLException: ORA-01000: maximum open cursors exceeded at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208) at oracle.jdbc.ttc7.Oopen.receive(Oopen.java:118) at oracle.jdbc.ttc7.TTC7Protocol.open(TTC7Protocol.java:426) at oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:288) at oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:307) at oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.java:191) at oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.java:174) at oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnection.java:339) at oracle.jdbc.driver.OracleDatabaseMetaData.getColumns(OracleDatabaseMetaData.java:2414) at org.hibernate.cfg.JDBCBinder.processBasicColumns(JDBCBinder.java:732) at org.hibernate.cfg.JDBCBinder.readDatabaseSchema(JDBCBinder.java:123) at org.hibernate.cfg.JDBCBinder.readFromDatabase(JDBCBinder.java:91) at org.hibernate.cfg.JDBCMetaDataConfiguration.readFromJDBC(JDBCMetaDataConfiguration.java:37) at org.hibernate.eclipse.console.wizards.ArtifactGeneratorWizard$3.execute(ArtifactGeneratorWizard.java:237) at org.hibernate.console.ConsoleConfiguration.execute(ConsoleConfiguration.java:77) at org.hibernate.eclipse.console.wizards.ArtifactGeneratorWizard.buildConfiguration(ArtifactGeneratorWizard.java:234) at org.hibernate.eclipse.console.wizards.ArtifactGeneratorWizard.doFinish(ArtifactGeneratorWizard.java:164) at org.hibernate.eclipse.console.wizards.ArtifactGeneratorWizard.access$0(ArtifactGeneratorWizard.java:132) at org.hibernate.eclipse.console.wizards.ArtifactGeneratorWizard$1.run(ArtifactGeneratorWizard.java:98) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113)

    Hibernate JIRA | 1 decade ago | Erik vH
    java.sql.SQLException: ORA-01000: maximum open cursors exceeded
  2. 0

    During 'Reverse engineer from JDBC connection' (might be related to the fact that the database contains about 9000 tables... a PeopleSoft environment... I only want to use 100 tables or so, but I did not see a way to select them). java.sql.SQLException: ORA-01000: maximum open cursors exceeded at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208) at oracle.jdbc.ttc7.Oopen.receive(Oopen.java:118) at oracle.jdbc.ttc7.TTC7Protocol.open(TTC7Protocol.java:426) at oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:288) at oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:307) at oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.java:191) at oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.java:174) at oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnection.java:339) at oracle.jdbc.driver.OracleDatabaseMetaData.getColumns(OracleDatabaseMetaData.java:2414) at org.hibernate.cfg.JDBCBinder.processBasicColumns(JDBCBinder.java:732) at org.hibernate.cfg.JDBCBinder.readDatabaseSchema(JDBCBinder.java:123) at org.hibernate.cfg.JDBCBinder.readFromDatabase(JDBCBinder.java:91) at org.hibernate.cfg.JDBCMetaDataConfiguration.readFromJDBC(JDBCMetaDataConfiguration.java:37) at org.hibernate.eclipse.console.wizards.ArtifactGeneratorWizard$3.execute(ArtifactGeneratorWizard.java:237) at org.hibernate.console.ConsoleConfiguration.execute(ConsoleConfiguration.java:77) at org.hibernate.eclipse.console.wizards.ArtifactGeneratorWizard.buildConfiguration(ArtifactGeneratorWizard.java:234) at org.hibernate.eclipse.console.wizards.ArtifactGeneratorWizard.doFinish(ArtifactGeneratorWizard.java:164) at org.hibernate.eclipse.console.wizards.ArtifactGeneratorWizard.access$0(ArtifactGeneratorWizard.java:132) at org.hibernate.eclipse.console.wizards.ArtifactGeneratorWizard$1.run(ArtifactGeneratorWizard.java:98) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113)

    Hibernate JIRA | 1 decade ago | Erik vH
    java.sql.SQLException: ORA-01000: maximum open cursors exceeded
  3. 0

    Open cursor error in Oracle

    Oracle Community | 2 decades ago | 14272
    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

    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:114)
      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:426)
      3 frames
    4. Oracle jdbc
      OracleDatabaseMetaData.getColumns
      1. oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:288)
      2. oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:307)
      3. oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.java:191)
      4. oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.java:174)
      5. oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnection.java:339)
      6. oracle.jdbc.driver.OracleDatabaseMetaData.getColumns(OracleDatabaseMetaData.java:2414)
      6 frames
    5. Hibernate
      JDBCMetaDataConfiguration.readFromJDBC
      1. org.hibernate.cfg.JDBCBinder.processBasicColumns(JDBCBinder.java:732)
      2. org.hibernate.cfg.JDBCBinder.readDatabaseSchema(JDBCBinder.java:123)
      3. org.hibernate.cfg.JDBCBinder.readFromDatabase(JDBCBinder.java:91)
      4. org.hibernate.cfg.JDBCMetaDataConfiguration.readFromJDBC(JDBCMetaDataConfiguration.java:37)
      4 frames
    6. org.hibernate.eclipse
      ArtifactGeneratorWizard$3.execute
      1. org.hibernate.eclipse.console.wizards.ArtifactGeneratorWizard$3.execute(ArtifactGeneratorWizard.java:237)
      1 frame
    7. org.hibernate.console
      ConsoleConfiguration.execute
      1. org.hibernate.console.ConsoleConfiguration.execute(ConsoleConfiguration.java:77)
      1 frame
    8. org.hibernate.eclipse
      ArtifactGeneratorWizard$1.run
      1. org.hibernate.eclipse.console.wizards.ArtifactGeneratorWizard.buildConfiguration(ArtifactGeneratorWizard.java:234)
      2. org.hibernate.eclipse.console.wizards.ArtifactGeneratorWizard.doFinish(ArtifactGeneratorWizard.java:164)
      3. org.hibernate.eclipse.console.wizards.ArtifactGeneratorWizard.access$0(ArtifactGeneratorWizard.java:132)
      4. org.hibernate.eclipse.console.wizards.ArtifactGeneratorWizard$1.run(ArtifactGeneratorWizard.java:98)
      4 frames
    9. JFace
      ModalContext$ModalContextThread.run
      1. org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113)
      1 frame