Sunday, 13 November 2011

JDBC BASICS

JDBC drivers are client-side adapters (installed on the client machine, not on the server) that convert requests from Java programs to a protocol that the DBMS can understand.

Types
There are commercial and free drivers available for most relational database servers. These drivers fall into one of the following types:
 
Type 1 that calls native code of the locally available ODBC driver.

Type 2 that calls database vendor native library on a client side. 
This code then talks to database over network.

Type 3, the pure-java driver that talks with the server-side 
middleware that then talks to database

Type 4, the pure-java driver that uses database native protocol.

No comments:

Post a Comment