RE: how to map huge resultsets?

2007-10-04 Thread robert.kasanicky
:[EMAIL PROTECTED] On Behalf Of Larry Meadors Sent: Thursday, October 04, 2007 01:18 To: user-java@ibatis.apache.org Subject: Re: how to map huge resultsets? I'm confused, how would grabbing chunks of a huge result set be more efficient than grabbing the records by PK? Couldn't you just have a select

Re: how to map huge resultsets?

2007-10-04 Thread Jeff Butler
: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Larry Meadors Sent: Thursday, October 04, 2007 01:18 To: user-java@ibatis.apache.org Subject: Re: how to map huge resultsets? I'm confused, how would grabbing chunks of a huge result set be more efficient than grabbing the records by PK

RE: how to map huge resultsets?

2007-10-04 Thread robert.kasanicky
, xml, database). Robert -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Larry Meadors Sent: Thursday, October 04, 2007 15:55 To: user-java@ibatis.apache.org Subject: Re: how to map huge resultsets? So does the Spring-Batch framework only process Lists

Re: how to map huge resultsets?

2007-10-04 Thread Larry Meadors
be a valuable addition. Robert From: Jeff Butler [mailto:[EMAIL PROTECTED] Sent: Thursday, October 04, 2007 14:15 To: user-java@ibatis.apache.org Subject: Re: how to map huge resultsets? Your question is not that confusing. Here

Re: how to map huge resultsets?

2007-10-04 Thread Christopher Lamey
04, 2007 8:43 PM To: user-java@ibatis.apache.org Subject: RE: how to map huge resultsets? Thanks for the insights Jeff. Shifting a paradigm and letting iBATIS control the flow is not an option this case, but I think iBATIS can still be used in a slightly different driving query

RE: how to map huge resultsets?

2007-10-04 Thread robert.kasanicky
@ibatis.apache.org Subject: Re: how to map huge resultsets? I think the issue is that the RowHandler would need to call back to the framework code, which might decide to not continue processing or roll the transaction back or do any number of things. My guess is that this loop: while

Re: how to map huge resultsets?

2007-10-03 Thread Christopher Lamey
-Original Message- From: Christopher Lamey [mailto:[EMAIL PROTECTED] Sent: Wed 10/3/2007 11:06 PM To: user-java@ibatis.apache.org Subject: Re: how to map huge resultsets? Hello, You should take a look at the RowHandler interface and the queryWithRowHandler calls in SqlMapClient (page 61

RE: how to map huge resultsets?

2007-10-03 Thread robert.kasanicky
@ibatis.apache.org Subject: Re: how to map huge resultsets? Hmm...I don't see how having an external framework prevents you from using a RowHandler. Your item provider could implement the RowHandler interface and the external code wouldn't know or care about it. Or your item provider could wrap something

Re: how to map huge resultsets?

2007-10-03 Thread Christopher Lamey
- From: Christopher Lamey [mailto:[EMAIL PROTECTED] Sent: Wed 10/3/2007 11:55 PM To: user-java@ibatis.apache.org Subject: Re: how to map huge resultsets? Hmm...I don't see how having an external framework prevents you from using a RowHandler. Your item provider could implement

Re: how to map huge resultsets?

2007-10-03 Thread Larry Meadors
Subject: Re: how to map huge resultsets? Hmm...I don't see how having an external framework prevents you from using a RowHandler. Your item provider could implement the RowHandler interface and the external code wouldn't know or care about it. Or your item provider could wrap something that does