ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Clinton Begin" <clinton.be...@gmail.com>
Subject Re: Caching not working
Date Wed, 18 Jun 2008 16:21:57 GMT
Possibly in iBATIS 3, doubtful that it will ever be in 2.x.  There's no
reason it was left out, it's just an omission.

Clinton

On Wed, Jun 18, 2008 at 10:12 AM, Sundar Sankar <fatboysuns@gmail.com>
wrote:

> 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