On 9/20/07, Nguyen Thi Van An <[EMAIL PROTECTED]> wrote: > > Hi Matt, > > I have seen this thread: > http://www.nabble.com/Is-hibernate.reveng.xml-ignored-by-AMP--How-to-control-reverse-eng--t4480248s2369.html > > And I config pom.xml as you said: > <plugin> > <groupId>org.codehaus.mojo</groupId> > <artifactId>appfuse-maven-plugin</artifactId> > <version>${appfuse.version}</version> > <configuration> > <componentProperties> > > <revengfile>src/test/resources/hibernate.reveng.xml</revengfile> > </componentProperties> > <genericCore>${amp.genericCore}</genericCore> > <fullSource>${amp.fullSource}</fullSource> > </configuration> > <!-- Dependency needed by appfuse:gen-model to connect to > database. --> > <!-- See http://issues.appfuse.org/browse/APF-868 to learn > more. --> > <dependencies> > <dependency> > <groupId>${jdbc.groupId}</groupId> > <artifactId>${jdbc.artifactId}</artifactId> > <version>${jdbc.version}</version> > </dependency> > </dependencies> > </plugin> > > But when generate, Oracle seems have a lot of users and generate all tables > of all users. How can I exclude them?
You can either exclude them in the hibernate.reveng.xml file or perhaps change the username/password so you're using a user that can only see tables in their schema. I know that other Oracle users are using this with success - maybe they can offer some advice? Matt > > I still have error: > 16:52:45,099 WARN org.hibernate.cfg.reveng.JDBCReader - Exception while > trying to get indexinfo on SYSTEM.DEF$_ORIGIN=Exception while getting index > info for SYSTEM.DEF$_ORIGIN > 16:52:45,139 WARN org.hibernate.cfg.reveng.JDBCReader - Exception while > trying to get indexinfo on SYSTEM.DEF$_PROPAGATOR=Exception while getting > index info for SYSTEM.DEF$_PROPAGATOR > [INFO] > ------------------------------------------------------------------------ > [ERROR] FATAL ERROR > [INFO] > ------------------------------------------------------------------------ > [INFO] Error while reading column meta data for > SYSTEM.DEF$_PUSHED_TRANSACTIONS > ORA-01000: maximum open cursors exceeded > > [INFO] > ------------------------------------------------------------------------ > [INFO] Trace > org.hibernate.exception.GenericJDBCException: Error while reading column > meta data for SYSTEM.DEF$_PUSHED_TRANSACTIONS > 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 > > Thanks, > VA > > > > > 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] > > -- http://raibledesigns.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
