Categories:
.NET (357)
C (330)
C++ (184)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (2)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How to Retrieve SQLWarning
How to Retrieve SQLWarning?
✍: FYICENTER.com
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.print("Message: ");
System.out.println(warning.getMessage());
System.out.print("SQLState: ");
System.out.println(warning.getSQLState());
System.out.print("Vendor error code: ");
System.out.println(warning.getErrorCode());
warning = warning.getNextWarning();
}
}
2007-04-03, 5605👍, 0💬
Popular Posts:
How do you pass control from one JSP page to another? Use the following ways to pass control of a re...
What is CodeDom? “CodeDom” is an object model which represents actually a source code. It is designe...
What are unadjusted function points and how is it calculated? Unadjusted function points = ILF + EIF...
What is Service Oriented architecture? “Services” are components which expose well defined interface...
How do you target a specific frame from a hyperlink? Include the name of the frame in the target att...