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 <[EMAIL PROTECTED]>
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 <[EMAIL PROTECTED]>
> wrote:
>
>> No, iBATIS does not cache out params.
>>
>> On Wed, Jun 18, 2008 at 9:29 AM, Sundar Sankar <[EMAIL PROTECTED]>
>> 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 <[EMAIL PROTECTED]>
>>> 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
>>>>
>>>>
>>>
>>
>
