Aha, ok. So I ran
mvn install -P oracle in the core module. Then I get this: drop table app_user cascade constraints; drop table role cascade constraints; drop table user_role cascade constraints; drop sequence hibernate_sequence; create table app_user (id number(19,0) not null, username varchar2(50 char) not null unique, email varchar2(255 char) not null unique, password_hint varchar2(25 5 char), first_name varchar2(50 char) not null, last_name varchar2(50 char) not null, phone_number varchar2(255 char), website varchar2(255 char), account_expir ed number(1,0) not null, account_locked number(1,0) not null, credentials_expire d number(1,0) not null, city varchar2(50 char) not null, province varchar2(100 c har), postal_code varchar2(15 char) not null, address varchar2(150 char), countr y varchar2(100 char), account_enabled number(1,0), version number(10,0), passwor d varchar2(255 char) not null, primary key (id)); create table role (id number(19,0) not null, name varchar2(20 char), description varchar2(64 char), primary key (id)); create table user_role (user_id number(19,0) not null, role_id number(19,0) not null, primary key (user_id, role_id)); alter table user_role add constraint FK143BF46AF503D155 foreign key (user_id) re ferences app_user; alter table user_role add constraint FK143BF46A4FD90D75 foreign key (role_id) re ferences role; create sequence hibernate_sequence; [WARNING] 4 errors occurred while performing <hbm2ddl>. [ERROR] Error #1: java.sql.SQLException: ORA-00942: table or view does not exist [ERROR] Error #1: java.sql.SQLException: ORA-00942: table or view does not exist [ERROR] Error #1: java.sql.SQLException: ORA-00942: table or view does not exist [ERROR] Error #1: java.sql.SQLException: ORA-02289: sequence does not exist In other words, there's something wrong with the DDL... (or not?) Kr, Christian ________________________________ From: Michael Horwitz [mailto:[EMAIL PROTECTED] Sent: woensdag 31 oktober 2007 14:41 To: users@appfuse.dev.java.net Subject: Re: [appfuse-user] Tables not generated by dbunit-maven-plugin On 10/31/07, Bonami, Christian <[EMAIL PROTECTED]> wrote: I did. And it ran successfully? The tables are generated as part of the build on the core module - if user_role is not in the database you should see an error during the build of the core module. 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 14:34 To: users@appfuse.dev.java.net Subject: Re: [appfuse-user] Tables not generated by dbunit-maven-plugin You first need to run 'mvn install' either from the top level or from your ../core module. Mike. On 10/31/07, Bonami, Christian < [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > wrote: 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 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
