...
- First, Locate and copy the necessary jdbc driver for your database into <frevvo-home>\tomcat\lib.
- Edit the file <frevvo-home>\tomcat\conf\Catalina\localhost\frevvo.xml
- You will see two data source definitions for each database type. name="jdbc/frevvoDS" is the form submissions database. name="jdbc/userDS" is the user database. See the above sample of the sample below of the HSQLDB data source in the frevvo.xml file.
- Comment out the pair of the definitions for the default database (HSQLDB) using the <!-- --> comment characters. The entire section must be commented out:
| Code Block |
|---|
<!--
HSQLDB Resource
<Resource auth="Container"
type="javax.sql.DataSource"
factory="org.apache.commons.dbcp.BasicDataSourceFactory"
name="jdbc/frevvoDS"
driverClassName="org.hsqldb.jdbcDriver"
username="sa" password=""
url="jdbc:hsqldb:file:${catalina.home}/../data/db/forms"
maxActive="200"
maxIdle="20"
maxWait="10000"
validationQuery="select 1 from INFORMATION_SCHEMA.SYSTEM_USERS"
testOnBorrow="true"
testOnIdle="true"
timeBetweenEvictionRunsMillis="10000"
removeAbandoned="true"
logAbandoned="true"/>
<Resource auth="Container"
type="javax.sql.DataSource"
factory="org.apache.commons.dbcp.BasicDataSourceFactory"
name="jdbc/userDS"
driverClassName="org.hsqldb.jdbcDriver"
username="sa"
password=""
url="jdbc:hsqldb:file:${catalina.home}/../data/db/users"
maxActive="200"
maxIdle="20"
maxWait="10000"
validationQuery="select 1 from INFORMATION_SCHEMA.SYSTEM_USERS"
testOnBorrow="true"
testOnIdle="true"
timeBetweenEvictionRunsMillis="10000"
removeAbandoned="true"
logAbandoned="true"/>
--> |
...