Storing License Server Reports in ORACLE Database
dangerSince Sahi Pro 8.0.0 this feature has been deprecated. Please 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 ORACLE database, do the following
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;
Download the ORACLE Connector and copy ojdbc6.jar file to
# 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.