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]
