Thanks for the reply.
here is the stacktrace:
+ Error stacktraces are turned on.
[INFO] Scanning for projects...
[INFO]
------------------------------------------------------------------------
[INFO] Building Tantalus BidGen Application
[INFO] task-segment: [test]
[INFO]
------------------------------------------------------------------------
[INFO] [aspectj:compile {execution: default}]
[INFO] [native2ascii:native2ascii {execution: native2ascii-utf8}]
[INFO] [native2ascii:native2ascii {execution: native2ascii-8859_1}]
[INFO] [resources:resources]
[INFO] Using default encoding to copy filtered resources.
[INFO] [compiler:compile]
[INFO] Nothing to compile - all classes are up to date
[INFO] [resources:testResources]
[INFO] Using default encoding to copy filtered resources.
[INFO] Preparing hibernate3:hbm2ddl
[WARNING] Removing: hbm2ddl from forked lifecycle, to prevent recursive
invocation.
[INFO] [aspectj:compile {execution: default}]
[INFO] [native2ascii:native2ascii {execution: native2ascii-utf8}]
[INFO] [native2ascii:native2ascii {execution: native2ascii-8859_1}]
[INFO] [resources:resources]
[INFO] Using default encoding to copy filtered resources.
[WARNING] POM for 'org.hibernate:jtidy:pom:r8-20060801:runtime' is invalid.
It will be ignored for artifact resolution. Reason: Parse error reading POM.
Reason: TEXT must be immediately followed by END_TAG and not START_TAG
(position: START_TAG seen ...<licenses>\n\t\t\t<license>... @12:13) for
project org.hibernate:jtidy at
c:\mavenrepo\org\hibernate\jtidy\r8-20060801\jtidy-r8-20060801.pom
[WARNING] POM for 'org.hibernate:jtidy:pom:r8-20060801:runtime' is invalid.
It will be ignored for artifact resolution. Reason: Parse error reading POM.
Reason: TEXT must be immediately followed by END_TAG and not START_TAG
(position: START_TAG seen ...<licenses>\n\t\t\t<license>... @12:13) for
project org.hibernate:jtidy at
c:\mavenrepo\org\hibernate\jtidy\r8-20060801\jtidy-r8-20060801.pom
[INFO] [hibernate3:hbm2ddl {execution: default}]
[INFO] Configuration XML file loaded:
C:\appfuse\bidgen\src\main\resources\hibernate.cfg.xml
[INFO] Configuration XML file loaded:
C:\appfuse\bidgen\src\main\resources\hibernate.cfg.xml
[INFO] Configuration Properties file loaded:
C:\appfuse\bidgen\target\classes\jdbc.properties
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(255 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_expired number(1,0) not null, account_locked
number(1,0) not null, credentials_expired number(1,0) not null, city
varchar2(50 char) not null, province varchar2(100 char), postal_code
varchar2(15 char) not null, address varchar2(150 char), country varchar2(100
char), account_enabled number(1,0), version number(10,0), password
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 FK143BF46A8B467AF1 foreign key
(role_id) references role;
alter table user_role add constraint FK143BF46A30713ED1 foreign key
(user_id) references app_user;
create sequence hibernate_sequence;
[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: user_role
[INFO]
------------------------------------------------------------------------
[INFO] Trace
org.apache.maven.lifecycle.LifecycleExecutionException: Error executing
database operation: CLEAN_INSERT
at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoals(DefaultLifecycleExecutor.java:564)
at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoalWithLifecycle(DefaultLifecycleExecutor.java:480)
at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoal(DefaultLifecycleExecutor.java:459)
at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoalAndHandleFailures(DefaultLifecycleExecutor.java:311)
at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeTaskSegments(DefaultLifecycleExecutor.java:278)
at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.execute(DefaultLifecycleExecutor.java:143)
at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:333)
at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:126)
at org.apache.maven.cli.MavenCli.main(MavenCli.java:282)
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:447)
at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoals(DefaultLifecycleExecutor.java:539)
... 16 more
Caused by: org.dbunit.dataset.NoSuchTableException: user_role
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
[INFO]
------------------------------------------------------------------------
[INFO] Total time: 14 seconds
[INFO] Finished at: Mon May 12 10:05:50 PDT 2008
[INFO] Final Memory: 14M/32M
[INFO]
------------------------------------------------------------------------
thanks.
dusty wrote:
>
> Can you run that again with mvn -e test -Poracle?
>
> You connected to oracle using the profile, correct? We need to see
> the actual stacktrace for the Oracle error.
>
> -D
>
> On May 9, 2008, at 4:53 PM, MHL wrote:
>
>>
>> Hi all.
>>
>> When I switch the database from Mysql to Oracle. it gives me errors as
>> below.
>>
>> I have been scatched my head for few hours and I still can't come up a
>> solution.
>>
>> Can someone please help me out?
>>
>>
>> thanks.
>>
>> the error messages as below:
>>
>> [INFO] Scanning for projects...
>> [INFO]
>> ------------------------------------------------------------------------
>> [INFO] Building Tantalus BidGen Application
>> [INFO] task-segment: [test]
>> [INFO]
>> ------------------------------------------------------------------------
>> [INFO] [aspectj:compile {execution: default}]
>> [INFO] [native2ascii:native2ascii {execution: native2ascii-utf8}]
>> [INFO] [native2ascii:native2ascii {execution: native2ascii-8859_1}]
>> [INFO] [resources:resources]
>> [INFO] Using default encoding to copy filtered resources.
>> [INFO] [compiler:compile]
>> [INFO] Nothing to compile - all classes are up to date
>> [INFO] [resources:testResources]
>> [INFO] Using default encoding to copy filtered resources.
>> [INFO] Preparing hibernate3:hbm2ddl
>> [WARNING] Removing: hbm2ddl from forked lifecycle, to prevent
>> recursive
>> invocation.
>> [INFO] [aspectj:compile {execution: default}]
>> [INFO] [native2ascii:native2ascii {execution: native2ascii-utf8}]
>> [INFO] [native2ascii:native2ascii {execution: native2ascii-8859_1}]
>> [INFO] [resources:resources]
>> [INFO] Using default encoding to copy filtered resources.
>> [WARNING] POM for 'org.hibernate:jtidy:pom:r8-20060801:runtime' is
>> invalid.
>> It will be ignored for artifact resolution. Reason: Parse error
>> reading POM.
>> Reason: TEXT must be immediately followed by END_TAG and not START_TAG
>> (position: START_TAG seen ...<licenses>\n\t\t\t<license>... @12:13)
>> for
>> project org.hibernate:jtidy at
>> c:\mavenrepo\org\hibernate\jtidy\r8-20060801\jtidy-r8-20060801.pom
>> [WARNING] POM for 'org.hibernate:jtidy:pom:r8-20060801:runtime' is
>> invalid.
>> It will be ignored for artifact resolution. Reason: Parse error
>> reading POM.
>> Reason: TEXT must be immediately followed by END_TAG and not START_TAG
>> (position: START_TAG seen ...<licenses>\n\t\t\t<license>... @12:13)
>> for
>> project org.hibernate:jtidy at
>> c:\mavenrepo\org\hibernate\jtidy\r8-20060801\jtidy-r8-20060801.pom
>> [INFO] [hibernate3:hbm2ddl {execution: default}]
>> [INFO] Configuration XML file loaded:
>> C:\appfuse\bidgen\src\main\resources\hibernate.cfg.xml
>> [INFO] Configuration XML file loaded:
>> C:\appfuse\bidgen\src\main\resources\hibernate.cfg.xml
>> [INFO] Configuration Properties file loaded:
>> C:\appfuse\bidgen\target\classes\jdbc.properties
>> 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(255 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_expired number(1,0) not null,
>> account_locked
>> number(1,0) not null, credentials_expired number(1,0) not null, city
>> varchar2(50 char) not null, province varchar2(100 char), postal_code
>> varchar2(15 char) not null, address varchar2(150 char), country
>> varchar2(100
>> char), account_enabled number(1,0), version number(10,0), password
>> 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 FK143BF46A8B467AF1 foreign key
>> (role_id) references role;
>> alter table user_role add constraint FK143BF46A30713ED1 foreign key
>> (user_id) references app_user;
>> create sequence hibernate_sequence;
>> [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: user_role
>> [INFO]
>> ------------------------------------------------------------------------
>> [INFO] For more information, run Maven with the -e switch
>> [INFO]
>> ------------------------------------------------------------------------
>> [INFO] Total time: 9 seconds
>> [INFO] Finished at: Fri May 09 16:47:27 PDT 2008
>>
>>
>> --
>> View this message in context:
>> http://www.nabble.com/Appfuse-2.0.1-and-Oracle.-tp17158334s2369p17158334.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/Appfuse-2.0.1-and-Oracle.-tp17158334s2369p17189876.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]
