This file is located in the Axiom installation directory. It contains a list of data sources and data source properties setting up the basic connection between Axiom and relational databases. You can also place this file in a particular application directory.
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 - The JDBC connection string for the relational database. You must specify a database name.
- dataSourceName.driver - The fully qualified package name of the JDBC driver for the relational database
- dataSourceName.user - The username used to access the database
- dataSourceName.password - The password used to access the database
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(seehttp://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
3.1 Relational DB Example
- dataSourceName.url - The JDBC connection string for the relational database. You must specify a database name.
- dataSourceName.driver - The fully qualified package name of the JDBC driver for the relational database
- dataSourceName.user - The username used to access the database
- dataSourceName.password - The password used to access the database
- dataSourceName.type - The type, relational, fast or lucene(the default storage is lucene, does not need to be specified)
mySqlDB.url = jdbc:mysql://db.domain.com/mysql mySqlDB.driver = org.gjt.mm.mysql.Driver mySqlDB.user = username mySqlDB.password = secretPassword mySqlDB.type = relational
3.1 FAST DB Example
- dataSourceName.url - The URL for the FAST QR Server
- dataSourceName.user - The username used to access the database
- dataSourceName.password - The password used to access the database
- dataSourceName.type - The type, relational, fast or lucene(the default storage is lucene, does not need to be specified)
- dataSourceName.adminurl - The URL for the fast admin server
- dataSourceName.adminport - The port for the fast admin server
- dataSourceName.contentdistributorurl - The URL for the fast content ditributer
- dataSourceName.class - The FAST database wrapper class
- dataSourceName.initclass - The FAST initialization class
- dataSourceName.querydispatcher - The FAST query dispatcher class
- dataSourceName.hitsobject - The FAST HitsObject name, exposed to Javascript
- dataSourceName.hitsclass - The FAST Hits class
fast fast.url = fast.siteworx.com:15100 fast.user = admin fast.password = password fast.type = fast fast.adminurl = fast.siteworx.com fast.adminport = 13000 fast.contentdistributorurl = fast.siteworx.com:16100 fast.class = axiom.objectmodel.dom.FastDatabase fast.initclass = axiom.ext.fast.FastInitializer fast.querydispatcher = axiom.ext.fast.FastQueryDispatcher fast.hitsobject = FastHits fast.hitsclass = axiom.ext.fast.FastHitsObject
References