what are the Different types of exceptions in JDBC?



what are the Different types of exceptions in JDBC?..

Answer / 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

More JDBC Interview Questions

How do I insert an image file (or other raw data) into a database?

0 Answers  


What is jdbc architecture in java?

0 Answers  


Which Java and java.sql data types map to my specific database types?

0 Answers  


What is jdbc dialect?

0 Answers  


Explain in detail about JDBC and its general features?

0 Answers  






What are the classes and methods used for sending sql statements to database?

0 Answers  


how to retrieve sql exceptions

2 Answers   Bosch,


What are devices?

0 Answers  


What are JDBC statements?

2 Answers  


Does JDBC support stored procedures?

0 Answers  


what is JDBC?

3 Answers   Wipro,


Discuss the procedure of retrieving warnings?

0 Answers  


Categories