ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jose Lora <Jose.L...@meredith.com>
Subject RE: gracefuly exit from row handler
Date Fri, 01 May 2009 11:55:53 GMT
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 <ben.s@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 <ben.s@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

 

 


Mime
View raw message