Ubik Batch Server Advanced features
From UbikWiki
Contents |
Features
Development Mode
Explanation:
When development mode is enabled, Batch Server can automatically create the database and needed SQL tables by itself, so users don't have to create the database.
How to:
To enable the development mode in your batch server you just have to add the following line in your config.properties (see installation guide):
config.propertie:
... DEVELOPMENT_MODE=true
This feature only works with an HSQLDB database, so you have to configure your datasource.xml like this:
Datasource.xml:
... <ResourceParams name="jdbc/console"> <parameter> <name>username</name> <value>sa</value> </parameter> <parameter> <name>isPasswordEncrypted</name> <value>false</value> </parameter> <parameter> <name>driverClassName</name> <value>org.hsqldb.jdbcDriver</value> </parameter> <parameter> <name>url</name> <value><![CDATA[jdbc:hsqldb:file:C:\jdbc\hsql\console\consoleHSQL2]]></value> </parameter> <parameter> <name>validationQuery</name> <value><![CDATA[select 1 from INFORMATION_SCHEMA.SYSTEM_USERS]]></value> </parameter> <parameter> <name>testOnBorrow</name> <value>true</value> </parameter> ...
Note: the jdbc url parameter is like this: jdbc:hsqldb:file:$DIRECTORY/$DATABASE_NAME
You juste have to ensure that $DIRECTORY is readable because the HSQL database will be created in it.
... starting naming service naming service started starting connector ... connector started ... server started ... Development mode actived... Starting database creation script for development mode... Database creation succeded for development mode ...