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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does executequery return in java?

487


How can we retrieve data from the resultset?

529


How many types of jdbc drivers are there?

534


How do I insert/update records with some of the columns having NULL value?

487


What is jdbc thin client in oracle?

473






How do I retrieve a whole row of data at once, instead of calling an individual ResultSet.getXXX method for each column?

570


Under what circumstances, that all four drivers are used?

1885


What is the full form of jdbc?

472


What are the different types of interfaces in the api component?

503


Which type of driver provides jdbc access via one or more odbc drivers?

500


What are the jdbc statements?

535


Explain about Join?

575


What are the differences between stored procedure and functions?

459


What is the significance of DataBaseMetaData.tableIndexStatistics? How to obtain and use it?

495


Discuss the significances of jdbc.

499