JDBC - Driver

Jdbc Class Architecture

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)





Discover More
Card Puncher Data Processing
Hive - JDBC

JDBC information on Hive Example: hadoop-core-1.2.1.jar hive-jdbc-2.3.2.jar hive-jdbc--standalone.jar. Example: ...
Jdbc Class Architecture
JDBC - Character Encoding

Some JDBC driver manage the character encoding: Example: MySQL: jdbc:mysql://localhost:3306/administer?characterEncoding=utf8 Oracle: See oracle.sql.CharacterSet class. By using NLS_LANG you can indicate...
Jdbc Class Architecture
Jdbc - Driver Manager

java/sql/DriverManagerDriverManager JDBC 4.1 specification, when the DriverManager is trying to establish a connection: it calls the driver’s connect method and passes the URL. If the Driver...
Dbeaver Driver Obiee
WeBlog - How to query and get data from OBIEE with a database client (Jdbc)

This article will show you how you can query data in OBIEE through a database client application. This is actually really handy when you want to: create automatic test to control the repository design...



Share this page:
Follow us:
Task Runner