what are the Different types of exceptions in JDBC?
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 |
Explain the two tier and three tier architecture of jdbc.
What is <discriminator > in Hibernate? How exactly inheritance of Object to Tables can be done? What is the benefits of discriminator?
What is jdbc driver manager?
What is @entity in java?
What is the use of the statement in jdbc?
What is the different between ResultSet and RowSet?
What is use of connection pooling?
How you restrict a user to cut and paste from the html page using java programing?
How do I find ojdbc jar version?
What do you understand by jdbc datasource?
Why do we need jdbc driver?
What is jdbc? Describe the steps needed to execute a sql query using jdbc.