ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ben Shory" <be...@sapiens.com>
Subject RE: gracefuly exit from row handler
Date Fri, 01 May 2009 06:22:04 GMT
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