Error connection to oracle database.
"Pedro Faria Costa" <[email protected]>
| Newsgroups | gmane.comp.java.ejb.middlegen.user |
|---|---|
| Message-ID | <[email protected]> |
Hi, i have build middlegen from CVS head and i'm getting the following error connecting to a oracle database: ORA-01000: maximum open cursors exceeded. (the full stack trace is at the botton) however, it works fine if a run middlegen v.2.0.vo with exactly with the same configuration. was there any change to code since 2.0 that could explain why i'm having this problem using cvs HEAD? thanks for any help, Pedro Costa. [middlegen] (middlegen.MiddlegenPopulator 495 ) Couldn't get schemas [middlegen] java.sql.SQLException: ORA-01000: maximum open cursors exceeded [middlegen] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) [middlegen] at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289) [middlegen] at oracle.jdbc.ttc7.Oopen.receive(Oopen.java:120) [middlegen] at oracle.jdbc.ttc7.TTC7Protocol.open(TTC7Protocol.java:586) [middlegen] at oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:385) [middlegen] at oracle.jdbc.driver.OracleConnection.privateCreateStatement(OracleConnection.java:772) [middlegen] at oracle.jdbc.driver.OracleConnection.createStatement(OracleConnection.java:712) [middlegen] at oracle.jdbc.OracleDatabaseMetaData.getSchemas(OracleDatabaseMetaData.java:2311) [middlegen] at middlegen.MiddlegenPopulator.getDatabaseStructure(MiddlegenPopulator.java:489) [middlegen] at middlegen.MiddlegenPopulator.markFksToUnwantedTables(MiddlegenPopulator.java:721) [middlegen] at middlegen.MiddlegenPopulator.populate(MiddlegenPopulator.java:226) [middlegen] at middlegen.MiddlegenTask.execute(MiddlegenTask.java:432) [middlegen] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:269) [middlegen] at org.apache.tools.ant.Task.perform(Task.java:364) [middlegen] at org.apache.tools.ant.Target.execute(Target.java:301) [middlegen] at org.apache.tools.ant.Target.performTasks(Target.java:328) [middlegen] at org.apache.tools.ant.Project.executeTarget(Project.java:1215) [middlegen] at org.apache.tools.ant.Project.executeTargets(Project.java:1063) [middlegen] at org.apache.tools.ant.Main.runBuild(Main.java:632) [middlegen] at org.apache.tools.ant.Main.startAnt(Main.java:183) [middlegen] at org.apache.tools.ant.launch.Launcher.run(Launcher.java:197) [middlegen] at org.apache.tools.ant.launch.Launcher.main(Launcher.java:56) [middlegen] (middlegen.MiddlegenPopulator 511 ) Couldn't get catalogs [middlegen] java.sql.SQLException: ORA-01000: maximum open cursors exceeded [middlegen] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) [middlegen] at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289) [middlegen] at oracle.jdbc.ttc7.Oopen.receive(Oopen.java:120) [middlegen] at oracle.jdbc.ttc7.TTC7Protocol.open(TTC7Protocol.java:586) [middlegen] at oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:385) [middlegen] at oracle.jdbc.driver.OracleConnection.privateCreateStatement(OracleConnection.java:772) [middlegen] at oracle.jdbc.driver.OracleConnection.createStatement(OracleConnection.java:712) [middlegen] at oracle.jdbc.OracleDatabaseMetaData.getCatalogs(OracleDatabaseMetaData.java:2335) [middlegen] at middlegen.MiddlegenPopulator.getDatabaseStructure(MiddlegenPopulator.java:505) [middlegen] at middlegen.MiddlegenPopulator.markFksToUnwantedTables(MiddlegenPopulator.java:721) [middlegen] at middlegen.MiddlegenPopulator.populate(MiddlegenPopulator.java:226) [middlegen] at middlegen.MiddlegenTask.execute(MiddlegenTask.java:432) [middlegen] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:269) [middlegen] at org.apache.tools.ant.Task.perform(Task.java:364) [middlegen] at org.apache.tools.ant.Target.execute(Target.java:301) [middlegen] at org.apache.tools.ant.Target.performTasks(Target.java:328) [middlegen] at org.apache.tools.ant.Project.executeTarget(Project.java:1215) [middlegen] at org.apache.tools.ant.Project.executeTargets(Project.java:1063) [middlegen] at org.apache.tools.ant.Main.runBuild(Main.java:632) [middlegen] at org.apache.tools.ant.Main.startAnt(Main.java:183) [middlegen] at org.apache.tools.ant.launch.Launcher.run(Launcher.java:197) [middlegen] at org.apache.tools.ant.launch.Launcher.main(Launcher.java:56) [middlegen] (middlegen.MiddlegenPopulator 722 ) ORA-01000: maximum open cursors exceeded [middlegen] java.sql.SQLException: ORA-01000: maximum open cursors exceeded [middlegen] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) [middlegen] at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289) [middlegen] at oracle.jdbc.ttc7.Oopen.receive(Oopen.java:120) [middlegen] at oracle.jdbc.ttc7.TTC7Protocol.open(TTC7Protocol.java:586) [middlegen] at oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:385) [middlegen] at oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:413) [middlegen] at oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.java:119) [middlegen] at oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.java:92) [middlegen] at oracle.jdbc.driver.OracleConnection.privatePrepareStatement(OracleConnection.java:950) [middlegen] at oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnection.java:802) [middlegen] at oracle.jdbc.OracleDatabaseMetaData.keys_query(OracleDatabaseMetaData.java:2967) [middlegen] at oracle.jdbc.OracleDatabaseMetaData.getExportedKeys(OracleDatabaseMetaData.java:3167) [middlegen] at middlegen.MiddlegenPopulator.markFksToUnwantedTables(MiddlegenPopulator.java:706) [middlegen] at middlegen.MiddlegenPopulator.populate(MiddlegenPopulator.java:226) [middlegen] at middlegen.MiddlegenTask.execute(MiddlegenTask.java:432) [middlegen] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:269) [middlegen] at org.apache.tools.ant.Task.perform(Task.java:364) [middlegen] at org.apache.tools.ant.Target.execute(Target.java:301) [middlegen] at org.apache.tools.ant.Target.performTasks(Target.java:328) [middlegen] at org.apache.tools.ant.Project.executeTarget(Project.java:1215) [middlegen] at org.apache.tools.ant.Project.executeTargets(Project.java:1063) [middlegen] at org.apache.tools.ant.Main.runBuild(Main.java:632) [middlegen] at org.apache.tools.ant.Main.startAnt(Main.java:183) [middlegen] at org.apache.tools.ant.launch.Launcher.run(Launcher.java:197) [middlegen] at org.apache.tools.ant.launch.Launcher.main(Launcher.java:56) BUILD FAILED C:\workspace\taric_daos\middlegen.xml:94: middlegen.MiddlegenException: Couldn't get list of tables from database. Proba bly a JDBC driver problem. Configured schema:ALF Configured catalog:null ?? Couldn't get schemas ?? ?? Couldn't get catalogs ?? ------------------------------------------------------- This SF.Net email is sponsored by Sleepycat Software Learn developer strategies Cisco, Motorola, Ericsson & Lucent use to deliver higher performing products faster, at low TCO. http://www.sleepycat.com/telcomwpreg.php?From=osdnemail3