Friday, March 13, 2009

How to Retrieve Warnings (JDBC)

Question :How to Retrieve Warnings? (JDBC)
Answer :SQLWarning 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();
}
}

No comments: