Select your database type

...

<!--
  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.

 <!--
     <Resource auth="Container"          SQLSERVER Resource  
   type="javax.sql.DataSource-->
  
          <Resource auth="Container"
                factory="org.apache.commons.dbcp.BasicDataSourceFactory"
                namemaxActive="jdbc/userDS200"
                driverClassNamemaxIdle="org.hsqldb.jdbcDriver20"
                usernamemaxWait="sa10000"
                passwordvalidationQuery="select 1"
                urltestOnBorrow="jdbc:hsqldb:file:${catalina.home}/../data/db/users""true"
                testOnIdle="true"
                    maxActivetimeBetweenEvictionRunsMillis="20010000"
                maxIdleremoveAbandoned="20true"
                maxWaitlogAbandoned="10000true"
                validationQueryname="select 1 from INFORMATION_SCHEMA.SYSTEM_USERSjdbc/frevvoDS"
                testOnBorrow="true"
 driverClassName="net.sourceforge.jtds.jdbcx.JtdsDataSource"
                testOnIdleusername="trueroot"
                timeBetweenEvictionRunsMillispassword="10000"
                removeAbandonedtype="truejavax.sql.DataSource"
                logAbandonedurl="truejdbc:jtds:sqlserver://localhost/frevvoSubmissions"/>

-->

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.

 <!--
                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/userDS"
                driverClassName="net.sourceforge.jtds.jdbcx.JtdsDataSource"
                username="root"
                password=""
                type="javax.sql.DataSource"
                url="jdbc:jtds:sqlserver://localhost/users"/>

Configure the Live Forms submissions database

Configure the Live Forms submissions database

For your selected database type in frevvo.xml

1. Locate the frevvoDS data source url parameter.:url="jdbc:jtds:sqlserver://localhost/frevvo"/>. You can change the name "frevvo" to whatever you wish, "

   Frevvoproduct

   " for example. But it must match the database name you create in your SQL server. See verify connection Url below.
2. Create a utf8 encoded database UTF-8 encoded database "frevvo" (assuming you left the url parameter database name as the default) in your SQL server
3. In the

   Frevvoproduct

    installation locate the script <frevvo-home>/data/sql/forms-<database type>.sql. Ex: for mySQL the script is named <frevvo-home>/data/sql/forms-mysql.sql
4. Run that script in your "

   Frevvoproduct

   " database. That will create all the tables required to persist submissions
5. Set the frevvoDS data source parameters username and password to a user that has write permissions to the "

   Frevvoproduct

   " database.
6. The submissions database setup is now complete.

Configure the LiveForms Live Forms users database

For your selected database type in frevvo.xml,

1. Locate the userDS data source url parameter. : url="jdbc:jtds:sqlserver://localhost/users". You can change the name "users" to whatever you wish, "

   Frevvoproduct

    users" for example. But it must match the database name you create in your SQL server. See verify connection Url below.
2. Create a utf8 UTF-8 encoded database "users" (assuming you left the url parameter database name as the default) in your SQL server
3. In the

   Frevvoproduct

    installation locate the script <frevvo-home>/data/sql/users-<database type>.sql. Ex: for mySQL the script is named <frevvo-home>/data/sql/users-mysql5.sql
4. Run that script in the "users" database
5. Set the userDS data source username and password parameter to a user that has write permissions to your "users" database.

...

• hsqldb-2.2.4.jar - HSQLDB driver
• postgresql-9.0-801.jdbc4.jar - Postgress driver

If you don't find what you need pre-installed you will need to locate a driver compatible to your database. Usually you can download your driver from the internet. Try one of these locations

• SQL Server JDBC Driver
• Oracle
• DB2
• MySQL - 5.1.11 or later is recommended to resolve Tomcat memory leak issues.

Once you have the driver you need, copy it to <frevvo-home>/tomcat/lib.

The <frevvo-home>\tomcat\logs\frevvo.log file will report an error if you do not copy the JDBC driver to lib directory. The verbiage may differ depending on the driver and database. For example, the error for MySQL is "Cannot load JDBC driver class 'com.mysql.jdbc.Driver". Starting

Image Removed

It is also appropriate to copy the driver into any location that is in the CLASSPATH of your servlet container. In a tomcat installation another location would be <CATALINA_HOME>/lib.

Previous Pre-Installed Driver Versions

Previous versions of frevvo include these drivers:

• hsqldb-1.8.0.7.jar - HSQLDB jdbc driver
• com.microsoft.sqlserver.jdbc-1.1.3.jar - SQL Server driver
• jtds-1.2.5.jar - SQL Server driver
• org.objectweb.rmijdbc-1.0.0.jar - Access driver (also can be used for SQL Server)

If you don't find what you need pre-installed you will need to locate a driver compatible to your database. Usually you can download your driver from the internet. Try one of these locations

• Oracle
• IBM DB2 
• MySQL
• RmiJDBC.0-801.jdbc4.jar - Postgress driver

If you don't find what you need pre-installed you will need to locate a driver compatible to your database. Usually you can download your driver from the internet. Try one of these locations

• SQL Server JDBC Driver
• Oracle 
• DB2
• MySQL - 5.1.11 or later is recommended to resolve Tomcat memory leak issues.

Once you have the driver you need, copy it to <frevvo-home>/tomcat/lib.

The <frevvo-home>\tomcat\logs\frevvo.log file will report an error if you do not copy the JDBC driver to lib directory. The verbiage may differ depending on the driver and database. For example, the error for MySQL is "Cannot load JDBC driver class 'com.mysql.jdbc.Driver". Starting

Image Added

It is also appropriate to copy the driver into any location that is in the CLASSPATH of your servlet container. In a tomcat installation another location would be <CATALINA_HOME>/lib.

Changing Submission database naming and escaping conventions

...