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