ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Roman PichlĂ­k <roman.pich...@asei.cz>
Subject Cache still hitting database (iBatis+Spring)
Date Mon, 18 Apr 2005 09:18:48 GMT
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




Mime
View raw message