Interested to Buy Any Domain ? << Click Here >> for more details...
what are the Different types of exceptions in JDBC?
- 1 Answers
- 15129 Views
- I also Faced
- E-Mail Answers
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 |
Which Driver is preferable for using JDBC API in Applets?
Different statements in JDBC?
How are jdbc statements used?
What are the differences between execute, executequery, and executeupdate?
Why would you use setautocommit(false) in jdbc?
Difference between Generic Servlet and HTTP Servlet?
What is executequery in java?
How does a file store compare with a jdbc store?
Can resultset be null in java?
Write an sql to find all records having all numeric characters in a field ?
code to insert values/rows into oracle database from a java swing textfield when a button is pressed(using preparedstatements)
What is the difference between Minus, and Intersect?
Core Java 
