[Middlegen-user] Error connection to oracle database.

[Pedro Faria Costa]

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 ??