java.sql.SQLException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • 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)
    via by Erik vH,
  • 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)
    via by Erik vH,
  • Open cursor error in Oracle
    via by 14272,
  • problem while inserting into oracle
    via by 3004,
  • 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!
    via by greg,
  • Middlegen / Mailing Lists
    via by Unknown author,
  • Intermittent apps logon error
    via by 518652,
    • 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)

    Users with the same issue

    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor2 times, last one,
    rprp
    1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    28 more bugmates