Hi,
I'm trying to get the cacheModel working, but it keeps hitting the database. This is just an example.


<sqlMapConfig>    
        <settings
                cacheModelsEnabled="true"
                enhancementEnabled="true"
                lazyLoadingEnabled="true"
                maxRequests="32"
                maxSessions="10"
                maxTransactions="5"
                useStatementNamespaces="false"
   />
  <sqlMap resource="Person.xml"/>
</sqlMapConfig>

<sqlMap namespace="Person">
  <cacheModel id="personCache" type="LRU">
               <flushInterval hours="24"/>
  </cacheModel>

<select id="getPeople" resultClass="cz.asei.examples.ibatis.Person" cacheModel="personCache" parameterClass="java.util.Map">
<![CDATA[
select b.OSCIS as oscis,
.
.
.


I am using iBatis (2.0.9 b) through Springframework (1.1.5).

DAO code example:
        getSqlMapClientTemplate().queryForList("getPeople", params);

Each call of this line results in hit the database, what i can see in log or database profiler.

DEBUG [main] - {pstm-100085} PreparedStatement: select...
DEBUG [main] - {pstm-100085} Parameters: [...]
DEBUG [main] - {pstm-100085} Types: [...]


Do you have any advice or idea?

Thanks
 Dagi





Reply via email to