Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (athena.apache.org: domain of ellis.m.a@gmail.com
 designates 72.14.220.155 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type:content-transfer-encoding;
        b=H0dMWL6rH48qvzx9m0WeSaADflI07W1RDn/wO67Jz2eHukPiKawsHduSEGuCUc1fQC
         9mvKRTGLUiCD03MulLSeSu+DbEaHatEDQRYdx6VuJX//aup2j6TSz68+KmsHTyAxf1kj
         c92e2ONIJkG8hCycp2314t9xyJ/MkmJvH1tlE=
MIME-Version: 1.0
In-Reply-To: <D5CEF6814DD74C3CAE9554B04A261C94@UFOLMETTO.local>
References: <a54079f21002181027l7413e723u4679dc7755b4a0e9@mail.gmail.com>
	 <D5CEF6814DD74C3CAE9554B04A261C94@UFOLMETTO.local>
Date: Thu, 25 Feb 2010 10:22:05 +0000
Message-ID: <a54079f21002250222y44a8262fu567b37c09d4c6ede@mail.gmail.com>
Subject: Re: read large result set in Ibatis3
From: Martin Ellis <ellis.m.a@gmail.com>
To: user-java@ibatis.apache.org
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Hi Davide,

Did you see my other posts on this subject?
http://www.mail-archive.com/user-java@ibatis.apache.org/msg15588.html
http://www.mail-archive.com/user-java@ibatis.apache.org/msg15589.html

Perhaps that's what you're after?

Martin

On 25 February 2010 10:02, Davide Rogora <drogora@unionefiduciaria.it> wrot=
e:
> I agree with Martin.
> In my company we use iBatis and we appreciate both result mapping and dyn=
amic SQL features, but sometimes we only need dynamic SQL with direct acces=
s to the underlying jdbc cursor.
> For instance... we use JasperReports for report generation (and dynamic q=
ueries are very useful with reports), but we cannot use iBatis because we h=
ave memory issues (and bad performances) for large reports; it would be nic=
e if we could call a dynamic query and pass the underlying jdbc resultset t=
o JasperReports.
>
> Davide.
>
>
>
> -----Messaggio originale-----
> Da: Martin Ellis [mailto:ellis.m.a@gmail.com]
> Inviato: gioved=C3=AC 18 febbraio 2010 19.27
> A: user-java@ibatis.apache.org
> Oggetto: Re: read large result set in Ibatis3
>
>
>> On 2/18/2010 10:16 AM, Tom=C3=A1=C5=A1 Proch=C3=A1zka wrote:
>>> Ideal will be possibility to add method to mapper will return object
>>> on which I can call something like getNext(), hasNext() and close().
>
> On 18 February 2010 17:44, Guy Rouillier <guyr-ml1@burntmail.com> wrote:
>> That is very JDBC-ish. =C2=A0From my perspective, iBATIS attempts to hid=
e
>> all that so that the programmer can just deal with lists of objects.
>> ResultHandler lets you change how the list gets built. =C2=A0What you ar=
e
>> asking is for JDBC to be exposed again, something like
>> ResultSetHandler. =C2=A0I guess it would be possible to make that
>> pluggable, but then you are undoing much of the framework.
>
> Only the result handling side of the framework. =C2=A0You'd still have th=
e dynamic SQL, and parameter handling without it. =C2=A0That in itself is p=
robably enough incentive to use iBATIS.
>
> Martin
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
> For additional commands, e-mail: user-java-help@ibatis.apache.org
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
> For additional commands, e-mail: user-java-help@ibatis.apache.org
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org