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.

Why do we use jdbc statements?

897

---

Compare jdbc and odbc and how is jdbc required in this context.

870

---

What is the significance of DataBaseMetaData.tableIndexStatistics? How to obtain and use it?

930

---

How do I receive a ResultSet from a stored procedure?

909

---

How do I retrieve a whole row of data at once, instead of calling an individual ResultSet.getXXX method for each column?

1014

---

DB2 Universal claims to support JDBC 2.0, But I can only get JDBC 1.0 functionality. What can I do?

913

---

How do I stop nullpointerexception?

908

---

What is the different between ResultSet and RowSet?

953

---

How do I set properties for a JDBC driver and where are the properties stored?

901

---

How can I manage special characters when I execute an insert query?

897

---

How to invoke Oracle Stored Procedure with Database Objects as IN/OUT?

1011

---

Which is faster jdbc or odbc?

845

---

Which database is used for java?

905

---

What is difference between jdbc and odbc?

944

---

State the three different ways in which you can create a table?

908

---