Product: OpenFusion Notification Service

Version: 2.1 and above

Description:

How can HSQLDB be  configured  for access from multiple JVMs?

Solution:

When you install OpenFusion out of the box, it uses the default version of HSQLDB which is standalone mode. This means only one application can access the database at a time. You can change this to client server mode which allows multiple access from multple JVM's.

To do this:

1. Bring up the OpenFusion Administration Manager

2. Right click on the localhost node and choose Add->Service->HSQLDBService

3. Right click on the service you have just added and choose Add->Java Object->HSQLDBObject

4. Click on the Service and select the persistence tags. Set the JDBC URL=jdbc:hslqdb:hsql://localhost

5. Start HSQLDBService from the Administration Manager by right clicking on it and chosing Start from the menu. This writes data to the OpenFusion installation \\domains\\OpenFusion\\localhost\\HSQLDBService\\data directory

6. Start the Notification Service