Sahi Pro - Storing Reports in MSSQL Database
By default Sahi stores its reports in a H2 database which is bundled in Sahi.Sahi reports can now also be logged in MSSQL database.
To store in a MSSQL database, do the following:
Create a Database
Create a database in MSSQL using any MSSQL client. Let us assume that the name of the database is sahireportsCreate Tables
There is a create tables script available atsahi/userdata/config/db/create_report_tables_mssql.sql
Run this script on sahireports database to create the necessary tables.Add MSSQL Driver Jars to Sahi Classpath
Download the MSSQL Connector,extract and copy sqljdbc4.jar to sahi/userdata/extlib/db folder (create if needed).
Then add the jar to Sahi's classpath
Point Sahi to use the MSSQL Database
Add the following to userdata.properties# Specifies database type.
# The inbuilt options are "mysql", "h2" and "mssql"
# Change jdbc parameters accordingly
db.type=mssql
#JDBC parameters for mssql database
db.driver_name=com.microsoft.sqlserver.jdbc.SQLServerDriver
db.jdbc_url=jdbc:sqlserver://localhost:1433;databaseName=sahireports
db.user_name=sa
db.password=abcd123
Change the user_name, password and database name as required.