Interested to Buy Any Domain ? << Click Here >> for more details...
what are the Different types of exceptions in JDBC?
- 1 Answers
- 15248 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 |
Once I have the Java 2 SDK, Standard Edition, from Sun, what else do I need to connect to a database?
Is jdbc secure?
How many ways can you update a result set?
Hi my doubt is that preparedStatement is a interface means which has no implemenation.plz go thru the code below String sql = "SELECT * FROM movies WHERE year_made = ?"; prest = con.prepareStatement(sql); prest.setInt(1,2002); ResultSet rs1 = prest.executeQuery(); Now setInt and executeQuery how it works since it is interface it does not have implementation how it works, how executeQuery returns result from database as executequery method has no implementation even in Statement interface.
4 Answers Cybermate, Hexaware,
How to create Connection interface object because it is Interface , Interface is not instansiated?
What do you understand by jdbc driver and explain its types?
Explain the sequence of steps to connect to the database?
DB2 Universal claims to support JDBC 2.0, But I can only get JDBC 1.0 functionality. What can I do?
Is jdbc database independent?
What is a lock in jdbc?
How can you load the drivers?
How to set NULL values in JDBC PreparedStatement?
Core Java 
