You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@maven.apache.org by Mick Knutson <mk...@baselogic.com> on 2009/02/06 19:05:18 UTC
help with the dbunit-maven-plugin
*I have this plugin declaration:*
*<plugin>
<groupId>org.codehaus.mojo</groupId>
<artifactId>dbunit-maven-plugin</artifactId>
<version>1.0-beta-1</version>
<configuration>
<driver>${jdbc.driverClassName}</driver>
<username>${jdbc.username}</username>
<password>${jdbc.password}</password>
<url>${jdbc.url}</url>
<src>src/test/resources/default-data.xml</src>
<type>${dbunit.operation.type}</type>
</configuration>
<executions>
<execution>
<phase>test-compile</phase>
<goals>
<goal>operation</goal>
</goals>
<!-- specific configurations -->
<configuration>
<type>${dbunit.operation.type}</type>
<src>src/test/resources/default-data.xml</src>
</configuration>
</execution>
</executions>
<dependencies>
<dependency>
<groupId>${jdbc.groupId}</groupId>
<artifactId>${jdbc.artifactId}</artifactId>
<version>${jdbc.version}</version>
</dependency>
</dependencies>
</plugin>*
*Then I have this as the default-data.xml:*
*<!DOCTYPE dataset SYSTEM "dataset.dtd">
<dataset>
<table name="TEST_TABLE">
<column>COL0</column>
<column>COL1</column>
<column>COL2</column>
<row>
<value>row 0 col 0</value>
<value>row 0 col 1</value>
<value>row 0 col 2</value>
</row>
<row>
<null/>
<value>row 1 col 1</value>
<null/>
</row>
</table>
<table name="SECOND_TABLE">
<column>COLUMN0</column>
<column>COLUMN1</column>
<row>
<value>row 0 col 0</value>
<value>row 0 col 1</value>
</row>
</table>
<table name='EMPTY_TABLE'>
<column>COLUMN0</column>
<column>COLUMN1</column>
</table>
</dataset>
*
*and I keep getting this error (Caused by:
org.dbunit.dataset.NoSuchTableException: EMPTY_TABLE):*
*733639@D5400LPL: /opt/projects/baselogic/services/data-services $ mvn
dbunit:operation -e
+ Error stacktraces are turned on.
[INFO] Scanning for projects...
[INFO] Searching repository for plugin with prefix: 'dbunit'.
[INFO]
------------------------------------------------------------------------
[INFO] Building Data-Services JPA Impl
[INFO] task-segment: [dbunit:operation]
[INFO]
------------------------------------------------------------------------
[INFO] [dbunit:operation]
[INFO]
------------------------------------------------------------------------
[ERROR] BUILD ERROR
[INFO]
------------------------------------------------------------------------
[INFO] Error executing database operation: CLEAN_INSERT
Embedded error: EMPTY_TABLE
[INFO]
------------------------------------------------------------------------
[INFO] Trace
org.apache.maven.lifecycle.LifecycleExecutionException: Error executing
database operation: CLEAN_INSERT
at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoals(DefaultLifecycleExecutor.java:583)
at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeStandaloneGoal(DefaultLifecycleExecutor.java:512)
at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoal(DefaultLifecycleExecutor.java:482)
at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoalAndHandleFailures(DefaultLifecycleExecutor.java:330)
at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeTaskSegments(DefaultLifecycleExecutor.java:291)
at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.execute(DefaultLifecycleExecutor.java:142)
at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:336)
at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:129)
at org.apache.maven.cli.MavenCli.main(MavenCli.java:287)
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:451)
at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoals(DefaultLifecycleExecutor.java:558)
... 16 more
Caused by: org.dbunit.dataset.NoSuchTableException: EMPTY_TABLE
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: 4 seconds
[INFO] Finished at: Fri Feb 06 12:54:55 EST 2009
[INFO] Final Memory: 8M/15M
[INFO]
------------------------------------------------------------------------
733639@D5400LPL: /opt/projects/baselogic/services/data-services $
*
I have validated that the rootBAD user can't connect, then root can connect.
It just seems to be an issue with the data file.
Any help is appreciated.
---
Thank You…
Mick Knutson, President
BASE Logic, Inc.
Enterprise Architecture, Design, Mentoring & Agile Consulting
p. (866) BLiNC-411: (254-6241-1)
f. (415) 685-4233
Website: http://baselogic.com
Linked IN: http://linkedin.com/in/mickknutson
Twitter: http://twitter.com/mickknutson
Vacation Rental: http://tahoe.baselogic.com
---
Re: help with the dbunit-maven-plugin
Posted by Dan Tran <da...@gmail.com>.
you may want ping dbunit group, they know this plugin well and have
some talk to move this plugin to their own site.
-D
On Fri, Feb 6, 2009 at 10:05 AM, Mick Knutson <mk...@baselogic.com> wrote:
> *I have this plugin declaration:*
> *<plugin>
> <groupId>org.codehaus.mojo</groupId>
> <artifactId>dbunit-maven-plugin</artifactId>
> <version>1.0-beta-1</version>
> <configuration>
> <driver>${jdbc.driverClassName}</driver>
> <username>${jdbc.username}</username>
> <password>${jdbc.password}</password>
> <url>${jdbc.url}</url>
> <src>src/test/resources/default-data.xml</src>
> <type>${dbunit.operation.type}</type>
>
> </configuration>
> <executions>
> <execution>
> <phase>test-compile</phase>
> <goals>
> <goal>operation</goal>
> </goals>
> <!-- specific configurations -->
> <configuration>
> <type>${dbunit.operation.type}</type>
> <src>src/test/resources/default-data.xml</src>
> </configuration>
> </execution>
> </executions>
> <dependencies>
> <dependency>
> <groupId>${jdbc.groupId}</groupId>
> <artifactId>${jdbc.artifactId}</artifactId>
> <version>${jdbc.version}</version>
> </dependency>
> </dependencies>
> </plugin>*
>
> *Then I have this as the default-data.xml:*
>
> *<!DOCTYPE dataset SYSTEM "dataset.dtd">
> <dataset>
> <table name="TEST_TABLE">
> <column>COL0</column>
> <column>COL1</column>
> <column>COL2</column>
> <row>
> <value>row 0 col 0</value>
> <value>row 0 col 1</value>
> <value>row 0 col 2</value>
> </row>
> <row>
> <null/>
> <value>row 1 col 1</value>
> <null/>
> </row>
> </table>
> <table name="SECOND_TABLE">
> <column>COLUMN0</column>
> <column>COLUMN1</column>
> <row>
> <value>row 0 col 0</value>
> <value>row 0 col 1</value>
> </row>
> </table>
> <table name='EMPTY_TABLE'>
> <column>COLUMN0</column>
> <column>COLUMN1</column>
> </table>
> </dataset>
> *
>
> *and I keep getting this error (Caused by:
> org.dbunit.dataset.NoSuchTableException: EMPTY_TABLE):*
>
> *733639@D5400LPL: /opt/projects/baselogic/services/data-services $ mvn
> dbunit:operation -e
> + Error stacktraces are turned on.
> [INFO] Scanning for projects...
> [INFO] Searching repository for plugin with prefix: 'dbunit'.
> [INFO]
> ------------------------------------------------------------------------
> [INFO] Building Data-Services JPA Impl
> [INFO] task-segment: [dbunit:operation]
> [INFO]
> ------------------------------------------------------------------------
> [INFO] [dbunit:operation]
> [INFO]
> ------------------------------------------------------------------------
> [ERROR] BUILD ERROR
> [INFO]
> ------------------------------------------------------------------------
> [INFO] Error executing database operation: CLEAN_INSERT
>
> Embedded error: EMPTY_TABLE
> [INFO]
> ------------------------------------------------------------------------
> [INFO] Trace
> org.apache.maven.lifecycle.LifecycleExecutionException: Error executing
> database operation: CLEAN_INSERT
> at
> org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoals(DefaultLifecycleExecutor.java:583)
> at
> org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeStandaloneGoal(DefaultLifecycleExecutor.java:512)
> at
> org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoal(DefaultLifecycleExecutor.java:482)
> at
> org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoalAndHandleFailures(DefaultLifecycleExecutor.java:330)
> at
> org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeTaskSegments(DefaultLifecycleExecutor.java:291)
> at
> org.apache.maven.lifecycle.DefaultLifecycleExecutor.execute(DefaultLifecycleExecutor.java:142)
> at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:336)
> at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:129)
> at org.apache.maven.cli.MavenCli.main(MavenCli.java:287)
> 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:451)
> at
> org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoals(DefaultLifecycleExecutor.java:558)
> ... 16 more
> Caused by: org.dbunit.dataset.NoSuchTableException: EMPTY_TABLE
> 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: 4 seconds
> [INFO] Finished at: Fri Feb 06 12:54:55 EST 2009
> [INFO] Final Memory: 8M/15M
> [INFO]
> ------------------------------------------------------------------------
>
> 733639@D5400LPL: /opt/projects/baselogic/services/data-services $
> *
>
>
> I have validated that the rootBAD user can't connect, then root can connect.
> It just seems to be an issue with the data file.
> Any help is appreciated.
>
> ---
> Thank You…
>
> Mick Knutson, President
>
> BASE Logic, Inc.
> Enterprise Architecture, Design, Mentoring & Agile Consulting
> p. (866) BLiNC-411: (254-6241-1)
> f. (415) 685-4233
>
> Website: http://baselogic.com
> Linked IN: http://linkedin.com/in/mickknutson
> Twitter: http://twitter.com/mickknutson
> Vacation Rental: http://tahoe.baselogic.com
> ---
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@maven.apache.org
For additional commands, e-mail: users-help@maven.apache.org