Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
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, 5377👍, 0💬
Popular Posts:
1. The basics first, please define the web in simple language? How is it connected with internet? Wh...
How can I use tables to structure forms Small forms are sometimes placed within a TD element within ...
How can we implement singleton pattern in .NET? Singleton pattern mainly focuses on having one and o...
what are the advantages of hosting WCF Services in IIS as compared to self hosting? There are two ma...
Give me the example of SRS and FRS SRS :- Software Requirement Specification BRS :- Basic Requiremen...