org.hibernate.exception.GenericJDBCException: Reading from database

Hibernate JIRA | greg | 1 decade ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    When I tried to run 'hibernate artifact generation' against an Oracle 9i database, exceptions were thrown as follows: !ENTRY org.hibernate.eclipse.console.HibernateConsolePlugin 4 4 2005-03-24 17:46:32.277 !MESSAGE Error under artifact generation !STACK 0 org.hibernate.exception.GenericJDBCException: Reading from database at org.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:92) at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:80) at org.hibernate.cfg.JDBCBinder.readFromDatabase(JDBCBinder.java:125) at org.hibernate.cfg.JDBCMetaDataConfiguration.readFromJDBC(JDBCMetaDataConfiguration.java:40) at org.hibernate.eclipse.console.wizards.ArtifactGeneratorWizard$3.execute(ArtifactGeneratorWizard.java:213) at org.hibernate.console.ConsoleConfiguration.execute(ConsoleConfiguration.java:76) at org.hibernate.eclipse.console.wizards.ArtifactGeneratorWizard.buildConfiguration(ArtifactGeneratorWizard.java:210) at org.hibernate.eclipse.console.wizards.ArtifactGeneratorWizard.doFinish(ArtifactGeneratorWizard.java:147) at org.hibernate.eclipse.console.wizards.ArtifactGeneratorWizard.access$0(ArtifactGeneratorWizard.java:127) at org.hibernate.eclipse.console.wizards.ArtifactGeneratorWizard$1.run(ArtifactGeneratorWizard.java:95) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:105) Caused by: java.sql.SQLException: ORA-01000: maximum open cursors exceeded at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289) at oracle.jdbc.ttc7.Oopen.receive(Oopen.java:120) at oracle.jdbc.ttc7.TTC7Protocol.open(TTC7Protocol.java:586) at oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:385) at oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:413) at oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.java:119) at oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.java:92) at oracle.jdbc.driver.OracleConnection.privatePrepareStatement(OracleConnection.java:950) at oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnection.java:802) at oracle.jdbc.OracleDatabaseMetaData.getColumns(OracleDatabaseMetaData.java:2552) at org.hibernate.cfg.JDBCBinder.processBasicColumns(JDBCBinder.java:708) at org.hibernate.cfg.JDBCBinder.readFromDatabase(JDBCBinder.java:106) ... 8 more !SUBENTRY 1 org.hibernate.eclipse.console.HibernateConsolePlugin 4 4 2005-03-24 17:46:32.287 !MESSAGE Reading from database !STACK 0 ...... Initially I thought the number of tables were too huge, however when I switched to Oracle sample tables, the issue was still the same. I wonder if the test on Oracle has even been done. Thanks!

    Hibernate JIRA | 1 decade ago | greg
    org.hibernate.exception.GenericJDBCException: Reading from database
  2. 0

    When I tried to run 'hibernate artifact generation' against an Oracle 9i database, exceptions were thrown as follows: !ENTRY org.hibernate.eclipse.console.HibernateConsolePlugin 4 4 2005-03-24 17:46:32.277 !MESSAGE Error under artifact generation !STACK 0 org.hibernate.exception.GenericJDBCException: Reading from database at org.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:92) at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:80) at org.hibernate.cfg.JDBCBinder.readFromDatabase(JDBCBinder.java:125) at org.hibernate.cfg.JDBCMetaDataConfiguration.readFromJDBC(JDBCMetaDataConfiguration.java:40) at org.hibernate.eclipse.console.wizards.ArtifactGeneratorWizard$3.execute(ArtifactGeneratorWizard.java:213) at org.hibernate.console.ConsoleConfiguration.execute(ConsoleConfiguration.java:76) at org.hibernate.eclipse.console.wizards.ArtifactGeneratorWizard.buildConfiguration(ArtifactGeneratorWizard.java:210) at org.hibernate.eclipse.console.wizards.ArtifactGeneratorWizard.doFinish(ArtifactGeneratorWizard.java:147) at org.hibernate.eclipse.console.wizards.ArtifactGeneratorWizard.access$0(ArtifactGeneratorWizard.java:127) at org.hibernate.eclipse.console.wizards.ArtifactGeneratorWizard$1.run(ArtifactGeneratorWizard.java:95) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:105) Caused by: java.sql.SQLException: ORA-01000: maximum open cursors exceeded at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289) at oracle.jdbc.ttc7.Oopen.receive(Oopen.java:120) at oracle.jdbc.ttc7.TTC7Protocol.open(TTC7Protocol.java:586) at oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:385) at oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:413) at oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.java:119) at oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.java:92) at oracle.jdbc.driver.OracleConnection.privatePrepareStatement(OracleConnection.java:950) at oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnection.java:802) at oracle.jdbc.OracleDatabaseMetaData.getColumns(OracleDatabaseMetaData.java:2552) at org.hibernate.cfg.JDBCBinder.processBasicColumns(JDBCBinder.java:708) at org.hibernate.cfg.JDBCBinder.readFromDatabase(JDBCBinder.java:106) ... 8 more !SUBENTRY 1 org.hibernate.eclipse.console.HibernateConsolePlugin 4 4 2005-03-24 17:46:32.287 !MESSAGE Reading from database !STACK 0 ...... Initially I thought the number of tables were too huge, however when I switched to Oracle sample tables, the issue was still the same. I wonder if the test on Oracle has even been done. Thanks!

    Hibernate JIRA | 1 decade ago | greg
    org.hibernate.exception.GenericJDBCException: Reading from database
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    Middlegen / Mailing Lists

    sourceforge.net | 1 year ago
    java.sql.SQLException: ORA-01000: maximum open cursors exceeded
  5. 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

  1. rp 1 times, last 4 months 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:134)
    1 frame
  3. oracle.jdbc.ttc7
    TTC7Protocol.open
    1. oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
    2. oracle.jdbc.ttc7.Oopen.receive(Oopen.java:120)
    3. oracle.jdbc.ttc7.TTC7Protocol.open(TTC7Protocol.java:586)
    3 frames
  4. Oracle jdbc
    OracleDatabaseMetaData.getColumns
    1. oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:385)
    2. oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:413)
    3. oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.java:119)
    4. oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.java:92)
    5. oracle.jdbc.driver.OracleConnection.privatePrepareStatement(OracleConnection.java:950)
    6. oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnection.java:802)
    7. oracle.jdbc.OracleDatabaseMetaData.getColumns(OracleDatabaseMetaData.java:2552)
    7 frames
  5. Hibernate
    JDBCMetaDataConfiguration.readFromJDBC
    1. org.hibernate.cfg.JDBCBinder.processBasicColumns(JDBCBinder.java:708)
    2. org.hibernate.cfg.JDBCBinder.readFromDatabase(JDBCBinder.java:106)
    3. org.hibernate.cfg.JDBCMetaDataConfiguration.readFromJDBC(JDBCMetaDataConfiguration.java:40)
    3 frames
  6. org.hibernate.eclipse
    ArtifactGeneratorWizard$3.execute
    1. org.hibernate.eclipse.console.wizards.ArtifactGeneratorWizard$3.execute(ArtifactGeneratorWizard.java:213)
    1 frame
  7. org.hibernate.console
    ConsoleConfiguration.execute
    1. org.hibernate.console.ConsoleConfiguration.execute(ConsoleConfiguration.java:76)
    1 frame
  8. org.hibernate.eclipse
    ArtifactGeneratorWizard$1.run
    1. org.hibernate.eclipse.console.wizards.ArtifactGeneratorWizard.buildConfiguration(ArtifactGeneratorWizard.java:210)
    2. org.hibernate.eclipse.console.wizards.ArtifactGeneratorWizard.doFinish(ArtifactGeneratorWizard.java:147)
    3. org.hibernate.eclipse.console.wizards.ArtifactGeneratorWizard.access$0(ArtifactGeneratorWizard.java:127)
    4. org.hibernate.eclipse.console.wizards.ArtifactGeneratorWizard$1.run(ArtifactGeneratorWizard.java:95)
    4 frames
  9. JFace
    ModalContext$ModalContextThread.run
    1. org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:105)
    1 frame