0 - 5 of 5 tags for sqlexception

The following batches 5 rows of data, 2 of them with errors. The JDBC FastLoad PreparedStatement.executeBatch attempts to INSERT the batched rows into a database table but throws a JDBC SQLException. Here is how to capture the chain of JDBC FastLoad SQLException messages and stack trace from JDBC FastLoad PreparedStatement.executeBatch and the chain of JDBC FastLoad SQLWarning messages and stack trace from JDBC FastLoad Connection.rollback:

The following batches 5 rows of data, 2 of them with errors. The JDBC PreparedStatement.executeBatch attempts to INSERT the batched rows into a database table but throws a JDBC SQLException. Here is how to capture the chain of JDBC SQLException error messages and stack trace:

Is there a list of error codes (and the associated messages) of all the SQLExceptions that the Teradata JDBC driver throws? I can't find it anywhere in the documentation...
Thanks,
Jan
 

Hello,
I wrote a pretty simple code to test exception handling, and it works as expected, but when I tried to run the same code in a different (same-level) database, it does not work.
Here is the procedure, which takes divisor as parameter, and generates record in a table if divisor = 0 :
REPLACE PROCEDURE SP_TEST (IN divisor INT, OUT answer INT, OUT retString CHAR(1), OUT errNum INT)
BEGIN
DECLARE procName VARCHAR(100);
DECLARE processDate DATE;
DECLARE errNumber INT;
DECLARE errCode CHAR(5);

DECLARE EXIT HANDLER FOR SQLEXCEPTION
BEGIN
SET answer = 0;