SQLJ clauses use the JDBC class java.sql.SQLException for
error handling.
To handle SQL errors in SQLJ applications, following
these steps:
- Import the java.sql.SQLException class.
- Use the Java™ error
handling try/catch blocks to modify program flow
when an SQL error occurs.
- Obtain error information from the SQLException.
You can use the getErrorCode method to
retrieve SQL error codes and the getSQLState method
to retrieve SQLSTATEs.
If you are using the IBM® Data Server Driver for JDBC and SQLJ,
obtain additional information from the SQLException by
casting it to a DB2Diagnosable object, in the same
way that you obtain this information in a JDBC application.
For the DB2® JDBC
Type 2 Driver for Linux, UNIX and Windows (DB2 JDBC
Type 2 Driver), use the standard SQLException to
retrieve SQL error information.
The following code prints out the SQL error that occurred
if a SELECT statement fails.
try {
#sql [ctxt] {SELECT LASTNAME INTO :empname
FROM EMPLOYEE WHERE EMPNO='000010'};
}
catch(SQLException e) {
System.out.println("Error code returned: " + e.getErrorCode());
}