Here's the hibernate.reveng.xml that's used - maybe we need to exclude more tables for Oracle?
You should be able to copy/paste this into src/main/resources/hibernate.reveng.xml if you want to customize it. <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE hibernate-reverse-engineering SYSTEM "http://hibernate.sourceforge.net/hibernate-reverse-engineering-3.0.dtd"; > <hibernate-reverse-engineering> <type-mapping> <!-- jdbc-type is name fom java.sql.Types --> <sql-type jdbc-type="VARCHAR" length='1' hibernate-type="yes_no"/> <!-- length, scale and precision can be used to specify the mapping precisly --> <sql-type jdbc-type="NUMERIC" precision='1' hibernate-type="boolean"/> <!-- the type-mappings are ordered. This mapping will be consulted last, thus overriden by the previous one if precision=1 for the column --> <sql-type jdbc-type="BIGINT" hibernate-type="java.lang.Long"/> <sql-type jdbc-type="INTEGER" hibernate-type="java.lang.Long"/> <sql-type jdbc-type="NUMERIC" hibernate-type="java.lang.Long"/> </type-mapping> <!-- BIN$ is recycle bin tables in Oracle --> <table-filter match-name="BIN$.*" exclude="true"/> <!-- Exclude AppFuse tables from all catalogs/schemas --> <table-filter match-name="app_user" exclude="true"/> <table-filter match-name="role" exclude="true"/> <table-filter match-name="user_role" exclude="true"/> </hibernate-reverse-engineering> Matt On 9/11/07, Nguyen Thi Van An <[EMAIL PROTECTED]> wrote: > > Hi all, > > I run "mvn appfuse:gen-model -DdisableInstallation=true" on mysql for > Appfuse 2.0-rc1 Struts 2 Basic, it's OK. I have tested successful Oracle 9 > for running appfuse-struts-basic. > But "mvn appfuse:gen-model -DdisableInstallation=true" when I run it on > Oracle 9, it throws exception: > > ...... > 16:46:24,093 WARN org.hibernate.cfg.reveng.JDBCReader - Exception while > trying to get indexinfo on SYSTEM.DEF$_LOB=Exception while getting index > info for SYSTEM.DEF$_LOB > [INFO] > ------------------------------------------------------------------------ > [ERROR] FATAL ERROR > [INFO] > ------------------------------------------------------------------------ > [INFO] Error while reading column meta data for SYSTEM.DEF$_ORIGIN > ORA-01000: maximum open cursors exceeded > > [INFO] > ------------------------------------------------------------------------ > [INFO] Trace > org.hibernate.exception.GenericJDBCException: Error while reading column > meta data for SYSTEM.DEF$_ORIGIN > at > org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103) > at > org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91) > at > org.hibernate.cfg.reveng.dialect.JDBCMetaDataDialect.getColumns(JDBCMetaDataDialect.java:146) > at > org.hibernate.cfg.reveng.JDBCReader.processBasicColumns(JDBCReader.java:546) > at > org.hibernate.cfg.reveng.JDBCReader.readDatabaseSchema(JDBCReader.java:84) > at > org.hibernate.cfg.reveng.JDBCReader.readDatabaseSchema(JDBCReader.java:828) > at > org.hibernate.cfg.JDBCBinder.readDatabaseSchema(JDBCBinder.java:118) > at org.hibernate.cfg.JDBCBinder.readFromDatabase(JDBCBinder.java:89) > at > org.hibernate.cfg.JDBCMetaDataConfiguration.readFromJDBC(JDBCMetaDataConfiguration.java:40) > at > org.codehaus.mojo.hibernate3.configuration.JDBCComponentConfiguration.doConfiguration(JDBCComponentConfiguration.java:67) > at > org.codehaus.mojo.hibernate3.configuration.AbstractComponentConfiguration.getConfiguration(AbstractComponentConfiguration.java:37) > at > org.appfuse.mojo.HibernateExporterMojo.configureExporter(HibernateExporterMojo.java:180) > at > org.appfuse.mojo.exporter.ModelGeneratorMojo.configureExporter(ModelGeneratorMojo.java:185) > at > org.appfuse.mojo.HibernateExporterMojo.doExecute(HibernateExporterMojo.java:228) > at > org.appfuse.mojo.exporter.ModelGeneratorMojo.execute(ModelGeneratorMojo.java:153) > at > org.apache.maven.plugin.DefaultPluginManager.executeMojo(DefaultPluginManager.java:443) > at > org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoals(DefaultLifecycleExecutor.java:539) > at > org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeStandaloneGoal(DefaultLifecycleExecutor.java:493) > at > org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoal(DefaultLifecycleExecutor.java:463) > at > org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoalAndHandleFailures(DefaultLifecycleExecutor.java:311) > at > org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeTaskSegments(DefaultLifecycleExecutor.java:278) > at > org.apache.maven.lifecycle.DefaultLifecycleExecutor.execute(DefaultLifecycleExecutor.java:143) > at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:334) > at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:125) > at org.apache.maven.cli.MavenCli.main(MavenCli.java:280) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:597) > at > org.codehaus.classworlds.Launcher.launchEnhanced(Launcher.java:315) > at org.codehaus.classworlds.Launcher.launch(Launcher.java:255) > at > org.codehaus.classworlds.Launcher.mainWithExitCode(Launcher.java:430) > at org.codehaus.classworlds.Launcher.main(Launcher.java:375) > Caused by: java.sql.SQLException: ORA-01000: maximum open cursors exceeded > > at > oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) > at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743) > at > oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216) > at > oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:799) > at > oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1037) > at > oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:839) > at > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1132) > at > oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316) > at > oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3361) > at > oracle.jdbc.driver.OracleDatabaseMetaData.getColumns(OracleDatabaseMetaData.java:262) > at > org.hibernate.cfg.reveng.dialect.JDBCMetaDataDialect.getColumns(JDBCMetaDataDialect.java:124) > ... 30 more > > > I also use the system role (and another role with only one table). Anybody > can fix it? > > Thanks, > VA > > -- > View this message in context: > http://www.nabble.com/Error-with-appfuse%3Agen-model-on-oracle-9-%28Appfuse-2.0-rc1-Struts-2-Basic%29-tf4421565s2369.html#a12611628 > Sent from the AppFuse - User mailing list archive at Nabble.com. > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > -- http://raibledesigns.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
