with iBATIS
2.3.0, Oracle 10g, ojdbc14 driver.
Any pointers?
Thanks.
--
View this message in context:
http://www.nabble.com/Setting-fetchSize-tp15951032p15951032.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
> --
>> Regards
>> Gaurav Agarwal
>> Sun Microsystems Account, GTS
>> CSC India Pvt. Ltd.
>> Tel: +91 120 2582323 x3590 (India)
>> +1 302 781 1010 x3590 (US)
>> (M): +91 98106-17911
>>
>>
>
>
--
View this message in context:
http://www.nabble.com/Setting-FetchSize-in-iBatis-tf4212694.html#a12059704
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
On the tag you can set fetch size. See the DTD.
http://ibatis.apache.org/dtd/sql-map-2.dtd
Clinton
On 8/3/07, Gaurav Agarwal <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I just wanted to know, if we can set the fetchsize for queries in
> iBatis. I wanted to do so, as the for some of the reports the
Hi,
I just wanted to know, if we can set the fetchsize for queries in
iBatis. I wanted to do so, as the for some of the reports the query
retrieves 10,000+ records and I wanted to reduce the no. of trips
between appserver and db.
Any other suggestions are welcome!
--
Regards
Gaurav Agarwal
