Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 34416 invoked from network); 4 Jan 2007 20:03:56 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 4 Jan 2007 20:03:56 -0000 Received: (qmail 47059 invoked by uid 500); 4 Jan 2007 20:04:00 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 47041 invoked by uid 500); 4 Jan 2007 20:04:00 -0000 Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user-java@ibatis.apache.org Delivered-To: mailing list user-java@ibatis.apache.org Received: (qmail 47030 invoked by uid 99); 4 Jan 2007 20:04:00 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 04 Jan 2007 12:04:00 -0800 X-ASF-Spam-Status: No, hits=4.8 required=10.0 tests=DNS_FROM_RFC_ABUSE,DNS_FROM_RFC_POST,DNS_FROM_RFC_WHOIS,HTML_MESSAGE X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: local policy) Received: from [66.196.100.242] (HELO web58909.mail.re1.yahoo.com) (66.196.100.242) by apache.org (qpsmtpd/0.29) with SMTP; Thu, 04 Jan 2007 12:03:49 -0800 Received: (qmail 22365 invoked by uid 60001); 4 Jan 2007 20:02:28 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=h4/EkDwwHRGdG1lCvv8bzTfJEqwPgTh52/T34VJ8/T7s+9+Fe2/yia2JWsweowMDJhE9y22IW1r1H5Z8njicOXEh/0fbdo8rUTTo0D/ofm+R9kTQkqddAHD87OdHZ7upw4oiZOhecZa6aDcbJYMjGSra2DphyzwSrhUssySEA0A=; X-YMail-OSG: i.5QpqAVM1no_H9vF.2AmtjJb6IGvPE0w68fkVRF Received: from [72.75.161.162] by web58909.mail.re1.yahoo.com via HTTP; Thu, 04 Jan 2007 12:02:26 PST Date: Thu, 4 Jan 2007 12:02:26 -0800 (PST) From: Tegan Clark Subject: RE: Getting straight at the ResultSet To: user-java@ibatis.apache.org In-Reply-To: <006401c7302c$3c1398c0$b43aca40$@mccarthy@propylon.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-300026119-1167940946=:20990" Content-Transfer-Encoding: 8bit Message-ID: <248689.20990.qm@web58909.mail.re1.yahoo.com> X-Virus-Checked: Checked by ClamAV on apache.org --0-300026119-1167940946=:20990 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Damien/Larry, Thanks for the reply. I've looked at RowHandler, and unless I'm missing something iBATIS is still controlling the iteration and passing me a Map of the underlying data, i.e. iBATIS first incures the overhead of adapting the ResultSet to the Map, and then I must implement some sought of buffer to hold the returned results (unless I implement some sought of callback out of my DAL). Do my assumptions above sound correct? There's no way to map the ResultSet straight back? i.e: ResultSet res = (ResultSet ) sqlClient.queryForObject(); Thanks again. Tegan Damien McCarthy wrote: Hi Tegan, I think the RowHandler interface will provide the functionality you need, this will allow you to iterate the objects. Take a look in p61 of the developer handbook for a nice example Damien. Ps. The Handbook is at : http://ibatis.apache.org/docs/java/pdf/iBATIS-SqlMaps-2_en.pdf From: Tegan Clark [mailto:tegan.clark@yahoo.com] Sent: 04 January 2007 16:21 To: user-java@ibatis.apache.org Subject: Getting straight at the ResultSet Hi group; I was wondering if there is any way to receive the ResultSet back straight from iBATIS, i.e. allow iBATIS to do the mapping on the way in, but let me manipulate the ResultSet directly on the way out. I have a framework that uses iBATIS to product "no-code" reports (just the xml). Some of those reports can stretch to 100,000's or records though so are better suited to an iterator approach and non-reflective mapping. If it can't be done, is this something iBATIS would be interested in having contributed? All help greatly appreciated. Thanks. Tegan __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com --0-300026119-1167940946=:20990 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit
Damien/Larry,
 
Thanks for the reply.  I've looked at RowHandler, and unless I'm missing something iBATIS is still controlling the iteration and passing me a Map of the underlying data, i.e. iBATIS first incures the overhead of adapting the ResultSet to the Map, and then I must implement some sought of buffer to hold the returned results (unless I implement some sought of callback out of my DAL).
 
Do my assumptions above sound correct?
 
There's no way to map the ResultSet straight back? i.e:
 
   ResultSet res = (ResultSet ) sqlClient.queryForObject();
 
Thanks again.
 
Tegan
 

Damien McCarthy <damien.mccarthy@propylon.com> wrote:
Hi Tegan,
 
I think the RowHandler interface will provide the functionality you need, this will allow you to iterate the objects.
 
Take a look in p61 of the developer handbook for a nice example
 
Damien.
 
Ps. The Handbook is at : http://ibatis.apache.org/docs/java/pdf/iBATIS-SqlMaps-2_en.pdf
 
 
From: Tegan Clark [mailto:tegan.clark@yahoo.com]
Sent: 04 January 2007 16:21
To: user-java@ibatis.apache.org
Subject: Getting straight at the ResultSet
 
Hi group;
 
I was wondering if there is any way to receive the ResultSet back straight from iBATIS, i.e. allow iBATIS to do the mapping on the way in, but let me manipulate the ResultSet directly on the way out.
 
I have a framework that uses iBATIS to product "no-code" reports (just the xml).  Some of those reports can stretch to 100,000's or records though so are better suited to an iterator approach and non-reflective mapping.
 
If it can't be done, is this something iBATIS would be interested in having contributed?
 
All help greatly appreciated.  Thanks.
 
Tegan
 __________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com --0-300026119-1167940946=:20990--