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 objectE.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();}}

 

This Question is not yet answered!

 
 

Related Answered Questions

 

Related Open Questions