What is the difference between JDBC and ODBC?

Started by chinmay.sahoo, 01-28-2016, 01:33:49

Previous topic - Next topic

chinmay.sahooTopic starter

a) OBDC is for Microsoft and JDBC is for Java applications.
b) ODBC can't be directly used with Java because it uses a C interface.
c) ODBC makes use of pointers which have been removed totally from Java.
d) 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.
e) 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.
f) JDBC API is a natural Java interface and is built on ODBC. JDBC retains some of the basic features of ODBC.


TomClarke

Thank you for giving this detailed explanation about difference between JDBC and ODBC.
It is very useful information!


Manya Johnson

1. ODBC is a function that provides a standard software API method for computers using DBMS.
JDBC is an API used for the Java programming language to define how a client may access a database.

2. ODBC implementations are run through multiple operating systems.
JDBC implementations can exist and be used by the same application.


michral86

ODBC is an open interface which can be used by any application to communicate with any database system, while JDBC is an interface that can be used by Java applications to access databases. Therefore, unlike JDBC, ODBC is language independent. But by using JDBC-to-ODBC bridge Java applications can also talk to any ODBC compliant database.

mishraviplav7877

JDBC is secured in light of the fact that it is composed in a java dialect while ODBC is a non-secured becaues it is writtn in C dialect for a security reason JDBC is the best.

ODBC is a C interface, So that it can't be utilized with Java specifically, and it's for Microsoft, utilized for desktop applications while JDBC is utilized just for a network with java enables database application to keep running on various stages and interact with various DBMS "DatBase Management Servers".