Table of Contents

Driver

JDBC drivers must implement the Driver interface, and the implementation must contain a static initializer that will be called when the driver is loaded. This initializer registers a new instance of itself with the DriverManager (no more in 4.1)

Example static initializer for a driver implementing java.sql.Driver

public class AcmeJdbcDriver implements java.sql.Driver {
static {
java.sql.DriverManager.registerDriver(new
AcmeJdbcDriver());
}
...
}

When a Driver implementation is loaded, the static initializer will automatically register an instance of the driver.

Load

The client using this driver may assume that the JDBC driver classes are:

Vendor Implementations

You can use JDBC drivers to connect to the following data sources:

  • Relational Databases Servers such as Teradata, Oracle, IBM DB2, Microsoft SQL Server, Sybase, Informix, MySQL, PostgreSQL, etc
  • Desktop Databases including Microsoft Access, Hypersonic SQL, Dbase, FoxPro, Microsoft Excel, etc.
  • LDAP directories,
  • Non-relational Databases such as IMS, ADABASE, DATACOM, VSAM, etc, by using third-party adapters (iWay, Attunity, Hit Software are examples of solution providers)