Skip to Content
avatar image
Former Member

Diff between JDBC & ODBC

hi,,

What is the difference between JDBC and ODBC

thanks

guna

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    avatar image
    Former Member
    Jul 22, 2008 at 02:27 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 22, 2008 at 02:46 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 22, 2008 at 02:02 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 22, 2008 at 02:06 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 22, 2008 at 02:06 PM

    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

    Add comment
    10|10000 characters needed characters exceeded