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
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
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
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
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
Hi All,
I want to use fetchsize in my select query.
Can I get sample for this.
--
With regards
Tushar Kherde
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
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
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
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
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
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
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
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
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
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
, 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
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
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
19 matches
Mail list logo