db.properties

Description
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 data sources, the property sources is assigned a comma-separated list of names (certainly, the list can contain only one element):

sources = dataSourceName

In consequence the following properties of the data source(s) must be set:

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

Example
sources = mySqlDB, oracleDB, hsqlDB

mySqlDB.url = jdbc:mysql://db.domain.com/mysql
mySqlDB.driver = org.gjt.mm.mysql.Driver
mySqlDB.user = username
mySqlDB.password = secretPassword

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

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

Additional properties are ignored by Helma but forwarded to the relational database as connection properties.

Example (see http://bugs.mysql.com/bug.php?id=7369)
sources = mySqlDB

mySqlDB.url = jdbc:mysql://db.domain.com/mysql
mySqlDB.driver = org.gjt.mm.mysql.Driver
mySqlDB.user = username
mySqlDB.password = secretPassword
mySqlDB.zeroDateTimeBehavior = convertToNull

... comment

Page last modified on 2007-10-23 12:57 by daniel

... link