Product: OpenFusion Notification Service

Version: ALL

Description:

Do I have to create tables to use the database plug-in?

Resolution:

If you are using a database plug-in you can use the option "JDBC Auto-create tables" to have the service create the tables at start up. This option can be found on the "PERSISTENCE" tag on the service you are using, in the OpenFusion Administration Manager.

By default, this is on for HSQLDB and off for all other databases. For databases other than HSQLDB, you can either create the tables by running the create scripts (as covered in the System Guide), or turn the auto-create option on.

Please note the autocreate option only works for databases other than HSQLDB in v4, if you are using an earlier version you will need to create the tables yourself.