What is JDBC and ODBC and what are the differences between
them?
Answer Posted / srilatha
*ODBC is for microsoft & JDBC is for java applications
* ODBC can't be directly used with java because it uses a c
interface.
*ODBC makes use of pointers which have been
removed totally from java.
*ODBC is procedural-oriented & JDBC is Object-Oriented
*ODBC is used to provide connection between front-end and
back-end.JDBC is used to provide connection between java
and database.
*ODBC is language -independent&JDBC is language-dependent.
*ODBC mixes simple & advanced features together and has
complex options for simple queries.JDBC is designed to keep
things simple while allowing advanced capabilities when
required.
*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.
Is This Answer Correct ? | 38 Yes | 11 No |
Post New Answer View All Answers
What is the difference between setmaxrows(int) and setfetchsize(int)?
How to check jdbc connection in linux?
Are all the required JDBC drivers to establish connectivity to my database part of the JDK?
Does jdbctemplate use prepared statements?
What is drivermanager in jdbc?
What are the types of statements in jdbc?
What is the use of dialect?
What is com mysql jdbc driver?
What are types of resultset?
How many ways can you update a result set?
What is meant by jdbc and odbc?
What is the return type of class.forname() method?
How vendor Naming registry supports JNDI?
What is 2 phase commit?
What do you mean by odbc?