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.

In sections which follow, it is shown how to configure the most important settings for the three supported databases.

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

rdbms=oracle
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

Since the database password is kept in plaintext in db.properties file, it should be properly secured.

SOLoist doesn't offer any kind of encryption of the password field.