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

Answer Posted / anshu aggarwal

JDBC is Java Database Connectivity. It enables java programs
to execute sql statements. JDBC makes it possible to write a
single database application that can run on different
platforms and interact with different DBMS. JDBC is language
dependent i.e it is used only to make connectivity with java.

ODBC is open database connectivity. The goal of ODBC is to
make it possible to access any data from any application,
regardless of which database management system (DBMS) is
handling the data so it is language independent.

Is This Answer Correct ?    49 Yes 20 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the steps involved in establishing a connection using jdbc in java?

525


What is database connection pooling? Advantages of using a connection pool?

543


How can I retrieve a String or other object type without creating a new object each time?

583


Explain some new features available in jdbc 4.0?

612


What are collection pools?

521






What is jdbc template?

525


How will you perform truncation using JDBC?

583


Is jdbc and orm?

503


What is a jdbctemplate?

527


How can I instantiate and load a new CachedRowSet object from a non-JDBC source?

536


What is a lock in jdbc?

545


What is jdbc driver for sql server?

542


Explain the process of creating tables using NetBeans IDE?

530


Under what circumstances, that all four drivers are used?

1907


What is the use of callablestatement? Name the method, which is used to prepare a callablestatement.

477