https://community.qlik.com/t5/Talend-Studio/Error-A-failure-occurred-while-executing-a-PreparedStatement/m-p/2296735#M69364 <B>I have an Oracle table that I am calling 82 columns using SQL and inserting into a Teradata table, which I created.</B> <BR />I think there is a limitation with the driver, if I do Commit every <B>1037</B> it works. If I do Commit every <B>1038</B> it FAILS. <BR />Commit every <B>1,037</B> and Batch Size <B>10000</B> works. <BR /> <BR />I keep getting this message: <BR /> <B> connected<BR /> 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.<BR /> disconnected<BR /></B> <BR />Exception Stack Trace: <BR />An exception stack trace is not available. <BR /> <B>Any suggestions? How do I use the getNextException?</B> <BR />eclipse.buildId=unknown <BR />java.version=1.6.0_18 <BR />java.vendor=Sun Microsystems Inc. <BR />BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en_US <BR />Command-line arguments: -os win32 -ws win32 -arch x86 Sat, 16 Nov 2024 13:24:59 GMT talendtester 2024-11-16T13:24:59Z https://community.qlik.com/t5/Talend-Studio/Error-A-failure-occurred-while-executing-a-PreparedStatement/m-p/2296735#M69364 <B>I have an Oracle table that I am calling 82 columns using SQL and inserting into a Teradata table, which I created.</B> <BR />I think there is a limitation with the driver, if I do Commit every <B>1037</B> it works. If I do Commit every <B>1038</B> it FAILS. <BR />Commit every <B>1,037</B> and Batch Size <B>10000</B> works. <BR /> <BR />I keep getting this message: <BR /> <B> connected<BR /> 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.<BR /> disconnected<BR /></B> <BR />Exception Stack Trace: <BR />An exception stack trace is not available. <BR /> <B>Any suggestions? How do I use the getNextException?</B> <BR />eclipse.buildId=unknown <BR />java.version=1.6.0_18 <BR />java.vendor=Sun Microsystems Inc. <BR />BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en_US <BR />Command-line arguments: -os win32 -ws win32 -arch x86 Sat, 16 Nov 2024 13:24:59 GMT https://community.qlik.com/t5/Talend-Studio/Error-A-failure-occurred-while-executing-a-PreparedStatement/m-p/2296735#M69364 talendtester 2024-11-16T13:24:59Z