Error: A failure occurred while executing a PreparedStatement batch
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:
connected 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. 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
