For recovery/configuration purposes you may wish to access the embedded configuration database in Yellowfin from another tool, or remote computer.

By default, access to the HSQL configuration database is via an internal file link, however you can start the database in "network mode" that will allow multiple connections to the database.

To start the configuration database in network mode, at the command prompt go to the /Yellowfin/data directory.

Type in:

java -cp ../appserver/webapps/ROOT/WEB-INF/lib/hsqldb.jar org.hsqldb.Server configdb


This will start HSQL in network mode. You can now connect to it over a network connection on port 9001 (by default).

The JDBC connection string required to connect to this would be:

jdbc:hsqldb:hsql://:9001/configdb


If you wish to run Yellowfin off this database in network mode, then you will need to modify the connection string in /Yellowfin/appserver/webapps/ROOT/WEB-INF/web.xml.
You will need to make sure the database is started before booting Yellowfin.

You may wish to start the Skiteam database in network mode also:

This can be done from the /Yellowfin/tutorialdata directory, run:

java -cp ../appserver/webapps/ROOT/WEB-INF/lib/hsqldb.jar org.hsqldb.Server newskiteam

The JDBC URL for this is:

jdbc:hsqldb:hsql://:9001/newskiteam