/The difference between ODBC and JDBC

The difference between ODBC and JDBC

 What’s the difference between ODBC and JDBC ? let’s see 😉

 

*ODBC


Stands for “Open DataBase Connectivity”: It’s an interface for accessing a databas.
statements enables you to access files in different databases, including Access, DataBase, Excel, and
Text.
*ODBC access the DataBase using SQL requests, ODBC converts these SQL requests into a request that the DataBase can understand.
*
ODBC is a C interface, So that it can’t be used with Java directly, and it’s for Microsoft, used for desktop applications.
*
ODBC requires “manual” installation of the driver manager and driver on client machine.
*
ODBC uses Object Oriented features.
Note That :-
ODBC is used between applications “Just An Interface”.
ODBC Architectur :-
Data Source >> Driver {DBMS} >> ODBC Driver Manger >>Application.

*JDBC

Stands for “Java DataBase Connectivity” : It’s the tool by which developers can connect, query and
update database using the SQL, Including group of Java classes and interfaces, JDBC is built on ODBC, Developer  has to write code to map an object model’s data representation to a relational data model and its database schema.

*
JDBC is Java API “Application programming interfac” used for connecting programs that is written in Java to the data in a relational databass.
*
JDBC Task is to : establish the connection with th DB then send SQL statements to the DB and finally process the result sets “Returned Data”.
*
JDBC allows database application to run on different platforms and interact with different DBMS “DatBase Management Servers”.
*
JDBC is used only for connectivity with java.
*
JDBC is Java version of ODBC.
*
JDBC is an API “Application programming interfac” Specification provided by SUN by which any Java Program can communicate with any database server.
*
With JDBC .. There’s no need for “Manual” installation {Unlike ODBC}, Because JDBC code is written automatically and installed and portable on all platforms.
Note That :-
To access ODBC databases by the JDBC interfaces, you must use a JDBC-ODBC bridge program.
JDBC Architecture :-
DataBase Management System “DBMS” >> ODBC Driver >> JDBC-ODBC bridge >> JDBC Driver Manager >> Java Application.