Database Configuration

Used database in SOLoist project is configured through db.properties file.

Currently, SOLoist supports Oracle, Sybase SQL Anywhere, MySQL, but any other RDBMS that supports the usual relational paradigm, SQL (Structured Query Language), and ODBC can be easily supported, too. In EmptyProject that can be downloaded from SOLoist Website download section there are three db.properties files for each supported database.

Before you start with configuring RDBMS for SOLoist application, you have to create schema and user with all privileges for that schema. Information about created schema and user are placed in the db.properties file, so configuring database for SOLoist application comes down to entering those information in appropriate file.

driverClassName=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/emptyproject
username=sol_user
password=sol_user
defaultAutoCommit=false
poolPreparedStatements=true
maxActive=50
maxIdle=30
initialSize=20