Section |
---|
Column |
---|
These steps are required when you convert from a demo/trial server installation to a production installation. Tip |
---|
While you are demo-ing you do not need to do the Database Setup steps discussed below. |
Your server requires an SQL database for storing users and form submissions. The follow SQL databases have been certified: The server may function with other SQL database types but only the above set has been certified. Warning |
---|
The default HSQLDB is ONLY sufficient for demo/trial versions of . All production users MUST switch their software to a production quality database. |
The following steps describe how to change the underlying database from the demo/trial HSQLDB to a production quality SQL database. The database configuration file frevvo.xml is located in <frevvo-home>/frevvo/tomcat/conf/Catalina/localhost directory. |
|
Select your database type
...
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"/>
--> |
Next, uncomment the pair of definitions for your database. Ex: if you are using SQL server, uncomment the definition for SQLSERVER Resource. Save the changes.
Code Block |
---|
<!--
<Resource auth="Container" SQLSERVER Resource
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"/>
--> |
Next, uncomment the pair of definitions for your database. Ex: if you are using SQL server, uncomment the definition for SQLSERVER Resource. Save the changes.
Code Block |
---|
<!--
SQLSERVER Resource
-->
<Resource auth="Container"
factory="org.apache.commons.dbcp.BasicDataSourceFactory"
maxActive="200"
maxIdle="20"
maxWait="10000"
validationQuery="select 1"
testOnBorrow="true"
testOnIdle="true"
timeBetweenEvictionRunsMillis="10000"
removeAbandoned="true"
logAbandoned="true"
name="jdbc/frevvoDS"
driverClassName="net.sourceforge.jtds.jdbcx.JtdsDataSource"
username="root"
password=""
type="javax.sql.DataSource"
-->
url="jdbc:jtds:sqlserver://localhost/frevvoSubmissions"/>
<Resource auth="Container"
factory="org.apache.commons.dbcp.BasicDataSourceFactory"
maxActive="200"
maxIdle="20"
maxWait="10000"
validationQuery="select 1"
testOnBorrow="true"
testOnIdle="true"
timeBetweenEvictionRunsMillis="10000"
removeAbandoned="true"
logAbandoned="true"
name="jdbc/userDSfrevvoDS"
driverClassName="net.sourceforge.jtds.jdbcx.JtdsDataSource"
username="root"
password=""
type="javax.sql.DataSource"
url="jdbc:jtds:sqlserver://localhost/usersfrevvoSubmissions"/>
|
Configure the Live Forms submissions database
...