Hi,
We have exactly the samw problem with HSQLDB. Any ideas?
--Irshad.
MHL wrote:
>
> 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.-tp17158334s2369p17190011.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]
