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 is statement and preparedstatement in java?

497


What is a jdbc url?

467


What are the types of statements in jdbc?

532


What is a rollback in jdbc?

531


Explain the difference between rowset vs. Resultset in jdbc?

580






How many rowset are available in jdbc?

669


What is JDBC ResultSet?

598


State the different connection methods used for creating different types of sql.

505


How to set NULL values in JDBC PreparedStatement?

545


Why hibernate is better than jdbc?

505


What are four types of JDBC driver?

570


What is jdbc explain?

498


Does sql allow null values ?

552


What is resultset?

576


Where jdbc drivermanager class is used?

534