db.properties

This file is located in Helma's installation directory. It contains a list of data sources and data source properties setting up the basic connection between Helma and relational databases.

To define a data source, add its properties to the db.properties file prefixed with the data source name:

dataSourceName.url
dataSourceName.driver
dataSourceName.user
dataSourceName.password

Example

mysql.url = jdbc:mysql://localhost/dbname
mySql.driver = com.mysql.jdbc.Driver
mySql.user = username
mySql.password = secretPassword

oracle.url = jdbc:oracle://db.domain.com/oracle
oracle.driver = oracle.jdbc.driver.OracleDriver
oracle.user = username2
oracle.password = secretPassword2

hsql.url = jdbc:hsqldb:dbData
hsql.driver=org.hsqldb.jdbcDriver
hsql.user=sa
hsql.password=

Additional properties are ignored by Helma but forwarded to the relational database as connection properties, so you may set properties specific to the databse product you're using.

mysql.url = jdbc:mysql://db.domain.com/mysql
mysql.driver = com.mysql.jdbc.Driver
mysql.user = username
mysql.password = secretPassword
mysql.zeroDateTimeBehavior = convertToNull
mySql.useUnicode=true
mySql.characterEncoding=UTF-8