You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by Sundar Sankar <fa...@gmail.com> on 2008/06/18 02:07:34 UTC
Caching not working
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
Re: Caching not working
Posted by Clinton Begin <cl...@gmail.com>.
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 <fa...@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 <cl...@gmail.com>
> wrote:
>
>> No, iBATIS does not cache out params.
>>
>> On Wed, Jun 18, 2008 at 9:29 AM, Sundar Sankar <fa...@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 <fa...@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
>>>>
>>>>
>>>
>>
>
Re: Caching not working
Posted by Sundar Sankar <fa...@gmail.com>.
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 <cl...@gmail.com>
wrote:
> No, iBATIS does not cache out params.
>
> On Wed, Jun 18, 2008 at 9:29 AM, Sundar Sankar <fa...@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 <fa...@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
>>>
>>>
>>
>
Re: Caching not working
Posted by Clinton Begin <cl...@gmail.com>.
No, iBATIS does not cache out params.
On Wed, Jun 18, 2008 at 9:29 AM, Sundar Sankar <fa...@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 <fa...@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
>>
>>
>
Re: Caching not working
Posted by Sundar Sankar <fa...@gmail.com>.
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 <fa...@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
>
>