ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From navrsale <navrsalem...@yahoo.ca>
Subject Re: getFailingSqlStatement()
Date Tue, 16 Jan 2007 02:12:21 GMT

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 <navrsalemile@yahoo.ca> 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.


Mime
View raw message