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

  1. rp 1 times, last 3 weeks ago
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