What version of iBATIS are you using? With versions 2.2.0 and later, iBATIS will set the fetchSize on stored procedure calls - and that should translate to the result set (according to the JDBC spec). iBATIS does not support setting the fetchSize directly on a result set.
Jeff Butler On Thu, Jul 2, 2009 at 11:28 PM, Raghavendran Chellappa < raghavendr...@virtusa.com> wrote: > Hi, > > We are having issues with the "prefetchSize" property that is available at > the "procedure" element (of ibatis sqlmap). Even though we set the prefetch > size to a value, say 100, ibatis ignores this and always defaults to 10 > (jdbc driver default). Also our application is a weblogic based J2EE app > running in the same JVM as the weblogic server. Hence the prefetchSize set > on the callableStatement will not work. > But prefetchSize set on the resultSet level will work perfectly(after > getting the resultSet from the callableStatementt). > > Hence, in IBatis we need to set the prefetchSize at the resultSet level > while executing a storedproc. > We dont seem to find a way to do this in ibatis at the moment. > > Is this a limitation/bug or is there a way around this? > > Any help here will be much appreciated. > > thanks, > Raga > > > > > > --------------------------------------------------------------------------------------------- > > This message, including any attachments, contains confidential information > intended for a specific individual and purpose, and is intended for the > addressee only. Any unauthorized disclosure, use, dissemination, copying, or > distribution of this message or any of its attachments or the information > contained in this e-mail, or the taking of any action based on it, is > strictly prohibited. If you are not the intended recipient, please notify the > sender immediately by return e-mail and delete this message. > > --------------------------------------------------------------------------------------------- > >
