sotred proc is not an option. actually i'm porting a db2 stored proc batch app to java - spring batch - ibatis. ok, let's say i'm processing milions of rows and counting errors.. if i reach 1k errors i want to quit. i can use paging instead of row handler but a. it has a performance impact and b. i need to change the sql statements and also make them vendor specific.
________________________________ From: Sundar Sankar [mailto:fatboys...@gmail.com] Sent: Thursday, April 30, 2009 7:11 PM To: user-java@ibatis.apache.org Subject: Re: gracefuly exit from row handler I would have used a stored proc or something to do that in the DB itself. Personally I dont wanna transfer a million records over the network and then do some logic to fetch one out of it. I dont know what your situation is, may be if you explain more, there might be a more elegant way, some of the users might have for u! -Sundar On Thu, Apr 30, 2009 at 8:57 AM, Ben Shory <be...@sapiens.com> wrote: not really.. i need to choose one row out of milions using logic involving other data sources. ________________________________ From: Clinton Begin [mailto:clinton.be...@gmail.com] Sent: Thursday, April 30, 2009 3:58 PM To: user-java@ibatis.apache.org Subject: Re: gracefuly exit from row handler Not really... but why are you asking for data you don't need? Is there any way to just select out exactly what you need? On Thu, Apr 30, 2009 at 2:20 AM, Ben Shory <be...@sapiens.com> wrote: Hi, any way of breaking from row handler if I don't need to traverse the results anymore? if I throw runtime exception will it handle the resources correctly? --ben
