org.apache.maven.lifecycle.LifecycleExecutionException: Error executing database operation: CLEAN_INSERT

AppFuse JIRA | ben Li | 9 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    when I run mvn -e test -Poracle against 2.0.1 or 2.0.2, it failed. the failed message as below: + Error stacktraces are turned on. [INFO] Scanning for projects... [INFO] ------------------------------------------------------------------------ [INFO] Building AppFuse Spring MVC Application [INFO] task-segment: [test] [INFO] ------------------------------------------------------------------------ [INFO] [warpath:add-classes {execution: default}] [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] [warpath:add-classes {execution: default}] [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: file:/C:/appfuse/test/myproject/src/main/resources/hibernate.cfg.xml [INFO] Configuration XML file loaded: file:/C:/appfuse/test/myproject/src/main/resources/hibernate.cfg.xml [INFO] Configuration Properties file loaded: C:\appfuse\test\myproject\target\classes\jdbc.properties [myproject] WARN [main] Oracle9Dialect.<init>(37) | The Oracle9Dialect dialect has been deprecated; use either Oracle9iDialect or Oracle10gDialect instead 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, account_expired number(1,0) not null, account_locked number(1,0) not null, address varchar2(150 char), city varchar2(50 char) not null, country varchar2(100 char), postal_code varchar2(15 char) not null, province varchar2(100 char), credentials_expired number(1,0) not null, email varchar2(255 char) not null unique, account_enabled number(1,0), first_name varchar2(50 char) not null, last_name varchar2(50 char) not null, password varchar2(255 char) not null, password_hint varchar2(255 char), phone_number varchar2(255 char), username varchar2(50 char) not null unique, version number(10,0), website varchar2(255 char), primary key (id)); create table role (id number(19,0) not null, description varchar2(64 char), name varchar2(20 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 FK143BF46A4FD90D75 foreign key (role_id) references role; alter table user_role add constraint FK143BF46AF503D155 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: 10 seconds [INFO] Finished at: Mon May 12 10:29:08 PDT 2008 [INFO] Final Memory: 19M/35M [INFO] ------------------------------------------------------------------------

    AppFuse JIRA | 9 years ago | ben Li
    org.apache.maven.lifecycle.LifecycleExecutionException: Error executing database operation: CLEAN_INSERT
  2. 0

    when I run mvn -e test -Poracle against 2.0.1 or 2.0.2, it failed. the failed message as below: + Error stacktraces are turned on. [INFO] Scanning for projects... [INFO] ------------------------------------------------------------------------ [INFO] Building AppFuse Spring MVC Application [INFO] task-segment: [test] [INFO] ------------------------------------------------------------------------ [INFO] [warpath:add-classes {execution: default}] [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] [warpath:add-classes {execution: default}] [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: file:/C:/appfuse/test/myproject/src/main/resources/hibernate.cfg.xml [INFO] Configuration XML file loaded: file:/C:/appfuse/test/myproject/src/main/resources/hibernate.cfg.xml [INFO] Configuration Properties file loaded: C:\appfuse\test\myproject\target\classes\jdbc.properties [myproject] WARN [main] Oracle9Dialect.<init>(37) | The Oracle9Dialect dialect has been deprecated; use either Oracle9iDialect or Oracle10gDialect instead 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, account_expired number(1,0) not null, account_locked number(1,0) not null, address varchar2(150 char), city varchar2(50 char) not null, country varchar2(100 char), postal_code varchar2(15 char) not null, province varchar2(100 char), credentials_expired number(1,0) not null, email varchar2(255 char) not null unique, account_enabled number(1,0), first_name varchar2(50 char) not null, last_name varchar2(50 char) not null, password varchar2(255 char) not null, password_hint varchar2(255 char), phone_number varchar2(255 char), username varchar2(50 char) not null unique, version number(10,0), website varchar2(255 char), primary key (id)); create table role (id number(19,0) not null, description varchar2(64 char), name varchar2(20 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 FK143BF46A4FD90D75 foreign key (role_id) references role; alter table user_role add constraint FK143BF46AF503D155 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: 10 seconds [INFO] Finished at: Mon May 12 10:29:08 PDT 2008 [INFO] Final Memory: 19M/35M [INFO] ------------------------------------------------------------------------

    AppFuse JIRA | 9 years ago | ben Li
    org.apache.maven.lifecycle.LifecycleExecutionException: Error executing database operation: CLEAN_INSERT

    Root Cause Analysis

    1. org.dbunit.dataset.NoSuchTableException

      user_role

      at org.dbunit.database.DatabaseDataSet.getTableMetaData()
    2. dbUnit Extension
      Operation.execute
      1. org.dbunit.database.DatabaseDataSet.getTableMetaData(DatabaseDataSet.java:192)
      2. org.dbunit.operation.DeleteAllOperation.execute(DeleteAllOperation.java:98)
      3. org.dbunit.operation.CompositeOperation.execute(CompositeOperation.java:67)
      4. org.dbunit.ant.Operation.execute(Operation.java:183)
      4 frames
    3. org.codehaus.mojo
      OperationMojo.execute
      1. org.codehaus.mojo.dbunit.OperationMojo.execute(OperationMojo.java:101)
      1 frame
    4. Maven Plugin
      DefaultPluginManager.executeMojo
      1. org.apache.maven.plugin.DefaultPluginManager.executeMojo(DefaultPluginManager.java:447)
      1 frame
    5. Maven Core
      DefaultMaven.execute
      1. org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoals(DefaultLifecycleExecutor.java:539)
      2. org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoalWithLifecycle(DefaultLifecycleExecutor.java:480)
      3. org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoal(DefaultLifecycleExecutor.java:459)
      4. org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoalAndHandleFailures(DefaultLifecycleExecutor.java:311)
      5. org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeTaskSegments(DefaultLifecycleExecutor.java:278)
      6. org.apache.maven.lifecycle.DefaultLifecycleExecutor.execute(DefaultLifecycleExecutor.java:143)
      7. org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:333)
      8. org.apache.maven.DefaultMaven.execute(DefaultMaven.java:126)
      8 frames
    6. M3 Interceptor
      MavenCli.main
      1. org.apache.maven.cli.MavenCli.main(MavenCli.java:282)
      1 frame
    7. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:597)
      4 frames
    8. Plexus
      Launcher.main
      1. org.codehaus.classworlds.Launcher.launchEnhanced(Launcher.java:315)
      2. org.codehaus.classworlds.Launcher.launch(Launcher.java:255)
      3. org.codehaus.classworlds.Launcher.mainWithExitCode(Launcher.java:430)
      4. org.codehaus.classworlds.Launcher.main(Launcher.java:375)
      4 frames