Setting fetchSize

2008-03-10 Thread wiwohka
Trying to set fetchSize on calls to stored procedure in the SQL mapping file - procedure id=get parameterMap=get-param-map fetchSize=100 {call pkg.get_data(?,?,?,?,?, ?,?,?,?,?, ?,?)} /procedure But does not seem to affect. Smaller result set like 10 rows has

Re: Setting FetchSize in iBatis

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

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

Re: Setting FetchSize in iBatis

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

pgsql fetchsize

2007-03-08 Thread Chris Lamey
Hey all, I'm working on a quick and dirty app that unfortunately has to run on a machine with all of a gig of RAM with a decent size dataset (2M rows). I really want the 'fetchSize' attribute of the select element to work so my RowHandler runs lean and mean. The app basically issues a query up

fetchSize

2007-02-13 Thread Tushar Kherde
Hi All, I want to use fetchsize in my select query. Can I get sample for this. -- With regards Tushar Kherde

Re: fetchSize

2007-02-13 Thread Brandon Goodin
in Oracle. Brandon On 2/13/07, Tushar Kherde [EMAIL PROTECTED] wrote: Hi All, I want to use fetchsize in my select query. Can I get sample for this. -- With regards Tushar Kherde

Re: fetchSize

2007-02-13 Thread Clinton Begin
Actually it does! select ... fetchSize=50 Remember that it's just a hint though...not a guarantee IIRC. Clinton On 2/13/07, Brandon Goodin [EMAIL PROTECTED] wrote: iBATIS does not provide a means to use the setFetchSize on a PreparedStatement. If you are looking to limit the number of rows

Re: fetchSize

2007-02-13 Thread Brandon Goodin
Sorry for the bad info. Learn something new all the time. :-/ Brandon On 2/13/07, Clinton Begin [EMAIL PROTECTED] wrote: Actually it does! select ... fetchSize=50 Remember that it's just a hint though...not a guarantee IIRC. Clinton On 2/13/07, Brandon Goodin [EMAIL PROTECTED] wrote

Re: fetchSize

2007-02-13 Thread Tushar Kherde
I tried it with oracle 8i and driver jdbc14.jar but not working :( I just added the fetchSize=5 attribute in select element. Is there anything else i need to do please correct if i am wrong. I am using iBATIS2.0 ( Note: i was using iBATIS1.0 and upgraded just by changing jars ) If possible I need

Re: fetchSize

2007-02-13 Thread Clinton Begin
is ignored. The default value is zero. --- Clinton On 2/13/07, Tushar Kherde [EMAIL PROTECTED] wrote: I tried it with oracle 8i and driver jdbc14.jar but not working :( I just added the fetchSize=5 attribute in select element. Is there anything else i need to do please correct if i am wrong. I

Re: fetchSize

2007-02-13 Thread Tushar Kherde
but not working :( I just added the fetchSize=5 attribute in select element. Is there anything else i need to do please correct if i am wrong. I am using iBATIS2.0 ( Note: i was using iBATIS1.0 and upgraded just by changing jars ) If possible I need generic solution for this because my system

Re: fetchSize

2007-02-13 Thread Clinton Begin
is ignored. The default value is zero. --- Clinton On 2/13/07, Tushar Kherde [EMAIL PROTECTED] wrote: I tried it with oracle 8i and driver jdbc14.jar but not working :( I just added the fetchSize=5 attribute in select element. Is there anything else i need to do please

Re: fetchSize

2007-02-13 Thread Tushar Kherde
I have mentioned the fetchSize in select element Following is the code select fetchSize=5 id=ICE_COUNTRY.abatorgenerated_selectForIndex resultMap=abatorgenerated_IceCountryResult parameterClass=java.util.Map !-- WARNING - This element is automatically generated by Abator

Re: fetchSize

2007-02-13 Thread Clinton Begin
of the developer guide. Cheers, Clinton On 2/13/07, Tushar Kherde [EMAIL PROTECTED] wrote: I have mentioned the fetchSize in select element Following is the code select fetchSize=5 id=ICE_COUNTRY.abatorgenerated_selectForIndex resultMap=abatorgenerated_IceCountryResult parameterClass= java.util.Map

Re: fetchSize

2007-02-13 Thread Brandon Goodin
PROTECTED] wrote: I have mentioned the fetchSize in select element Following is the code select fetchSize=5 id=ICE_COUNTRY.abatorgenerated_selectForIndex resultMap=abatorgenerated_IceCountryResult parameterClass= java.util.Map !-- WARNING - This element is automatically generated

Re: fetchSize

2007-02-13 Thread Clinton Begin
, skipThisMany, getThisMany); Page 57 - 61 of the developer guide. Cheers, Clinton On 2/13/07, Tushar Kherde [EMAIL PROTECTED] wrote: I have mentioned the fetchSize in select element Following is the code select fetchSize=5 id=ICE_COUNTRY.abatorgenerated_selectForIndex resultMap

Re: fetchSize

2007-02-13 Thread Tushar Kherde
it returns at a time. What you want is: sqlMapClient.queryForList (findAllWhatevers, paramObj, skipThisMany, getThisMany); Page 57 - 61 of the developer guide. Cheers, Clinton On 2/13/07, Tushar Kherde [EMAIL PROTECTED] wrote: I have mentioned the fetchSize in select element

fetchSize

2006-10-16 Thread Brad Balmer
Is the fetchSize attribute used only for stored procedures? Is there a way to limit the number of rows brought back? -- ___ Brad Balmer Application Architect Peapod, Inc. 847-583-6306 This email may contain confidential or legally privileged information