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
What are JDBC Best Practices?
What happens if connection is not closed in jdbc?
Can resultset be null in java?
What is a jdbctemplate?
What is execute in java?
What is the execute method in java?
How do I stop nullpointerexception?
What are the different classes through which JDBC represents statements?
How to invoke Oracle Stored Procedure with Database Objects as IN/OUT?
How many jdbc driver types are there?
What is jdbc odbc?
How to achieve JDBC Connection Pooling using JDBC DataSource and JNDI in Apache Tomcat Server?
What is batch processing and how to perform batch processing in jdbc?
Compare jdbc and odbc and how is jdbc required in this context.
What is setautocommit in jdbc?