How to Retrieve Warnings in JDBC?
Submitted by: AdministratorSQLWarning objects are a subclass of SQLException that deal with database access warnings. Warnings do not stop the execution of an application, as exceptions do; they simply alert the user that something did not happen as planned. A warning can be reported on a Connection object, a Statement object (including PreparedStatement and CallableStatement objects), or a ResultSet object. Each of these classes has a getWarnings method, which you must invoke in order to see the first warning reported on the calling object
E.g.
SQLWarning warning = stmt.getWarnings();
if (warning != null) {
while (warning != null) {
System.out.println(”Message: ” + warning.getMessage());
System.out.println(”SQLState: ” + warning.getSQLState());
System.out.print(”Vendor error code: “);
System.out.println(warning.getErrorCode());
warning = warning.getNextWarning();
}
}
Submitted by: Administrator
E.g.
SQLWarning warning = stmt.getWarnings();
if (warning != null) {
while (warning != null) {
System.out.println(”Message: ” + warning.getMessage());
System.out.println(”SQLState: ” + warning.getSQLState());
System.out.print(”Vendor error code: “);
System.out.println(warning.getErrorCode());
warning = warning.getNextWarning();
}
}
Submitted by: Administrator
Read Online JDBC Job Interview Questions And Answers
Top JDBC Questions
☺ | What Class.forName will do while loading drivers of JDBC? |
☺ | How can you load the drivers in JDBC? |
☺ | How to Make Updates to Updatable Result Sets in JDBC? |
☺ | How can you retrieve data from the ResultSet using JDBC? |
☺ | How to call a Stored Procedure from JDBC? |
Top Java Programming Language Categories
☺ | Core Java Interview Questions. |
☺ | Hibernate Interview Questions. |
☺ | Advanced Java Interview Questions. |
☺ | IBM WebSphere Interview Questions. |
☺ | Spring Framework Interview Questions. |