Answer Posted / venu gopal.c t.c.s

Exceptions in JDBC are usually of two types:

Exceptions occurring in the JDBC driver

Exceptions occurring in the Oracle 8i database itself

Just as PL/SQL provides for an implicit or explicit RAISE
statement for an exception, Oracle JDBC programs have a
throw statement that is used to inform that JDBC calls
throw the SQL exceptions. This is shown below.

throws SQLException
This creates instances of the class java.sql.SQLException
or a subclass of it.

And, like in PL/SQL, SQL exceptions in JDBC have to be
handled explicitly. Similar to PL/SQL exception handling
sections, Java provides a try..catch section that can
handle all exceptions including SQL exceptions. Handling an
exception can basically include retrieving the error code,
error text, the SQL state, and/or printing the error stack
trace. The SQLException class provides methods for
obtaining all of this information in case of error
conditions.

What are the main components of JDBC ?

1004

---

What is execute in java?

915

---

Where is mysql jdbc driver located?

962

---

Is it possible to connect to multiple databases simultaneously?

994

---

Differentiate between a statement and a preparedstatement.

931

---

Under what circumstances, that all four drivers are used?

2362

---

What are the different types of interfaces in the api component?

915

---

What is the role of the jdbc drivermanager class?

881

---

How can I use the JDBC API to access a desktop database like Microsoft Access over the network?

962

---

What is drivermanager in java?

881

---

Which is best database for java?

924

---

Can I use JDBC to execute non-standard features that my DBMS provides?

930

---

List some new features available in jdbc 4.0?

870

---

How do I find jdbc version?

950

---

What does adapter class provide?

877

---