I have an Oracle table that I am calling 82 columns using SQL and inserting into a Teradata table, which I created.

I think there is a limitation with the driver, if I do Commit every 1037 it works. If I do Commit every 1038 it FAILS.

Commit every 1,037 and Batch Size 10000 works.


I keep getting this message:
[statistics] connected
[Teradata JDBC Driver] [TeraJDBC 13.00.00.16] [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.
[statistics] disconnected


Exception Stack Trace:
An exception stack trace is not available.

Any suggestions? How do I use the getNextException?

eclipse.buildId=unknown
java.version=1.6.0_18
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en_US
Command-line arguments:  -os win32 -ws win32 -arch x86

Last edited by talendtester (2010-05-28 21:23:25)