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
Explain about DSN?
What is batch processing and how to perform batch processing in jdbc?
What is java soft framework?
What is the difference between setmaxrows(int) and setfetchsize(int)?
How can I write to the log used by DriverManager and JDBC drivers?
What is resultset in jdbc with example?
Under what circumstances, that all four drivers are used?
What is jdbc architecture?
Is jdbctemplate thread safe?
Why would you use setautocommit(false) in jdbc?
How can we execute stored procedures using callablestatement?
What is JDBC RowSet? What are different types of RowSet?
What is setautocommit in jdbc?
What is the jdbc rowset?
What is namedparameterjdbctemplate?