#74

	<!-- SQL Plugin -->
	<plugin>
		<groupId>org.codehaus.mojo</groupId>
		<artifactId>sql-maven-plugin</artifactId>
		<version>1.5</version>
		<dependencies>
			<dependency>
				<groupId>${database.groupId}</groupId>
				<artifactId>${database.artifactId}</artifactId>
				<version>${database.version}</version>
			</dependency>
		</dependencies>

		<!-- common configuration shared by all executions -->
		<configuration>
			<driver>${database.driver}</driver>
			<driverProperties>loginTimeout=1800,connectTimeout=1800,socketTimeout=1800,autoReconnect=true</driverProperties>
			<url>${database.url}</url>
			<username>${database.user}</username>
			<password>${database.password}</password>
			<encoding>UTF-8</encoding>
			<printResultSet>true</printResultSet>
			<skipOnConnectionError>true</skipOnConnectionError>
		</configuration>

		<executions>
			<!-- SQL Script -->
			<execution>
				<id>SQL</id>
				<phase>compile</phase>
				<goals>
					<goal>execute</goal>
				</goals>
				<configuration>
					<outputFile>SQL.log</outputFile>
					<srcFiles>
						<srcFile>${sql.input.folder}/test.sql</srcFile>
					</srcFiles>
				</configuration>
			</execution>

			<!-- PL/SQL Script -->
			<execution>
				<id>PL-SQL</id>
				<phase>compile</phase>
				<goals>
					<goal>execute</goal>
				</goals>
				<configuration>
					<outputFile>PL-SQL.log</outputFile>					
					<delimiter>/</delimiter> <!-- PL-SQL specific configuration -->
					<delimiterType>row</delimiterType> <!-- PL-SQL specific configuration -->
					<srcFiles>
						<srcFile>${plsql.input.folder}/test2.sql</srcFile>
					</srcFiles>
				</configuration>
			</execution>
			
			<!-- SQL command -->
			<execution>
				<id>JUNIT-CREATE_DIRECTORY</id>
				<phase>compile</phase>
				<goals>
					<goal>execute</goal>
				</goals>
				<configuration>
					<onError>continue</onError>
					<username>sys</username>
					<password>password</password>
					<sqlCommand>CREATE OR REPLACE DIRECTORY tmp AS '/tmp';</sqlCommand>
				</configuration>
			</execution>
		</executions>
	</plugin>

ci, java, maven, sql

[Maven] Execute Selenium Test Cases [Bash] Aliases