What is JDBC and ODBC and what are the differences between
them?

Answers were Sorted based on User's Feedback



What is JDBC and ODBC and what are the differences between them?..

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

What is JDBC and ODBC and what are the differences between them?..

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

What is JDBC and ODBC and what are the differences between them?..

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

What is JDBC and ODBC and what are the differences between them?..

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

What is JDBC and ODBC and what are the differences between them?..

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

What is JDBC and ODBC and what are the differences between them?..

Answer / ravi

* ODBC can't be directly used with java because it uses a c
interface.

Is This Answer Correct ?    42 Yes 17 No

What is JDBC and ODBC and what are the differences between them?..

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

What is JDBC and ODBC and what are the differences between them?..

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

What is JDBC and ODBC and what are the differences between them?..

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

What is JDBC and ODBC and what are the differences between them?..

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

Post New Answer

More JDBC Interview Questions

How can I use the JDBC API to access a desktop database like Microsoft Access over the network?

0 Answers  


What does connection pooling mean ?

0 Answers  


State the three different ways in which you can create a table?

0 Answers  


How to update a resultset programmatically?

0 Answers  


Why do we need jdbc?

0 Answers  






What is Statement and PreparedStatement? whatz the difference?

2 Answers  


What is namedparameterjdbctemplate?

0 Answers  


What is new in JDBC 2.0?

0 Answers  


How can we disable a constraint ?

0 Answers  


What is the difference between executing, executequery, executeupdate in jdbc?

0 Answers  


What are the advantages of using jdbc datasource?

0 Answers  


What are clob and blob data types in jdbc?

0 Answers  


Categories