org.hibernate.exception.GenericJDBCException: Reading from database

Hibernate JIRA | greg | 1 decade ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards 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 | 11 months 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 3 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