What is the difference between JDBC and ODBC?

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

Offline chinmay.sahooTopic starter

  • Trade Count: (0)
  • Full Member
  • ***
  • Thank You 2
  • Posts: 159
  • Karma: 0
    • Hot Shaper
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 44
  • Posts: 893
  • 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)
  • Newbie
  • *
  • Thank You 0
  • Posts: 8
  • 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.

 

Related Topics

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