What is JDBC and ODBC and what are the differences between
them?
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 is jdbc resultsetmetadata interface?
any one can explain about policy file rule? when i connect database with applet then ther is no compile time error but the run time error is occureed.i.e access is denied.policy file rule is related to this problem.
In which ways is driver class is registered with drive manager?
What is a lock in jdbc?
Explain the role of driver in jdbc.
How does jdbc connect to database?
What are different parts of a url?
What is the difference between triggers and procedures?
What is the difference between ojdbc6 and ojdbc7?
How is jndi useful for Database connection?
What is CLOB and BLOB datatypes in JDBC?
How to get a whole row of data at once?