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]