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
_______________________________________________
middlegen-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/middlegen-user

Reply via email to