But if that is so, why do we have: int[] rowCounts = be.getBatchUpdateException().getUpdateCounts();
where be is BatchException My understanding is this will give all the "wrong" and "good" statements in a batch, will it not? (which means all the remaining statements in the batch will be attempted by the driver). Jeff Butler-2 wrote: > > Any failed statement ends the entire batch. If there is more than one > "sub > batch", everything is rolled back and nothing further is attempted. > > So there will only be one statement that kills the batch - the first one > that failed. > > Jeff Butler > > > > On 1/11/07, navrsale <[EMAIL PROTECTED]> wrote: >> >> >> hi all, >> >> if a single batch has a failed insert statement my understanding is that >> remaining statements in the batch will be attempted and then >> BatchException >> will be thrown? If in these remaining statements another statement(s) >> fails, >> how can we get all sql statements that failed in the same batch? I guess >> getFailingSqlStatement() returns only the first sql statement that failed >> in >> a batch? >> >> Many thanks, >> -- >> View this message in context: >> http://www.nabble.com/getFailingSqlStatement%28%29-tf2962806.html#a8289571 >> Sent from the iBATIS - User - Java mailing list archive at Nabble.com. >> >> > > -- View this message in context: http://www.nabble.com/getFailingSqlStatement%28%29-tf2962806.html#a8383318 Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
