Storing License Server Reports in MSSQL Database
dangerSince Sahi Pro 8.0.0 this feature has been deprecated.
Refer Sahi License Hub instead.
By default License Server stores its reports in a H2 database which is bundled in License Server. To store License Server reports 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 splsCreating Tables
The tables will be created automatically, once License Server is restarted after performing the following steps. There is no need to run the db script manually.Add MSSQL Driver Jars to Sahi Classpath
Download the MSSQL Connector, extract and copy sqljdbc4.jar tospls/extlib
folder.
Point License Server to use the MSSQL Database
Add the following toserver.properties
in spls/userdata/config
folder
# Specifies database type.
# The inbuilt options are "mysql", "mssql", "oracle" and "h2"
# 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=spls
db.user_name=sa
db.password=
Change the user_name, password and database name as required.