Another method you can use is
@SuppressWarnings("unchecked")
public List<StockItemsVw> selectByExampleRange(StockItemsVwExample
example,int start,int
maxRows) {
List<StockItemsVw> list = (List<StockItemsVw>)
getSqlMapClientTemplate().queryForList
("DWOWNER_STOCK_ITEMS_VW.abatorgenerated_selectByExample",
example,start,maxRows);
return list;
}
Start is where the query start record is and maxRows is the fetch size.
This is places in the DAOImpl class.
you can create a more button by increasing the start ie start=start+50;
Clinton Begin wrote:
>
> On the <select> 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 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
>> 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.
