IBM Worklight v5.0.5 > WL server administration > IBM Worklight properties

IBM Worklight database setup


JDBC based properties

The worklight.properties file might contain one of two methods to connect to a database:

Do not mix the two methods in one file.

Property Key Property Value
wl.db.username IBM Worklight database user name. Default: Worklight
wl.db.type Database vendor. Options: DB2, MYSQL, ORACLE, HSQL, DERBY. Default: HSQL
wl.db.password IBM Worklight database password. Default: Worklight
wl.db.driver
MySQL com.mysql.jdbc.Driver
Oracle oracle.jdbc.OracleDriver
DB2 com.ibm.db2.jcc.DB2Driver
Derby org.apache.derby.jdbc.EmbeddedDriver
wl.db.reports-url(*) JDBC path to IBM Worklight Reports database. Default: IBM Worklight database
wl.db.reports-username(*) IBM Worklight Reports database user name. Default: IBM Worklight database
wl.db.reports-password(*) IBM Worklight Reports database password. IBM Worklight database
wl.reports.db.type(*) Database vendor. Options: DB2, MYSQL, ORACLE, HSQL, DERBY. Default: HSQL

(*) By default all IBM Worklight report mechanisms use a single reports database. The reports database is set to be the same database as the IBM Worklight database. This default can be changed using the parameters in the following table. Enabling Raw Data Reports


JNDI based properties

Property Key Property Value
wl.db.jndi.name JNDI name for the Worklight database
wl.reports.db.jndi.name(*) JNDI name for the Worklight reports database
wl.db.type Database vendor. Options: DB2, MYSQL, ORACLE, HSQL,DERBY. Default: HSQL
wl.reports.db.type (*) Database vendor. Options: DB2, MYSQL, ORACLE, HSQL, DERBY. Default: HSQL. Must be identical to wl.db.type value

(*) By default all IBM Worklight reports mechanisms use a single reports database. The reports database is set to be the same database as the IBM Worklight database, but it is possible to change this default.


Parent IBM Worklight properties