You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by Ben Shory <be...@sapiens.com> on 2009/04/30 10:20:22 UTC
gracefuly exit from row handler
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
RE: gracefuly exit from row handler
Posted by Jose Lora <Jo...@meredith.com>.
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:ben.s@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:fatboysuns@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.begin@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
RE: gracefuly exit from row handler
Posted by Ben Shory <be...@sapiens.com>.
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:fatboysuns@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.begin@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
Re: gracefuly exit from row handler
Posted by Sundar Sankar <fa...@gmail.com>.
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.begin@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
>>
>
>
RE: gracefuly exit from row handler
Posted by Ben Shory <be...@sapiens.com>.
not really.. i need to choose one row out of milions using logic
involving other data sources.
________________________________
From: Clinton Begin [mailto:clinton.begin@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
Re: gracefuly exit from row handler
Posted by Clinton Begin <cl...@gmail.com>.
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
>