...
| Code Block |
|---|
<Parameter name="teneo.naming.sql_name_escape_character" value="" override="false" /> |
Moving the forms database
| Note |
|---|
Typically you should not need to move the forms database as these instructions only apply to 's built-in HSQLDB which should not be used for production use. |
This information applies ONLY to the pre-installed demo database HSQLDB. When using the tomcat bundle installation and the default configuration settings, the forms and users database is written to the <frevvo-home>\data\db directory. You may wish to locate the databases outside of <frevvo-home>. To do this:
- Edit <frevvo-home>\tomcat\conf\Catalina\localhost\frevvo.xml
- You will see two data source definitions for each database type. jdbc/frevvoDS is the form submissions database. jdbc/usersDS is for the user database.
- Configure the HSQLDB jdbc/frevvoDS Resource
- Change url="jdbc:hsqldb:file:${catalina.home}/../data/db/forms" to an absolute directory e.g. url="jdbc:hsqldb:file:c:\tmp\frevvo-data\forms"
- Configure the HSQLDB jdbc/userDS Resource
- Change url="jdbc:hsqldb:file:${catalina.home}/../data/db/users" to an absolute directory e.g. url="jdbc:hsqldb:file:c:\tmp\frevvo-data\users"
| Note |
|---|
Failure to configure this resource correctly will cause issues trying to create new forms, view submissions and submit forms. |