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
Is it possible to connect to multiple databases simultaneously? Using single statement can one update or extract data from multiple databases?
What does setautocommit do?
Does jpa use jdbc?
How can we disable a constraint ?
Write an sql to find all records having all numeric characters in a field ?
What is the meaning of connection?
What are types of resultset?
What is the purpose of jdbc?
What are the different types of locking in JDBC?
Why we use while rs next ())?
What do you mean by batch processing in jdbc?
What are the higher level apis under development on top of jdbc currently?
What is thin driver in jdbc?
How can I instantiate and load a new CachedRowSet object from a non-JDBC source?
What is jdbc and odbc?