...

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.

Using the jTDS driver

There are some 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. This is not needed for the Microsoft's JDBC driver as it will be inferred for you.

Here is an example of the resource definition for the jTDS driver for a database named TEST:

queryset name="TEST">
     <resource-def>
          <url>jdbc:jtds:sqlserver://dbhost;DatabaseName=TEST;</url>
          <validationQuery>SELECT 1</validationQuery>
          <user>dbconnector</user>
          <password>************</password>
     </resource-def>
...

If you are using the dbconnector.properties or frevvo-config.properties file to define your datasources you must add the validationQuery property.

Here is the same example as above as it would appear in the dbconnector.properties file:

...

DB Connector Quick Demo

The BIRT (ClassicModels) and myStore querySets are preloaded with in-memory Derby databases and test data.  This make it very easy to try out the connector.  No configuration is necessary.

...