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

What causes no suitable driver error?

549


What is jdbc dialect?

509


Is uri the same as url?

498


Explain about multiple implementations and drive manager?

570


What does connection pooling mean ?

577






java based application for hospital management

3449


Does jdbc require oracle client?

531


What are the new features available in jdbc 4.0?

534


Does jpa use jdbc?

497


What are collection pools?

521


What is an escape syntax?

533


Why can't Tomcat find my Oracle JDBC drivers in classes111.zip?

577


What is executeupdate in java?

480


What happens if we don't close the connection in jdbc?

490


How do we call a stored procedure from jdbc?

557