On 10/31/07, Bonami, Christian <[EMAIL PROTECTED]> wrote: > > Ok, I got it running… problem was in the oracle profile in the top > pom.xml: > > > > <dbunit.schema>VDS</dbunit.schema> <!-- Make sure to > capitalize the schema name --> > > > > 'VDS' is the right scheme, not the default 'SYSTEM'. > > > > MANY THANKS !!!! >
Absolute pleasure. Glad it all works :-) Mike. > > > Mazda Motor Logistics Europe NV, Blaasveldstraat 162, B-2830 Willebroek > VAT BE 406.024.281, RPR Mechelen, ING 310-0092504-52, IBAN : BE64 3100 > 0925 0452, SWIFT : BBRUBEBB > ------------------------------ > > *From:* Michael Horwitz [mailto:[EMAIL PROTECTED] > *Sent:* woensdag 31 oktober 2007 15:14 > *To:* users@appfuse.dev.java.net > *Subject:* Re: [appfuse-user] Tables not generated by dbunit-maven-plugin > -- part 2 > > > > > > On 10/31/07, *Bonami, Christian* <[EMAIL PROTECTED]> wrote: > > Aha, ok, I see. But how come that tables are *not* automatically generated > by the hibernate3-maven-plugin before the dbunit-maven-plugin starts its > CLEAN_INSERT? > > > > They should be. However the hibernate3-maven-plugin only runs as part of > the build on the core module, so they will only exist if the build completed > successfully. Have you checked the contents of the database manually to see > if any tables were created? Also how have you configured your databse > connection in AppFuse? > > > > Mike. > > > > > > Thx > > Christian > > > > > > Mazda Motor Logistics Europe NV, Blaasveldstraat 162, B-2830 Willebroek > VAT BE 406.024.281, RPR Mechelen, ING 310-0092504-52, IBAN : BE64 3100 > 0925 0452, SWIFT : BBRUBEBB > ------------------------------ > > *From:* Michael Horwitz [mailto: [EMAIL PROTECTED] > *Sent:* woensdag 31 oktober 2007 14:56 > > > *To:* users@appfuse.dev.java.net > *Subject:* Re: [appfuse-user] Tables not generated by dbunit-maven-plugin > -- part 2 > > > > They are included via the dependency on appfuse-data-common (which is a > transitive dependency through appfuse-hibernate). > > > > Mike > > > > On 10/31/07, *Bonami, Christian* < [EMAIL PROTECTED]> wrote: > > But, where are those annotated Java classes in the JSF modular archetype? > I see only 1 class: Core.java. > > Where are the annotated model classes? > > > > > > Mazda Motor Logistics Europe NV, Blaasveldstraat 162, B-2830 Willebroek > VAT BE 406.024.281, RPR Mechelen, ING 310-0092504-52, IBAN : BE64 3100 > 0925 0452, SWIFT : BBRUBEBB > ------------------------------ > > *From:* Michael Horwitz [mailto: [EMAIL PROTECTED] > *Sent:* woensdag 31 oktober 2007 14:37 > *To:* users@appfuse.dev.java.net > *Subject:* Re: [appfuse-user] Tables not generated by dbunit-maven-plugin > -- part 2 > > > > AppFuse 2.0 uses Hibernate Annotations - no more .hbm.xml files. > > > > Mike > > > On 10/31/07, *Bonami, Christian* < [EMAIL PROTECTED]> wrote: > > Ok, by now I've discovered that it is not dbunit but the > hibernate3-maven-plugin that generates the tables (hbm2ddl). > > But where is the *.hbm file?? It is not included in the appFuse archetype > that I downloaded (JSF modular). > > > > Plz help > > > > > > Mazda Motor Logistics Europe NV, Blaasveldstraat 162, B-2830 Willebroek > VAT BE 406.024.281, RPR Mechelen, ING 310-0092504-52, IBAN : BE64 3100 > 0925 0452, SWIFT : BBRUBEBB > ------------------------------ > > *From:* Bonami, Christian [mailto: [EMAIL PROTECTED] > *Sent:* woensdag 31 oktober 2007 14:04 > *To:* users@appfuse.dev.java.net > *Cc:* Mariën, Sven; Houckx, Marc > *Subject:* [appfuse-user] Tables not generated by dbunit-maven-plugin > > > > Hi, > > > > I'm using oracle XE as underlying DB in appFuse 2 standard distribution. > > So, on the commandline in .../web I run: > > > > mvn jetty-run:war -P oracle > > > > Apparently dbunit-maven-plugin connects well to the database, but then > starts complaining about a table (user_role) that is not found: > > > > [INFO] [dbunit:operation] > > [INFO] > > Mazda Motor Logistics Europe NV, Blaasveldstraat 162, B-2830 Willebroek > VAT BE 406.024.281, RPR Mechelen, ING 310-0092504-52, IBAN : BE64 3100 > 0925 0452, SWIFT : BBRUBEBB > > --------------------------------------------------------------------- > > [ERROR] BUILD ERROR > > [INFO] > --------------------------------------------------------------------- > > [INFO] Error executing database operation: CLEAN_INSERT > > > > Embedded error: user_role > > [INFO] ------------------------------------------------------------- > > ... > > Caused by: org.apache.maven.plugin.MojoExecutionException: Error executing > datab > > ase operation: CLEAN_INSERT > > at org.codehaus.mojo.dbunit.OperationMojo.execute( > OperationMojo.java:110 > > ) > > at org.apache.maven.plugin.DefaultPluginManager.executeMojo > (DefaultPlugi > > nManager.java:443) > > at > org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoals(Defa > > ultLifecycleExecutor.java:539) > > 20 more > > *Caused by: org.dbunit.dataset.NoSuchTableException: user_role* > > ... > > [INFO] > --------------------------------------------------------------------- > > [INFO] For more information, run Maven with the -e switch > > [INFO] > --------------------------------------------------------------------- > > [INFO] Total time: 3 seconds > > [INFO] Finished at: Wed Oct 31 13:44:19 CET 2007 > > [INFO] Final Memory: 7M/14M > > [INFO] > -------------------------------------------------------------------- > > > > Why aren't the tables generated automatically? > > Do I have to create them manually? > > What am I missing here? > > > > Kind regards > > Christian Bonami > > > > > > >
