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

Is uri the same as url?

578


Where is ojdbc14 jar located?

587


What is metadata in java programming?

565


How do you insert images into database using jdbc?

666


How many ways that we can view a result set?

637






What are restrictions on triggers?

1750


Can we return resultset in java?

562


What is transaction processing in jdbc?

654


Is jdbc part of j2ee?

613


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 ?

649


How do I write Greek ( or other non-ASCII/8859-1 ) characters to a database?

682


How can we set null value in jdbc preparedstatement?

615


What is the jdbc rowset?

631


How do I find whether a parameter exists in the request object?

575


Explain about DSN?

614