Database Configuration

The database to be used in a SOLoist application is configured by way of a db.properties file. The exact filename of the db.properties file and the RDBMS need to be set with an rdbms tag in soloist-config.xml.

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

Before you start configuring database for a SOLoist application, you need to create a database schema, and add a user with appropriate privileges for that schema. Be sure to memorize or write down the schema name, user name and password, beacuse you will need to enter them into the db.properties file.

driverClassName=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/emptyproject
username=sol_user
password=sol_user

driverClassName=oracle.jdbc.OracleDriver
url=jdbc:oracle:thin:@localhost:1521/XE
username=sol_user
password=sol_user

driverClassName=com.sybase.jdbc4.jdbc.SybDriver
url=jdbc:sybase:Tds:localhost:2640/emptyproject
username=sol_user
password=sol_user