Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (herse.apache.org: domain of lists@nabble.com designates
 72.21.53.35 as permitted sender)
Message-ID: <8383318.post@talk.nabble.com>
Date: Mon, 15 Jan 2007 18:12:21 -0800 (PST)
From: navrsale <navrsalemile@yahoo.ca>
To: user-java@ibatis.apache.org
Subject: Re: getFailingSqlStatement()
In-Reply-To: <c593b8750701130611r1471843ds239461d2a7c9388c@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
References: <8289571.post@talk.nabble.com>
 <c593b8750701130611r1471843ds239461d2a7c9388c@mail.gmail.com>


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.