Versions Compared

Old Version 13

changes.mady.by.user Former user

Saved on

compared with

New Version 14

changes.mady.by.user Former user

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Section
Column

The database connector is a web application and can be deployed under any Servlet container. The connector relies on the JDBC API. You can use any relational database as long as you have a JDBC driver for that database.

  1. A Servlet Container compatible with the Servlet 2.5 specification. For instance, Tomcat (6 or higher) or Jetty (6 or higher). If you have installed the frevvo- tomcat  In-house bundle you already have what you need.
  2. A JDBC driver for your database.

The database connector download comes with several pre-installed drivers. See Install a JDBC driver below.

Column
width240px

On this page:

Table of Contents
maxLevel1

...

Throughout this documentation we are using the frevvo-tomcat the tomcat bundle as the installation location for the database connector. This is just an example as the connector will work under any compatible servlet container. This documentation assumes that the frevvo-tomcat the tomcat bundle is installed in c:\frevvo. We'll refer to this directory below as <frevvo-home>.

If you have already downloaded the frevvo- tomcat bundle for  In-house then you already have the database connector. It is located in the unpacked frevvo- tomcat bundle in <frevvo-home>\frevvo\ext\connectors and is named database.zip. If not or if you wish to download the latest version then download the database connector from the frevvo web  web site. You will need to login with your frevvo account account

Follow these steps to install the connector:

...

2) Copy <db-tmp>\database.war to <frevvo-home>\tomcat\webapps

  • If frevvo is  is running this will automatically expand database.war into a <frevvo-home>\webapps\database sub folder

3) If frevvo is  is not running, start frevvo : Double  Double click <frevvo-home>\start-frevvo

  • This will start frevvo and  and it will automatically expand database.war into a <frevvo-home>\webapps\database sub folder

...

  1. Review the previous installation steps
  2. See starting and testing the connector installation for more detailed instructions and common problems.
  3. If you cannot get the database connector working please see Getting Help to contact frevvo support support.

Follow these steps to configure the connector:

...

Warning

You MUST use a JDBC4 type driver.

The frevvo 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:

...

Previous Pre-Installed Driver Versions

Previous versions of frevvo include  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)

...