Versions Compared

Old Version 38

changes.mady.by.user Former user

Saved on

compared with

New Version 39

changes.mady.by.user Former user

Saved on

Key

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

...

Warning

You MUST use a JDBC4 type driver, version 5.1.26 or later.

The  download package comes with the pre-installed drivers preinstalled drivers are listed below.

  • MS SQL driver - The MS SQL driver is embedded in the database.war in the Database Connector Standalone bundle. It is not embedded in the frevvo-tomcat bundle

  • DERBY 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. Refer to the Using the jTDS driver topic for information if you are using the jTDS SQL Server driver.

Once you have the driver you need, copy it to:

  • <frevvo-home>/tomcat/lib if you are deploying the connector in the frevvo-tomcat bundle
  • <directory where you unzipped the Database Connector Standalone bundle <db-home> \database-connector-2.5.x\lib

...

  • in the Database Connector

...

  • Standalone bundle

Info
  • You MUST copy the MS SQL (sqljdbc.jar) to the <frevvo-home>/tomcat/lib directory if you are deploying the connector in the tomcat bundle There are some and using MS SQL as your external database
  • Refer to the special considerations when defining datasources if you are using the jTDS driver. The validationQuery must be included in the resource definition. This query is used during the validation sequence.
  • 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.

...