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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are devices?

496


How many packages are available in jdbc api?

541


How can I create a custom RowSetMetaData object from scratch?

551


How can I get or redirect the log used by DriverManager and JDBC drivers?

522


What are jdbc and its components?

582






What is JDBC Driver interface?

578


How can we move the cursor in a scrollable result set?

551


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

566


Explain about Join?

598


How can we disable a constraint ?

565


Explain the locking system in jdbc & its types?

510


Explain the various types of locking system in jdbc?

499


What is jdbc dialect?

509


Explain about multiple implementations and drive manager?

570


What is the limitation of PreparedStatement and how to overcome it?

642