« Return to Thread: How to set Prefetch size on the resultSet level in IBATIS
RE: How to set Prefetch size on the resultSet level in IBATIS
by Raghavendran Chellappa
::
Rate this Message:
Some parts of this message have been removed.
Learn more about Nabble's security policy.
Many thanks Jeff.
Raghavendran Chellappa, ' Tel: +91 44 42002700
Ext: 3257
From: Jeff Butler
[mailto:jeffgbutler@...]
Sent: Friday, July 03, 2009 8:10
PM
To: dev@...
Subject: Re: How to set Prefetch
size on the resultSet level in IBATIS
If you feel you need this, then you could easily hack iBATIS to set the
fetch size on a result set. Add these lines to the beginning of the
handleResults method in com.ibatis.sqlmap.engine.execution.DefaultSqlExecuter:
Integer fetchSize =
statementScope.getStatement().getFetchSize();
if (fetchSize != null) {
rs.setFetchSize(fetchSize.intValue());
}
Before you ask, I'll state that we will probably not add this to the
official iBATIS2 code base. But this is the true beauty of open source -
you can modify the code to make it work the way you need it to work!
Jeff Butler
On Fri, Jul 3, 2009 at 9:20 AM, Raghavendran Chellappa <raghavendranc@...>
wrote:
Jeff,
Many thanks for your reply.
We are using iBATIS 2.3.0.
fetchSize set on StoredProcedure gets set on the
CallableStatement. But unfortunately does not get percolate to the ResultSet
when the application is running on Weblogic server.
A point to note is that we are running our application in the
same JVM as the weblogic server.
Thanks,
Raga
Raghavendran Chellappa, ' Tel: +91 44 42002700
Ext: 3257
From: Jeff Butler [mailto:jeffgbutler@...]
Sent: Friday, July 03, 2009 7:38
PM
To: dev@...
Subject: Re: How to set Prefetch size
on the resultSet level in IBATIS
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 <raghavendranc@...>
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. --------------------------------------------------------------------------------------------- |
---------------------------------------------------------------------------------------------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.--------------------------------------------------------------------------------------------- |
--------------------------------------------------------------------------------------------- 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. --------------------------------------------------------------------------------------------- |
« Return to Thread: How to set Prefetch size on the resultSet level in IBATIS
| Free embeddable forum powered by Nabble | Forum Help |
