06 - Database Plugin

This plugin provides all the elements needed to interact with a database.

Prerequisites

To connect to a database and so to use database targets, an automation Squash-TA project need an adequat JDBC driver (The driver is dependant of the database type: mysql, oracle...)

The driver is provided in the form of a maven artifact that we add in the automation project in modifying the 'squash-ta-maven-plugin' inside the file 'pom.xml':

…

<build>

<plugins>

<plugin>

<groupId>org.squashtest.ta</groupId>

<artifactId>squash-ta-maven-plugin</artifactId>

<version><version du squash-ta-maven-plugin></version>

<dependencies>

<dependency>

<groupId><groupId du driver JDBC></groupId>

<artifactId><artifactId du driver JDBC></artifactId>

<version><version du driver JDBC></version>

</dependency>

<dependencies>

…

Example of JDBC Driver for MySql

<!-- JDBC Driver for MySql -->

<dependency>

<groupId>mysql</groupId>

<artifactId>mysql-connector-java</artifactId>

<version>5.1.19</version>

</dependency>