What is JDBC and ODBC and what are the differences between
them?
- 11 Answers
- 105245 Views
- Idbi Bank, Infosys, Infoview, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / janet
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
| Is This Answer Correct ? | 317 Yes | 26 No |
Answer / preethi kumar
1.ODBC is for Microsoft and JDBC is for java applications.
2.ODBC can 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 doesnt 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
| Is This Answer Correct ? | 89 Yes | 43 No |
Answer / pradeep kumar
1. ODBC is procedural oriented and JDBC is object oriented.
2. ODBC is used to provide connection between front-end
(other than JAVA) and back-end (weak database like MS-
ACCESS) and JDBC is used to provide connection between JAVA
and database(oracle,sybase,DB2).
| Is This Answer Correct ? | 66 Yes | 25 No |
Answer / anshu aggarwal
JDBC is Java Database Connectivity. It enables java programs
to execute sql statements. JDBC makes it possible to write a
single database application that can run on different
platforms and interact with different DBMS. JDBC is language
dependent i.e it is used only to make connectivity with java.
ODBC is open database connectivity. The goal of ODBC is to
make it possible to access any data from any application,
regardless of which database management system (DBMS) is
handling the data so it is language independent.
| Is This Answer Correct ? | 49 Yes | 20 No |
Answer / srilatha
*ODBC is for microsoft & JDBC is for java applications
* ODBC can't be directly used with java because it uses a c
interface.
*ODBC makes use of pointers which have been
removed totally from java.
*ODBC is procedural-oriented & JDBC is Object-Oriented
*ODBC is used to provide connection between front-end and
back-end.JDBC is used to provide connection between java
and database.
*ODBC is language -independent&JDBC is language-dependent.
*ODBC mixes simple & advanced features together and has
complex options for simple queries.JDBC is designed to keep
things simple while allowing advanced capabilities when
required.
*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.
| Is This Answer Correct ? | 38 Yes | 11 No |
Answer / ravi
* ODBC can't be directly used with java because it uses a c
interface.
| Is This Answer Correct ? | 42 Yes | 17 No |
Answer / manjesh
ODBC is open database connectivity. The goal of ODBC is to
make it possible to access any data from any application,
regardless of which database management system (DBMS) is
handling the data so it is language independent
JDBC is Java Database Connectivity. It enables java programs
to execute sql statements. JDBC makes it possible to write a
single database application that can run on different
platforms and interact with different DBMS. JDBC is language
dependent i.e it is used only to make connectivity with
java.
.*ODBC is language -independent&JDBC is language-dependent.
| Is This Answer Correct ? | 37 Yes | 12 No |
Answer / vaibhav kansal
Difference between JDBC and ODBC?
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)OBC 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.
| Is This Answer Correct ? | 35 Yes | 11 No |
Answer / anita
1.ODBC is for Microsoft and JDBC is for java applications.
2.ODBC can 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. JDBC API is a natural Java Interface and is built on
ODBC. JDBC retains some of the basic feature of ODBC
| Is This Answer Correct ? | 28 Yes | 26 No |
Answer / mahesh
1:-ODBC is platform dependent and database independent 1:-JDBC is both platform and database independent
2:-ODBC implement in C language with pointer 2:-JDBC implement in JAVA with out pointer
| Is This Answer Correct ? | 1 Yes | 1 No |
What are JDBC Best Practices?
what are the types of result sets in JDBC 3.0 ?
Explain how to make updates to the updatable resultsets.
Hi........I need to create a dropdown box using java.....this box should show the values that should be taken from the database...... Thank you....
Which is better odbc or jdbc?
What is meant by dao?
give me a java code snippet to connect Microsoft excel through.... I am trying alot... plz help me.
Diff bet.. Function and Trigger?
Does sql allow null values ?
How do java applications access the database using jdbc?
What are different types of transactions?
Explain the process of creating tables using NetBeans IDE?
Core Java 
