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