JDBC

• JDBC stands for Java Database Connectivity.
• JDBC is not a language.
• JDBC is a technology written in java language.
• JDBC is a specification or abstracts or protocols given by Sun Microsystem for developing database as well as platform independent java applications.
• JDBC API (Application Programming Interface) is a collection of Interfaces.
• JDBC is a specification given by sun microsystem for developing JDBC drivers.

What is JDBC Driver ?

JDBC Driver API is an implementation of JDBC API. JDBC Driver converts JDBC call into database specific call.

Who develop JDBC Driver ?

There are 3 people in developing JDBC Drivers.

• Sun Microsystem
• Database Vendor
• Third party vendor

What is the difference between ODBC and JDBC ?

1. ODBC specification is given by Microsoft whereas JDBC specification is given by Sun Microsystem.
2. ODBC is written in C language, JDBC is written in java.
3. ODBC is platform dependent, JDBC is platform independent.

Types of JDBC Drivers ?

1. Type 1 - JDBC-ODBC Bridge Driver.
2. Type 2 - Native API and partially java driver.
3. Type 3 - NetAPI and all java driver.
4. Type 4 - Native protocol and pure java driver.