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

