What is the difference between JDBC and ODBC?

Author Topic: What is the difference between JDBC and ODBC?  (Read 9014 times)

Offline chinmay.sahooTopic starter

  • Trade Count: (0)
  • Full Member
  • ***
  • Thank You 2
  • Posts: 158
  • Karma: 0
    • We Helpline
What is the difference between JDBC and ODBC?
« on: 01-28-2016, 01:33:49 »
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.

Offline TomClarke

  • Trade Count: (0)
  • Hero Member
  • *****
  • Thank You 53
  • Posts: 844
  • Karma: 0
  • Gender: Male
    • Custom Writing Service & Content Marketplace
Re: What is the difference between JDBC and ODBC?
« Reply #1 on: 04-19-2016, 01:41:23 »
Thank you for giving this detailed explanation about difference between JDBC and ODBC.
It is very useful information!
Your ideas, our writings - Writology.com

Offline Manya Johnson

  • Trade Count: (0)
  • Semi-Newbie
  • *
  • Thank You 2
  • Posts: 13
  • Karma: 0
Re: What is the difference between JDBC and ODBC?
« Reply #2 on: 07-11-2016, 07:41:29 »
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.

Offline michral86

  • Trade Count: (0)
  • Semi-Newbie
  • *
  • Thank You 1
  • Posts: 34
  • Karma: 0
  • Gender: Female
Re: What is the difference between JDBC and ODBC?
« Reply #3 on: 06-03-2017, 03:20:24 »
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.

Offline mishraviplav7877

  • Trade Count: (0)
  • Jr. Member
  • **
  • Thank You 0
  • Posts: 50
  • Karma: 0
  • Gender: Male
Re: What is the difference between JDBC and ODBC?
« Reply #4 on: 07-20-2017, 03:47:38 »
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".


Related Topics

  Subject / Started by Replies Last post
4 Replies
Last post 11-28-2012, 00:13:19
by DavisJoseph
5 Replies
Last post 04-19-2016, 00:25:36
by TomClarke
21 Replies
Last post 12-18-2016, 20:20:43
by LaurentHector
18 Replies
Last post 02-23-2016, 05:33:28
by harryblossom0
0 Replies
Last post 10-26-2016, 05:03:51
by beingchinmay