...
| Note |
|---|
|
...
- Locate the frevvoDS data source url parameter.url="jdbc:jtds:sqlserver://localhost/frevvo"/>. You can change the name "frevvo" to whatever you wish, " forms" for example. But it must match the database name you create in your SQL server. See [[#Verify_Connection_Url | verify connection Url]] below below.
- Create a utf8 encoded database ""frevvo" (assuming you left the url parameter database name as the default) in your SQL server
- In the installation locate the script <frevvo-home>/data/sql/forms-<database type>.sql. Ex: for mySQL the script is named <frevvo-home>/data/sql/forms-mysql5.sql
- Run that script in your "" database. That will create all the tables required to persist submissions
- Set the frevvoDS data source parameters username and password to a user that has write permissions to the "" database.
- The submissions database setup is now complete.
...
Live Forms's submission and user databases rely on the JDBC API. You can use any relational database as long as you have a JDBC driver for that database, however. [[#Configure_the_database | See the list of Live Forms certified databases]]. If you choose a database that's not in this list you do so at your own risk.
| Warning |
|---|
You MUST use the JDBC4 type driver. |
The Live Forms download download package comes with several pre-installed drivers. Look in <frevvo-home>/tomcat/lib and you will see (among other jar files) the following pre-installed driver jar files:
...
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
- [http://msdn.microsoft.com/en-us/sqlserver/aa937724 SQL Server JDBC Driver]
- [http://www.oracle.com/technetwork/database/features/jdbc/jdbc-112010-090769.html Oracle]
- [https://www-304.ibm.com/support/docview.wss?uid=swg21363866 DB2]
- [http://dev.mysql.com/downloads/connector/j/ Mysql]DB2
- Mysql
Once you have the driver you need, copy it to <frevvo-home>/tomcat/lib.* [
- http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html Oracle]
* [https://www14.software.ibm.com/webapp/iwm/web/preLogin.do?lang=en_US&source=swg-dm-db2jdbcdriver IBM DB2]
* [http://dev.mysql.com/downloads/connector/j/5.1.html MySQL]
* [http://rmijdbc.objectweb.org RmiJDBC]
...