Yes we have set the Auto Commit to true. Also we are not sure how many Queries we can execute as part of the Batch. We are trying to execute the Batch after 1000 Queries and then clear the batch and process the rest till we have none left. Thanks Sateesh Fabian Groffen wrote:
On 04-03-2010 09:27:31 -0800, sateesh wrote:
Hi All,
When we try to execute a Set of SQL Statements using executeBatch() and if one of the SQL Query fails then MonetDB seems to be ignoring the rest.
Is there a way we can configure MonetDB to execute the remaining SQL Queries in the Batch ??
Are you using autocommit mode?
------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- View this message in context: http://old.nabble.com/Java-executeBatch%28%29-behavior-tp27783879p27786287.h... Sent from the monetdb-users mailing list archive at Nabble.com.