You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ibatis.apache.org by "gopal.narayanan (JIRA)" <ib...@incubator.apache.org> on 2005/08/09 03:55:42 UTC

[jira] Created: (IBATIS-180) Caching question

Caching question
----------------

         Key: IBATIS-180
         URL: http://issues.apache.org/jira/browse/IBATIS-180
     Project: iBatis for Java
        Type: Bug
    Versions: 2.1.0    
 Environment: jdk1.4.2, windows xp
    Reporter: gopal.narayanan


I am not sure this is a bug.
I am trying to use ibatis caching.
Sql statements which do not have any parameters eg 
    select fname,lname from users
seem to work well under caching.
This is how I tested, after the 1st call to the sql, the db was shutdown, the next call returned the data from the cache. The time to fetch was considerably lower, indicating that data was from the cache.
But this test failed when the sql stmt was of the form 
select fname,lname from users where lname = #value#
It seemed that it always need a db connection ( seems like the cache is flushed always)
Is that so? In that case can we not use ibatis caching?

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

[jira] Closed: (IBATIS-180) Caching question

Posted by "Clinton Begin (JIRA)" <ib...@incubator.apache.org>.
     [ http://issues.apache.org/jira/browse/IBATIS-180?page=all ]
     
Clinton Begin closed IBATIS-180:
--------------------------------

    Resolution: Invalid

Please discuss this on the mailing list before submitting an issue.  Thanks.

> Caching question
> ----------------
>
>          Key: IBATIS-180
>          URL: http://issues.apache.org/jira/browse/IBATIS-180
>      Project: iBatis for Java
>         Type: Bug
>     Versions: 2.1.0
>  Environment: jdk1.4.2, windows xp
>     Reporter: gopal.narayanan

>
> I am not sure this is a bug.
> I am trying to use ibatis caching.
> Sql statements which do not have any parameters eg 
>     select fname,lname from users
> seem to work well under caching.
> This is how I tested, after the 1st call to the sql, the db was shutdown, the next call returned the data from the cache. The time to fetch was considerably lower, indicating that data was from the cache.
> But this test failed when the sql stmt was of the form 
> select fname,lname from users where lname = #value#
> It seemed that it always need a db connection ( seems like the cache is flushed always)
> Is that so? In that case can we not use ibatis caching?

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira