Hi Matt,
I can't see file hibernate.reveng.xml in src/main/resources. Where is it?
If I create one in src/main/resources as you said. But when generate, Oracle
seems have a lot of users and generate all tables of all users. How can I
exclude them?
Still have error:
16:15:16,617 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
[INFO] -------------------------------
mraible wrote:
>
> 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]
>
>
>
--
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#a12793731
Sent from the AppFuse - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
