Sahi Pro - Storing License Server Reports in ORACLE Database

By default License Server stores its reports in a H2 database which is bundled in License Server. To store License Server reports in a ORACLE database, do the following

Create a Database Connection

Create a database connection in Oracle using any Oracle client (Oracle SQL Developer). Let us assume that the name of the database connection is spls

To achieve database connection to spls follow the below steps,

Assuming you have installed Oracle Database and Oracle Client (Oracle SQL Developer).

Connect to SYSTEM and run the below query to create, connect and grant privileges to the user.
CREATE USER spls IDENTIFIED BY password;
GRANT CONNECT TO spls;
GRANT ALL PRIVILEGES TO spls IDENTIFIED BY password;

Add ORACLE Driver Jars to Sahi Classpath

Download the ORACLE Connector and copy ojdbc6.jar file to spls/extlib folder.

Point License Server to use the ORACLE Database

Add the following to server.properties in spls/userdata/config folder
# Specifies database type.
# The inbuilt options are "mysql", "mssql", "oracle" and "h2"
# Change jdbc parameters accordingly
db.type=oracle

#JDBC parameters for oracle database
db.driver_name=oracle.jdbc.driver.OracleDriver
db.jdbc_url=jdbc:oracle:thin:@localhost:1521:oracle
db.user_name=spls
db.password=password

Change the db.user_name and db.password as required.

Restart and Run

Restart License Server. This will create the required tables in the database.