Diff between JDBC & ODBC

[Former Member]

hi,,

What is the difference between JDBC and ODBC

thanks

guna

[Former Member · Accepted solution]

Hi,

In simple words

JDBC -

---

This is the standard java interface to communicate with a database, by using this java can connect to the database.

ODBC -

---

To communicate with a database from any language this is developed, this is for generalized thing, by using this it can connect to any database from any language.

[Former Member]

Hi

1.ODBC is for Microsoft and JDBC is for java applications.

2.ODBC can't be directly used with Java because it uses a C

interface.

3.ODBC makes use of pointers which have been removed

totally from java.

4.ODBC mixes simple and advanced features together and has

complex options for simple queries,But JDBC is designed to

keep things simple while allowing advanced capabilities

when required.

5.ODBC requires manual installation of the ODBC driver

manager and driver on all client machines.JDBC drivers are

written in java and JDBC code is automatically

installable,secure,and portable on all platforms.

6. JDBC API is a natural Java Interface and is built on

ODBC. JDBC retains some of the basic feature of ODBC

Regards

Suryanarayana

[vijay_b4]

Hi Guna Sekhar,

JDBC is Java DataBase Connectivity API for making data connection for Data and Java Class.

ODBC is Open/Object DataBase Connectivity driver for Microsoft specification and desktop applications.

JDBC = standard java interface to communicate with a database

ODBC = from Microsoft developed interface to communicate

with a database

JDBC-ODBC driver = an interface where the communication is translated from JDBC to ODBC and the communication after the driver to the database is via ODBC

ODBC is mostly used on Windows plattforms (if you want to connect with a database from C++,Delphi,etc.) , but there are also ODBC drivers for Linux available

<removed by moderator>

Regards

Pragathi.

Edited by: Mike Pokraka on Jul 24, 2008 12:52 PM

[Former Member]

Hi,

Some of the Differences are:

JDBC Java DataBase Connectivity

ODBC: Open DataBase Connectivity

JDBC = standard java interface to communicate with a database

ODBC = from Microsoft developed interface to communicate

with a database

JDBC-ODBC driver = an interface where the communication is translated from JDBC to ODBC and the communication after the driver to the database is via ODBC

ODBC is mostly used on Windows plattforms (if you want to connect with a database from C++,Delphi,etc.) , but there are also ODBC drivers for Linux available

Regards,

Venu V

[Former Member]

Hello Guna,

ODBC

ODBC is a multidatabase API for programs that use SQL statements to access data. An ODBC-based program can access heterogeneous databases without needing source code changes-one program can retrieve and store content in different vendors' databases via the ODBC interface. ODBC thus provides database-neutral delivery of both SQL and database content. Be aware, however, that you must load ODBC driver software for each vendor's database you want to access.

JDBC

JDBC is a collection of database access middleware drivers that provide Java programs with a call-level SQL API. Java applets and applications can use the drivers' API to connect to databases, store and retrieve database content and execute stored procedures, thus making JDBC a Java-enabled delivery mechanism for SQL. JDBC is to Java programs what ODBC is to programs written in languages other than Java. In fact, JDBC's design is based on ODBC's

Regards

Prasad