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