is a set of classes and interfaces written in Java to allow other Java programs to send SQL statements to a relational database management system.
This is Java Code that implements JDBC classes and methods in a way that is specific to the database being used. You will get these drivers from the Database Manufacuter.
There are different types of drivers that distinguish how this implementation and connection to the database is achieved.
Types of JDBC Drivers |
|||
Type 1
Requirements
|
Type 2
Requirements
|
Type 3
Requirements
|
Type 4
Requirements
|
TYPE 1 TYPE 2
from java.sun.com |
TYPE 4 TYPE 3 from java.sun.com |
OCI Driversometimes called FAT driver
|
THIN Driver
|
Requirements
|
Requirements
|
Common Uses
from www.oracle.com |
Requirements
from www.oracle.com |
The Oracle Call Interface (OCI) is an application programming interface
to Oracle databases. It consists of a library of C language routines to allow
C programs (or programs written in other third generation languages) to send
SQL statements to the database and interact with it in other ways.
Be CAREFULL About the version of Drivers you use!!!!!!!!!!!!!!
Because Java has undergone significant changes over its brief life, you must
use a version that matches your Java Development Kit.