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]
