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 is database connection pooling? Advantages of using a connection pool?

517


What driver should I use for scalable Oracle JDBC applications?

484


What is the advantage of namedparameterjdbctemplate?

494


What are the standard isolation levels defined by JDBC?

554


What is layer in communication?

443






What are the steps to connect to the database in java?

504


What do you mean by batch processing in jdbc?

507


What are jdbc?

528


What is type 4 jdbc driver?

468


What are the advantages of using preparedstatement over statement?

514


State the three different ways in which you can create a table?

496


What are the jdbc statements?

535


What does jdbc stand for?

490


What is connection commit?

473


What are the jdbc api components?

638