@Matt: I haven't changed the JDBC URL for HSQLDB after project creation.
<jdbc.url><![CDATA[jdbc:hsqldb:${java.io.tmpdir}/comped;shutdown=true]]></jdbc.url>
But you have provided me with the right hint. It seems as if Windows (or my
cygwin/Poderosa) is unable to substitute ${java.io.tmpdir} correctly or it
might have a whitespace problem. When I replace it by 'tmp/comped' then
everything is fine and I don't mind to have a tmp folder in my project.
<jdbc.url><![CDATA[jdbc:hsqldb:tmp/comped;shutdown=true]]></jdbc.url>
Martin
mraible wrote:
>
> 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]
>
>
>
--
View this message in context:
http://www.nabble.com/CLEAN_INSERT-on-hsqldb-fails-tp18212746s2369p18333473.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]
