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
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