Re: Setting FetchSize in iBatis

2007-08-08 Thread Joe ONeil
> -- >> 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.

Re: Setting FetchSize in iBatis

2007-08-03 Thread Clinton Begin
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

Setting FetchSize in iBatis

2007-08-03 Thread Gaurav Agarwal
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