Interested to Buy Any Domain ? << Click Here >> for more details...
what are the Different types of exceptions in JDBC?
- 1 Answers
- 15130 Views
- I also Faced
- E-Mail Answers
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
What is JDBC PreparedStatement?
What is a jdbc connection pool?
What is jdbc odbc in java?
Why jdbc is used in java?
What should be done for auto generating primary key id in a table ?
What is the benefit of having jdbcrowset implementation? Why do we need a jdbcrowset like wrapper around resultset?
Give a way to check that all result sets have bin accessed and update counts are generated by execute method.
How the JDBC application works?
What is the use of jdbc?
How to rollback a JDBC transaction?
What is jdbc and its advantages?
Explain how data flows from view to db and reverse
What is jdbc oracle thin?
Briefly tell about the jdbc architecture.
What is sqlwarning?
