Product Documentation

FairCom JDBC Developer's Guide

Next Topic

FairCom JDBC - Developers Guide

Developer Guide

FairCom JDBC Developer's Guide

Audience:

Developers

Subject:

Java Database Connectivity through an industry-standard JDBC driver

Copyright:

© Copyright 2024, FairCom Corporation. All rights reserved. For full information, see the FairCom Copyright Notice.

 FairCom DB SQL JDBC provides access to FairCom DB SQL environments from applications supporting JDBC 4.0 API and requires JRE/JDK 1.6 or later.

In V12 and later, JDBC conformance level 4.3 provides Java 9 and later compatibility.

JDBC allows applications to connect to any database using the same set of Java interfaces. Those interfaces allow programs to embed standard Structured Query Language (SQL) statements that update and retrieve data in the database.

As Java interfaces and SQL syntax are independent of any particular database implementation, JDBC makes it feasible for applications to connect to different database environments without modification.

Architecture

JDBC insulates Java applications from variations in database access implementations through the JDBC API, a set of class libraries distributed as a standard part of core Java. Instead of using calls to vendor-specific interfaces, JDBC applications use the JDBC API.

The JDBC API is distributed as the package java.sql and is included with the Java JDK (Version 1.6 or later), so any environment that supports a recent Java compiler can be used to develop JDBC applications.

Calls to the JDBC API are managed by the JDBC driver manager. The JDBC driver manager can support multiple drivers connecting to different databases. When an application tries to connect to a particular database, the driver manager loads the appropriate JDBC driver and routes subsequent calls through the driver.

A JDBC driver is a database-specific software that receives calls from the JDBC driver manager, translates them into a form that the database can process, and returns data to the application.

The following figure shows the different components of the JDBC architecture.

In This Chapter

Types of JDBC Drivers

JDBC Compared to ODBC

JDBC versioning

TOCIndex