JDBC error code list?

Connectivity

JDBC error code list?

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

3 REPLIES
Teradata Employee

Re: JDBC error code list?

Sorry, No, there is no such list.

Teradata Employee

Re: JDBC error code list?

My load process using ODI, that runs for a long time without any problem, has now suddenly the error 1338:

 [Teradata JDBC Driver] [TeraJDBC 14.00.00.21] [Error 1338] [SQLState HY000] A failure occurred while executing a PreparedStatement batch request. Details of the failure can be found in the exception chain that is accessible with getNextException.

Any idea?

Teradata Employee

Re: JDBC error code list?

The Teradata JDBC Driver User Guide discusses PreparedStatement batch error 1338 in this section:

http://developer.teradata.com/doc/connectivity/jdbc/reference/current/jdbcug_chapter_2.html#CCHJHFDI

ODI, like any application, should display or log the entire SQLException chain. The root cause of the problem will be indicated by a SQLException in the chain.

If ODI does not display the entire SQLException chain, then the root cause error condition could be observed in the debug log hex message dumps produced by the Teradata JDBC Driver's LOG=DEBUG connection parameter. Not recommended for repeated production usage, but it would work for troubleshooting a one-time problem.