FairCom JDBC Developer's Guide

Basic JDBC Driver Operations

This chapter describes how to set up and get started using the FairCom DB SQL JDBC Driver.

Required Java Environment

You must have a supported Java development or runtime environment on each system that uses the FairCom DB JDBC Driver. The FairCom DB JDBC Driver requires the following development (or compatible runtime) environments:

• OpenJDK Version 8 or higher (A Java 1.5 compatible version of the JDBC driver compatible is available upon request for applications still tied to this legacy Java framework.)

(See Java Requirements for FairCom DB SQL for the JDK version required for your FairCom DB SQL environment,)

You must have one of these environments or their associated Java runtime environments to use the JDBC Driver. For details on obtaining this software, visit Click here to download.

In This Chapter Connection String Connecting to a Database Adding FairCom DB JDBC to a Third-Party JDBC Tool Managing Transactions Explicitly to Improve Performance Query Timeout Options Driver Socket SEND/RECV Timeout JDBC Version Information Setting Up the JDBC Driver: Application Server Setting Up the JDBC Driver: Web Server