what are the Different types of exceptions in JDBC?

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.

Is This Answer Correct ?    9 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which database is used with java?

743


How do we load the drivers?

756


Explain some new features available in jdbc 4.0?

808


What does connection pooling mean ?

780


Why can't Tomcat find my Oracle JDBC drivers in classes111.zip?

772


Which jdbc drivers will run your program?

715


How can you know about drivers and database information ?

767


What are the differences between statement and preparedstatement interface?

768


What are the exceptions in jdbc?

712


What isolation level is used by the DBMS when inserting, updating and selecting rows from a database?

748


What is jdbc driver manager?

722


What is the use of getGeneratedKeys() method in Statement?

793


What protocol does jdbc use?

755


What are the different types of statements in jdbc?

716


What is the use of jdbc?

790