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, Sankar -- View this message in context: http://www.nabble.com/How-to-set-Prefetch-size-on-the-resultSet-level-in-IBATIS-tp24305631p24305631.html Sent from the iBATIS - User - Java mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org
