What is your JDBC URL for HSQLDB?
Matt
On Tue, Jul 1, 2008 at 3:48 AM, Martin Homik <[EMAIL PROTECTED]> wrote:
>
> I've followed a few threads on this topic, but none seems to provide a
> solution. I have a clean AppFuse 2.0.2 + Basic+ Struts2 project. When I run
> 'mvn -Phsqldb test', I get the following exception:
>
> [INFO] Configuration XML file loaded:
> file:/d:/ws/appfuse/comped/src/main/resources/hibernate.cfg.xml
> [INFO] Configuration Properties file loaded:
> d:\ws\appfuse\comped\target\classes\jdbc.properties
> alter table user_role drop constraint FK143BF46A4FD90D75;
> alter table user_role drop constraint FK143BF46AF503D155;
> drop table app_user if exists;
> drop table role if exists;
> drop table user_role if exists;
> create table app_user (id bigint generated by default as identity (start
> with 1), account_expired bit not null, account_locked bit not null, address
> varchar(150), city varchar(50) not null, country varchar(100), postal_code
> varchar(15) not null, province varchar(100), credentials_expired bit not
> null, email varchar(255) not null, account_enabled bit, first_name
> varchar(50) not null, last_name varchar(50) not null, password varchar(255)
> not null, password_hint varchar(255), phone_number varchar(255), username
> varchar(50) not null, version integer, website varchar(255), primary key
> (id), unique (username), unique (email));
> create table role (id bigint generated by default as identity (start with
> 1), description varchar(64), name varchar(20), primary key (id));
> create table user_role (user_id bigint not null, role_id bigint not null,
> primary key (user_id, role_id));
> alter table user_role add constraint FK143BF46A4FD90D75 foreign key
> (role_id) references role;
> alter table user_role add constraint FK143BF46AF503D155 foreign key
> (user_id) references app_user;
> [INFO] [compiler:testCompile]
> [INFO] Nothing to compile - all classes are up to date
> [INFO] [dbunit:operation {execution: test-compile}]
> [INFO]
> ------------------------------------------------------------------------
> [ERROR] BUILD ERROR
> [INFO]
> ------------------------------------------------------------------------
> [INFO] Error executing database operation: CLEAN_INSERT
>
> Embedded error: app_user
> [INFO]
> ------------------------------------------------------------------------
> [INFO] Trace
> org.apache.maven.lifecycle.LifecycleExecutionException: Error executing
> database operation: CLEAN_INSERT
> at
> org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoals(DefaultLifecycleExecutor.java:583)
> at
> org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoalWithLifecycle(DefaultLifecycleExecutor.java:499)
> at
> org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoal(DefaultLifecycleExecutor.java:478)
> at
> org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoalAndHandleFailures(DefaultLifecycleExecutor.java:330)
> at
> org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeTaskSegments(DefaultLifecycleExecutor.java:291)
> at
> org.apache.maven.lifecycle.DefaultLifecycleExecutor.execute(DefaultLifecycleExecutor.java:142)
> at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:336)
> at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:129)
> at org.apache.maven.cli.MavenCli.main(MavenCli.java:287)
> 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: org.apache.maven.plugin.MojoExecutionException: Error executing
> database operation: CLEAN_INSERT
> at
> org.codehaus.mojo.dbunit.OperationMojo.execute(OperationMojo.java:110)
> at
> org.apache.maven.plugin.DefaultPluginManager.executeMojo(DefaultPluginManager.java:451)
> at
> org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoals(DefaultLifecycleExecutor.java:558)
> ... 16 more
> Caused by: org.dbunit.dataset.NoSuchTableException: app_user
> at
> org.dbunit.database.DatabaseDataSet.getTableMetaData(DatabaseDataSet.java:192)
> at
> org.dbunit.operation.DeleteAllOperation.execute(DeleteAllOperation.java:98)
> at
> org.dbunit.operation.CompositeOperation.execute(CompositeOperation.java:67)
> at org.dbunit.ant.Operation.execute(Operation.java:183)
> at
> org.codehaus.mojo.dbunit.OperationMojo.execute(OperationMojo.java:101)
> ... 18 more
>
> I don't think the exception occurs due to referential integrity problems
> caused by the order of sample data. In fact, I have removed all tables but
> app_user and still the exception has been raised. There are no issues with
> MySQL.
>
> Any idea? Or reference?
> --
> View this message in context:
> http://www.nabble.com/CLEAN_INSERT-on-hsqldb-fails-tp18212746s2369p18212746.html
> Sent from the AppFuse - User mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
