You're using an 8 year old database and a 5 year old driver. :-)
The combination may not support fetch size properly. Furthermore, even if it is supported by the driver, it is not guaranteed to fetch exactly that number of rows. The following is an excerpt from the JDK JavaDoc for PreparedStatement.setFetchSize() --------------- Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed. The number of rows specified affects only result sets created using this statement. If the value specified is zero, then the hint 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 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 dealing with different databases. Thanks in advance. On 2/13/07, Brandon Goodin <[EMAIL PROTECTED]> wrote: > 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: > > > iBATIS does not provide a means to use the setFetchSize on a > > > PreparedStatement. If you are looking to limit the number of rows you get > > > back from the database then I suggest using queryForList(id, parmObject, > > > skip, max) or placing it in your SQL statement like "select * from foo where > > > rownum<10" 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 > > > > > > > > > > -- With regards Tushar Kherde
