This consists of the following steps
Need to configure a database - hsqldb is the only database that is supported at the moment
set up the database
create the tables in the database
create the JNDI datasource reference
Create a JNDI reference to the configuration file - this reference should be called AstrogridApplicationsConfigURL Although tomcat 4 does supply a tool to set the JNDI resources, it appears to be buggy and the best way is probably to edit the $CATALINA_HOME/conf/server.xml file directly. You can place the definitions in the <DefaultContext> element (within an <engine> element) or it can be placed in the application specific context
<Environment description="properties file" name="AstrogridApplicationsConfigURL" override="true" type="java.lang.String" value="file:///data/work/Test.properties"/>
<Resource name="jdbc/AstrogridACDatasource" scope="Shareable" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/AstrogridACDatasource">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>5000</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>4</value>
</parameter>
<parameter>
<name>password</name>
<value>veritas</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:hsqldb:hsql://localhost:9001</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>org.hsqldb.jdbcDriver</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>2</value>
</parameter>
<parameter>
<name>username</name>
<value>sa</value>
</parameter>
</ResourceParams>
WorkingDirectory=/data/work/astrogrid/src/applications/build/workdir
ApplicationConfigFile=/data/work/astrogrid/src/applications/test/config/TestApplicationConfig.xml
The workingdirectory should point to a directory that the process
running the applicationController can write to. It creates
subdirectories in this directory to create a runtime environment for
each of the application instances that it runs. The
ApplicationConfigFile points to the file that contains all of the
descriptions of the applications that the application controller can
run. The contents of this file are describe in more detail on the Applicatons Setup page