fitnesse-launcher-sql-example
Used in:
components
- OverviewOverview
- VersionsVersions
- DependentsDependents
- DependenciesDependencies
<dependency>
<groupId>com.processpuzzle.fitnesse</groupId>
<artifactId>fitnesse-launcher-sql-example</artifactId>
<version>1.6.5</version>
</dependency><?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/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<parent>
<groupId>com.processpuzzle.fitnesse</groupId>
<artifactId>fitnesse-launcher-parent</artifactId>
<version>1.6.5</version>
</parent>
<artifactId>fitnesse-launcher-sql-example</artifactId>
<packaging>jar</packaging>
<name>Example SQL Project</name>
<description>Example configuration for using fitnesse-launcher-maven-plugin in an SQL project.</description>
<url>http://code.google.com/p/fitnesse-launcher-maven-plugin/wiki/SqlExample</url>
<properties>
<!-- This example has no unit tests, just integration tests -->
<skipTests>true</skipTests>
<!-- This are properties we may need within our FitNesse tests -->
<hsqldb.driver>org.hsqldb.jdbc.JDBCDriver</hsqldb.driver>
<hsqldb.url>jdbc:hsqldb:file:${project.build.directory}/hsqldb;shutdown=true</hsqldb.url>
<hsqldb.username>sa</hsqldb.username>
<hsqldb.password>sa</hsqldb.password>
<hsqldb.version>2.2.9</hsqldb.version>
<derby.driver>org.apache.derby.jdbc.ClientDriver</derby.driver>
<derby.url>jdbc:derby://localhost:1527/${project.build.directory}/derbyDB;create=true</derby.url>
<derby.username>derbyuser</derby.username>
<derby.password>derbyuser</derby.password>
<derby.version>10.4.1.3</derby.version>
<spring.version>3.2.0.RELEASE</spring.version>
</properties>
<dependencies>
<dependency>
<groupId>org.apache.derby</groupId>
<artifactId>derby</artifactId>
<version>${derby.version}</version>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>org.apache.derby</groupId>
<artifactId>derbynet</artifactId>
<version>${derby.version}</version>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>${spring.version}</version>
<scope>test</scope>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-antrun-plugin</artifactId>
<executions>
<execution>
<id>start-derby-network-server</id>
<phase>pre-integration-test</phase>
<goals>
<goal>run</goal>
</goals>
<configuration>
<target>
<java fork="true" spawn="true" classpathref="maven.runtime.classpath" classname="org.apache.derby.drda.NetworkServerControl">
<arg value="start" />
<arg value="-noSecurityManager" />
</java>
<sleep milliseconds="1000" />
</target>
</configuration>
</execution>
</executions>
</plugin>
<plugin>
<groupId>org.codehaus.mojo</groupId>
<artifactId>exec-maven-plugin</artifactId>
<version>1.2.1</version>
<executions>
<execution>
<id>shutdown-derby-network-server</id>
<phase>post-integration-test</phase>
<goals>
<goal>exec</goal>
</goals>
<configuration>
<executable>java</executable>
<arguments>
<argument>-classpath</argument>
<classpath />
<argument>org.apache.derby.drda.NetworkServerControl</argument>
<argument>shutdown</argument>
</arguments>
</configuration>
</execution>
</executions>
</plugin>
<plugin>
<groupId>org.codehaus.mojo</groupId>
<artifactId>sql-maven-plugin</artifactId>
<version>1.5</version>
<dependencies>
<dependency>
<groupId>org.hsqldb</groupId>
<artifactId>hsqldb</artifactId>
<version>${hsqldb.version}</version>
</dependency>
<dependency>
<groupId>org.apache.derby</groupId>
<artifactId>derbyclient</artifactId>
<version>${derby.version}</version>
</dependency>
</dependencies>
<executions>
<execution>
<id>derby</id>
<phase>pre-integration-test</phase>
<goals>
<goal>execute</goal>
</goals>
<configuration>
<driver>${derby.driver}</driver>
<url>${derby.url}</url>
<username>${derby.username}</username>
<password>${derby.password}</password>
<srcFiles>
<srcFile>src/main/sql/001_init.sql</srcFile>
</srcFiles>
</configuration>
</execution>
<execution>
<id>hsqldb</id>
<phase>pre-integration-test</phase>
<goals>
<goal>execute</goal>
</goals>
<configuration>
<driver>${hsqldb.driver}</driver>
<url>${hsqldb.url}</url>
<username>${hsqldb.username}</username>
<password>${hsqldb.password}</password>
<srcFiles>
<srcFile>src/main/sql/001_init.sql</srcFile>
</srcFiles>
</configuration>
</execution>
</executions>
</plugin>
<plugin>
<groupId>com.processpuzzle.fitnesse</groupId>
<artifactId>fitnesse-launcher-maven-plugin</artifactId>
<configuration>
<suite>SqlExample</suite>
<!-- Since version 1.3.0 -->
<useProjectDependencies>
<scope>test</scope>
</useProjectDependencies>
</configuration>
<dependencies>
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-simple</artifactId>
<version>1.7.2</version>
</dependency>
<dependency>
<groupId>org.hsqldb</groupId>
<artifactId>hsqldb</artifactId>
<version>${hsqldb.version}</version>
</dependency>
<dependency>
<groupId>org.apache.derby</groupId>
<artifactId>derbyclient</artifactId>
<version>${derby.version}</version>
</dependency>
<dependency>
<groupId>net.sf.dbfit</groupId>
<artifactId>dbfit</artifactId>
<version>1.1.2.2</version>
</dependency>
</dependencies>
</plugin>
</plugins>
</build>
<reporting>
<plugins>
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-project-info-reports-plugin</artifactId>
<version>2.7</version>
<reportSets>
<reportSet>
<reports>
<report>summary</report>
</reports>
</reportSet>
</reportSets>
</plugin>
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-jxr-plugin</artifactId>
<version>2.3</version>
<configuration>
<linkJavadoc>true</linkJavadoc>
</configuration>
</plugin>
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-javadoc-plugin</artifactId>
<version>2.9</version>
<configuration>
<quiet>true</quiet>
<use>false</use>
<show>package</show>
<stylesheetfile>${project.parent.basedir}/src/site/javadoc/stylesheet.css</stylesheetfile>
<includeDependencySources>false</includeDependencySources>
<name>Example SQL Project JavaDocs</name>
<description>JavaDoc API documentation for FitNesse Launcher Example SQL Project</description>
<links>
<link>http://java.sun.com/javase/6/docs/api/</link>
</links>
</configuration>
</plugin>
<plugin>
<groupId>com.processpuzzle.fitnesse</groupId>
<artifactId>fitnesse-launcher-maven-plugin</artifactId>
<version>${project.version}</version>
</plugin>
</plugins>
</reporting>
<profiles>
<profile>
<id>wiki</id>
<!--
This profile is for use when writing tests using the FitNesse wiki.
Simply run 'mvn verify -P wiki' and use a browser to visit http://localhost:9123/SqlExample
-->
<build>
<plugins>
<plugin>
<groupId>com.processpuzzle.fitnesse</groupId>
<artifactId>fitnesse-launcher-maven-plugin</artifactId>
<executions>
<execution>
<goals>
<goal>set-up</goal>
<goal>wiki</goal>
<goal>tear-down</goal>
</goals>
</execution>
</executions>
</plugin>
</plugins>
</build>
</profile>
<profile>
<id>auto</id>
<!--
This profile will boot FitNesse to automatically run the configured test suite. Simply run 'mvn verify -P auto'
-->
<build>
<plugins>
<plugin>
<groupId>com.processpuzzle.fitnesse</groupId>
<artifactId>fitnesse-launcher-maven-plugin</artifactId>
<executions>
<execution>
<goals>
<goal>set-up</goal>
<goal>run-tests</goal>
<goal>tear-down</goal>
<goal>verify</goal>
</goals>
</execution>
</executions>
</plugin>
</plugins>
</build>
</profile>
</profiles>
</project>