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

AppFuse JIRA | ben Li | 9 years ago
  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
  3. 0

    The test cases based on `dbunit` work well in my laptop, but failed in travis-ci

    Stack Overflow | 1 month ago | Angle Tom
    org.dbunit.dataset.NoSuchTableException: Did not find table 'User' in schema 'null'
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    GitHub comment 126#255330945

    GitHub | 1 month ago | xiaoshao
    org.dbunit.dataset.NoSuchTableException: Did not find table 'User' in schema 'null'
  6. 0

    MySQL case sensitive problem in dataset creation

    dbunit | 8 years ago | dacota
    org.dbunit.dataset.NoSuchTableException: Did not find table 'BESTELLUNG\_LIEFERUNG' in schema 'hskajboss'

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    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