How to retrieve warnings of SQL ?

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 seethe first warning reported on the calling object.

Example

SQLWarning warning = statement.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: " + warning.getErrorCode());

    warning = warning.getNextWarning();

   }

}