[
http://jira.codehaus.org/browse/MOJO-645?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_122715
]
David Bernard commented on MOJO-645:
------------------------------------
This works for me with postgresql.
Only difference I see is
<sourceDataFormat>xml</sourceDataFormat>
<plugin>
<groupId>org.codehaus.mojo</groupId>
<artifactId>dbunit-maven-plugin</artifactId>
<version>1.0-beta-1</version>
<configuration>
<driver>${test.database.driver_class}</driver>
<username>${test.database.username}</username>
<password>${test.database.password}</password>
<url>jdbc:postgresql://${test.database.host}:${test.database.port_number}/${test.database.database_name}</url>
<sourceDataFormat>xml</sourceDataFormat>
</configuration>
<executions>
<execution>
<id>Load Users</id>
<phase>process-test-resources</phase>
<goals>
<goal>operation</goal>
</goals>
<configuration>
<type>CLEAN_INSERT</type>
<src>${project.build.testOutputDirectory}/sql/sample-data.xml</src>
</configuration>
</execution>
</executions>
<!-- required for postgresql -->
<dependencies>
<dependency>
<groupId>postgresql</groupId>
<artifactId>postgresql</artifactId>
<version>8.1-404.jdbc3</version>
</dependency>
</dependencies>
</plugin>
vi
> maven2-dbunit-plugin does not work
> ----------------------------------
>
> Key: MOJO-645
> URL: http://jira.codehaus.org/browse/MOJO-645
> Project: Mojo
> Issue Type: Bug
> Components: dbunit
> Environment: maven2, dbunit2.2, mysql, netbeans, ant
> Reporter: nilo de roock
> Priority: Critical
>
> In my environment this works fine in Ant.
> <target name="resetdata">
> <taskdef name="dbunit" classname="org.dbunit.ant.DbUnitTask"/>
> <dbunit driver="com.mysql.jdbc.Driver"
> url="jdbc:mysql://localhost/phonebook"
> userid="user"
> password="password">
> <classpath>
> <pathelement
> location="lib/mysql-connector-java-3.1.13-bin.jar"/>
> </classpath>
> <operation type="CLEAN_INSERT" src="insert.xml"/>
> </dbunit>
> </target>
> The following pom.xml works but does nothing in mysql ( first relevant
> snippet, complete pom after that ):
> SNIPPET>
> <plugin>
> <groupId>org.codehaus.mojo</groupId>
> <artifactId>dbunit-maven-plugin</artifactId>
> <!--jar file that has the jdbc driver -->
> <dependencies>
> <dependency>
> <groupId>mysql</groupId>
> <artifactId>mysql-connector-java</artifactId>
> <version>5.0.4</version>
> </dependency>
> </dependencies>
> <!-- common configurations -->
> <configuration>
> <driver>com.mysql.jdbc.Driver</driver>
> <url>jdbc:mysql://localhost/phonebook</url>
> <username>root</username>
> <password>root</password>
> </configuration>
> <executions>
> <execution>
> <phase>compile</phase>
> <goals>
> <goal>operation</goal>
> </goals>
> <!-- specific configurations -->
> <configuration>
> <type>CLEAN_INSERT</type>
> <src>insert.xml</src>
> <format>xml</format>
> </configuration>
> </execution>
> </executions>
> </plugin>
> </plugins>
> COMPLETE>
> <?xml version="1.0" encoding="UTF-8"?>
> <project xmlns="http://maven.apache.org/POM/4.0.0";
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
> xsi:schemaLocation="http://maven.apache.org/POM/4.0.0
> http://maven.apache.org/maven-v4_0_0.xsd";>
> <modelVersion>4.0.0</modelVersion>
> <groupId>wicket-stuff</groupId>
> <artifactId>wicket-phonebook</artifactId>
> <packaging>war</packaging>
> <version>1.2</version>
> <name>Wicket Phonebook Example</name>
> <description>Wicket Phonebook Example - Spring & [Hibernate|iBATIS]
> CrUD app</description>
> <url>http://wicket.sourceforge.net/</url>
> <inceptionYear>2005</inceptionYear>
>
> <repositories>
> <repository>
> <id>wicket-repo</id>
> <name>wicket-repo</name>
> <url>http://wicketframework.org/maven2</url>
> </repository>
> </repositories>
>
> <dependencies>
> <dependency>
> <groupId>org.apache.wicket</groupId>
> <artifactId>wicket</artifactId>
> <version>1.3-incubating-SNAPSHOT</version>
> <type>jar</type>
> <scope>compile</scope>
> </dependency>
> <dependency>
> <groupId>org.apache.wicket</groupId>
> <artifactId>wicket-extensions</artifactId>
> <version>1.3-incubating-SNAPSHOT</version>
> <type>jar</type>
> <scope>compile</scope>
> </dependency>
> <dependency>
> <groupId>org.apache.wicket</groupId>
> <artifactId>wicket-spring</artifactId>
> <version>1.3-incubating-SNAPSHOT</version>
> <type>jar</type>
> <scope>compile</scope>
> <exclusions>
> <exclusion>
> <groupId>cglib</groupId>
> <artifactId>cglib-nodep</artifactId>
> </exclusion>
> </exclusions>
> </dependency>
> <dependency>
> <groupId>org.apache.wicket</groupId>
> <artifactId>wicket-spring-annot</artifactId>
> <version>1.3-incubating-SNAPSHOT</version>
> <type>jar</type>
> <scope>compile</scope>
> </dependency>
> <dependency>
> <groupId>org.springframework</groupId>
> <artifactId>spring</artifactId>
> <version>2.0.1</version>
> </dependency>
> <dependency>
> <groupId>org.hibernate</groupId>
> <artifactId>hibernate</artifactId>
> <version>3.2.0.ga</version>
> <scope>compile</scope>
> </dependency>
> <dependency>
> <groupId>com.ibatis</groupId>
> <artifactId>ibatis2-sqlmap</artifactId>
> <version>2.1.7.597</version>
> </dependency>
> <dependency>
> <groupId>mysql</groupId>
> <artifactId>mysql-connector-java</artifactId>
> <version>5.0.4</version>
> </dependency>
> <dependency>
> <groupId>commons-dbcp</groupId>
> <artifactId>commons-dbcp</artifactId>
> <version>1.2.1</version>
> </dependency>
> <dependency>
> <groupId>org.mortbay.jetty</groupId>
> <artifactId>jetty</artifactId>
> <version>6.0.1</version>
> <scope>test</scope>
> </dependency>
> <dependency>
> <groupId>net.sf.shadesdb</groupId>
> <artifactId>shades</artifactId>
> <version>0.0.5</version>
> </dependency>
> <dependency>
> <groupId>org.mortbay.jetty</groupId>
> <artifactId>jetty</artifactId>
> <version>6.0.0beta17</version>
> <scope>compile</scope>
> </dependency>
>
> <dependency>
> <groupId>net.sourceforge.jwebunit</groupId>
> <artifactId>jwebunit-htmlunit-plugin</artifactId>
> <version>1.3</version>
> <scope>test</scope>
> </dependency>
> </dependencies>
>
> <build>
> <sourceDirectory>src/java</sourceDirectory>
> <testSourceDirectory>src/test</testSourceDirectory>
>
> <resources>
> <resource>
> <directory>src/conf</directory>
> <includes>
> <include>**/*</include>
> </includes>
> </resource>
> <resource>
> <directory>src/java</directory>
> <includes>
> <include>**/*</include>
> </includes>
> <!--
> Just for a demo project, don't exclude sources...
> <excludes>
> <exclude>**/*.java</exclude>
> </excludes>
> -->
> </resource>
> </resources>
> <plugins>
> <plugin>
> <groupId>org.apache.maven.plugins</groupId>
> <artifactId>maven-assembly-plugin</artifactId>
> <configuration>
> <descriptor>src/assembly/bin.xml</descriptor>
> <finalName>${artifactId}-${version}</finalName>
> <outputDirectory>target/distributions</outputDirectory>
> <workDirectory>target/assembly/work</workDirectory>
> </configuration>
> </plugin>
> <plugin>
> <groupId>org.apache.maven.plugins</groupId>
> <artifactId>maven-war-plugin</artifactId>
> <configuration>
> <warSourceDirectory>src/webapp</warSourceDirectory>
> </configuration>
> </plugin>
> <plugin>
> <groupId>org.apache.maven.plugins</groupId>
> <artifactId>maven-javadoc-plugin</artifactId>
> <configuration>
> <minmemory>128m</minmemory>
> <maxmemory>256m</maxmemory>
> </configuration>
> </plugin>
> <plugin>
> <groupId>org.apache.maven.plugins</groupId>
> <artifactId>maven-site-plugin</artifactId>
> <configuration>
>
> <templateDirectory>${basedir}/src/site/template/</templateDirectory>
> <template>wicket-site.vm</template>
> </configuration>
> </plugin>
> <plugin>
> <groupId>org.apache.maven.plugins</groupId>
> <artifactId>maven-surefire-plugin</artifactId>
> <configuration>
> <includes>
> <include>**/*Test.java</include>
> </includes>
> <testFailureIgnore>true</testFailureIgnore>
> </configuration>
> </plugin>
> <plugin>
> <groupId>org.codehaus.mojo</groupId>
> <artifactId>surefire-report-maven-plugin</artifactId>
> </plugin>
> <plugin>
> <groupId>org.mortbay.jetty</groupId>
> <artifactId>maven-jetty6-plugin</artifactId>
> <version>6.0.0beta16</version>
> <configuration>
> <webAppSourceDirectory>src/webapp</webAppSourceDirectory>
> </configuration>
> </plugin>
> <plugin>
> <groupId>org.codehaus.mojo</groupId>
> <artifactId>dbunit-maven-plugin</artifactId>
> <!--jar file that has the jdbc driver -->
> <dependencies>
> <dependency>
> <groupId>mysql</groupId>
> <artifactId>mysql-connector-java</artifactId>
> <version>5.0.4</version>
> </dependency>
> </dependencies>
> <!-- common configurations -->
> <configuration>
> <driver>com.mysql.jdbc.Driver</driver>
> <url>jdbc:mysql://localhost/phonebook</url>
> <username>root</username>
> <password>root</password>
> </configuration>
> <executions>
> <execution>
> <phase>compile</phase>
> <goals>
> <goal>operation</goal>
> </goals>
> <!-- specific configurations -->
> <configuration>
> <type>CLEAN_INSERT</type>
> <src>insert.xml</src>
> <format>xml</format>
> </configuration>
> </execution>
> </executions>
> </plugin>
> </plugins>
> </build>
>
> <reporting>
> <plugins>
> <plugin>
> <groupId>org.apache.maven.plugins</groupId>
> <artifactId>maven-compiler-plugin</artifactId>
> <configuration>
> <source>1.5</source>
> <target>1.5</target>
> </configuration>
> </plugin>
> <plugin>
> <groupId>org.apache.maven.plugins</groupId>
> <artifactId>maven-project-info-reports-plugin</artifactId>
> <reportSets>
> <reportSet>
> <reports>
> <report>dependencies</report>
> <report>project-team</report>
> <report>mailing-list</report>
> <report>issue-tracking</report>
> <report>license</report>
> <report>scm</report>
> </reports>
> </reportSet>
> </reportSets>
> </plugin>
> <plugin>
> <groupId>org.apache.maven.plugins</groupId>
> <artifactId>maven-javadoc-plugin</artifactId>
> </plugin>
> <plugin>
> <groupId>org.codehaus.mojo</groupId>
> <artifactId>surefire-report-maven-plugin</artifactId>
> </plugin>
> </plugins>
> </reporting>
>
> <distributionManagement>
> <site>
> <id>wicket-stuff-site</id>
>
> <url>scpexe://shell.sourceforge.net/home/groups/w/wi/wicket-stuff/htdocs/wicket-phonebook</url>
> </site>
> </distributionManagement>
> </project>
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe from this list, please visit:
http://xircles.codehaus.org/manage_email
