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 >> > >
