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 |
How can I use the JDBC API to access a desktop database like Microsoft Access over the network?
What does connection pooling mean ?
State the three different ways in which you can create a table?
How to update a resultset programmatically?
Why do we need jdbc?
What is Statement and PreparedStatement? whatz the difference?
What is namedparameterjdbctemplate?
What is new in JDBC 2.0?
How can we disable a constraint ?
What is the difference between executing, executequery, executeupdate in jdbc?
What are the advantages of using jdbc datasource?
What are clob and blob data types in jdbc?