You are not logged in.
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:
[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.
Exception Stack Trace:
An exception stack trace is not available.
Any suggestions? How do I use the getNextException?
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)