JSP Question:

Download Job Interview Questions and Answers PDF

How to Retrieve Warnings?

Java JSP Programming Interview Question
Java JSP Programming Interview Question

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


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


Download Java JSP Programming Interview Questions And Answers PDF

Previous QuestionNext Question
How many messaging models do JMS provide for and what are they? How many JSP scripting elements are there and what are they?