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>