ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sundar Sankar" <fatboys...@gmail.com>
Subject Re: Caching not working
Date Wed, 18 Jun 2008 16:12:24 GMT
Thanks Clinton. Was there a reason not to include this as part of the cache
configs? Would we be seeing this feature any time soon?


On Wed, Jun 18, 2008 at 8:33 AM, Clinton Begin <clinton.begin@gmail.com>
wrote:

> No, iBATIS does not cache out params.
>
> On Wed, Jun 18, 2008 at 9:29 AM, Sundar Sankar <fatboysuns@gmail.com>
> wrote:
>
>> Just following up on the question. Doesnt Ibatis cache out params of
>> stored procs. If it does, whats the way to do it.?
>>
>>
>> On Tue, Jun 17, 2008 at 5:07 PM, Sundar Sankar <fatboysuns@gmail.com>
>> wrote:
>>
>>> Hi,
>>>        I tried to cache the data returned by my stored proc and I am
>>> seeing that the data fetched from the procedure is not cached at all. Am I
>>> doing wrong here. I tried to use OSCache and Memory. Both dont seem to work
>>> at all for me.
>>>
>>> My configurations are
>>>
>>> <cacheModel id="oscache" type="OSCACHE">
>>>             <flushInterval hours="24"/>
>>>         </cacheModel>
>>>         <cacheModel id="memory-cache" type="MEMORY">
>>>             <flushInterval hours="24"/>
>>>         </cacheModel>
>>>
>>> <procedure id="something"
>>>         parameterMap="someParam" cacheModel="oscache">
>>>         {? = call someProc}
>>>     </procedure>
>>>
>>> My oscache.properties is fairly simple and has
>>>
>>> cache.memory=true
>>> #cache.capacity=1000
>>> #cache.algorithm=com.opensymphony.oscache.base.algorithm.UnlimitedCache
>>> cache.use.host.domain.in.key=true
>>> cache.path=c:\\Sundar\\cache
>>>
>>> ###################################################
>>>
>>> My debug statements are
>>>
>>> 2008-06-17 16:49:53,148 DEBUG [com.ibatis.sqlmap.engine.cache.CacheModel]
>>> Cache 'oscache': *cache miss*
>>> 2008-06-17 16:49:53,148 DEBUG [java.sql.Connection] {conn-100019}
>>> Preparing Call: {? = call someProc}
>>> 2008-06-17 16:49:53,179 DEBUG [java.sql.PreparedStatement] {pstm-100020}
>>> Executing Statement: {? = call someProc}
>>> 2008-06-17 16:49:53,179 DEBUG [java.sql.PreparedStatement] {pstm-100020}
>>> Parameters: []
>>> 2008-06-17 16:49:53,179 DEBUG [java.sql.PreparedStatement] {pstm-100020}
>>> Types: []
>>> 2008-06-17 16:49:53,195 DEBUG [com.ibatis.sqlmap.engine.cache.CacheModel]
>>> *Cache 'oscache': stored object '[]'*
>>>
>>>
>>> Dont know what I am doing wrong. I tried changing the congiguration to
>>> point to the memory-cache config I have. Still yeilds the same results. Any
>>> help on this is greatly appreciated.
>>>
>>> Regards
>>> Sundar Sankarnarayanan
>>>
>>>
>>
>

Mime
View raw message