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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

If you are given a choice to implement the code to either insert a record or update if already exist, which approach will you follow ?

586


What is savepoint in jdbc?

524


What does jdbc do?

537


How are jdbc statements used?

514


How does JDBC API helps us in achieving loose coupling between Java Program and JDBC Drivers API?

629






Explain how to make updates to the updatable resultsets.

516


any one can explain about policy file rule? when i connect database with applet then ther is no compile time error but the run time error is occureed.i.e access is denied.policy file rule is related to this problem.

1862


What are collection pools?

527


What is statement and resultset in jdbc?

508


What do you mean by database connection pooling?

526


How does a file store compare with a jdbc store?

649


What do you mean by batch processing in jdbc?

539


How can I determine where a given table is referenced via foreign keys?

563


How can I get information about foreign keys used in a table?

540


Which database is used for java?

536