All Forums Connectivity
jan.simecka 4 posts Joined 01/13
10 Jul 2013
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
 

tomnolan 594 posts Joined 01/08
10 Jul 2013

Sorry, No, there is no such list.

hyma 33 posts Joined 07/11
04 Aug 2013

 
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?

tomnolan 594 posts Joined 01/08
05 Aug 2013

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.

You must sign in to leave a comment.