On 10/31/07, Bonami, Christian <[EMAIL PROTECTED]> wrote: > > 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?) >
It actually looks okay. The errors relate to the attempted dropping of tables and sequences. If you examine the database, do the tables exist? Mike > > Kr, > > 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: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]> 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 > > --------------------------------------------------------------------- > > [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 > > > > >
