Is there any way you can move the error checking logic to the database instead of running it on the java server? If you need data from other systems to perform the error checking process, it may be better for you to temporarily move that data to DB2. To move the data across you could use database specific exporters and loaders to make the process more efficient. If you can do that, then it may be possible for you to code your error checking logic in SQL.
Just an idea. Tonio From: Ben Shory [mailto:be...@sapiens.com] Sent: Friday, May 01, 2009 2:22 AM To: user-java@ibatis.apache.org Subject: RE: gracefuly exit from row handler 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