How to Retrieve Warnings | Eklavya Online

How to Retrieve Warnings

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

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();

}

}