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 the standard isolation levels defined by JDBC?

648


What is JDBC API and when do we use it?

636


Explain the locking system in jdbc?

622


What are the main steps in java to make JDBC connectivity?

648


What is statement and preparedstatement in java?

570






Describe how the jdbc application works.

605


How do you determine the sensitivity of the ResultSet object?

622


What types of DataSource objects are specified in the Optional Package?

650


What is jdbc and why is it required?

556


What do you understand by jdbc driver and explain its types?

585


What are the exceptions in jdbc?

573


What is jdbc thin client?

596


What is correlated subquery?

1836


What are the factors that the jdbc driver performance depends upon?

607


Explain the steps in writing a java program using jdbc?

548