iBATIS doesn't cache anything by default. Since you have no caching configured, there must be some other explanation.
Clinton -----Original Message----- From: JohannesK [mailto:[EMAIL PROTECTED] Sent: January-16-08 2:20 AM To: [email protected] Subject: Weird cache behaviour in iBatis Hi I'm having problems with the caching in iBatis. I'm running ibatis-2.3.0.677 with an Oracle 10g database. Basically if I remove a row in the DB through iSQL*Plus, it is still present in the iBatis cache. Here's my sqlMapConfig.xml: <?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE sqlMapConfig PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-config-2.dtd";> <sqlMapConfig> <settings cacheModelsEnabled="false" /> <sqlMap resource="core/Test.xml" /> </sqlMapConfig> Test.xml: <?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd";> <sqlMap> <typeAlias type="fi.eficode.lila.core.Test" alias="Test" /> <resultMap id="testResult" class="Test"> <result property="id" column="Id" /> <result property="name" column="Name" /> </resultMap> <select id="getAllTests" resultMap="testResult"> select * from Test </select> <insert id="insertTest" parameterClass="Test"> INSERT INTO TEST VALUES (#id#, #name#) </insert> </sqlMap> When i run the insert query everything happens as expected and a row appears in the table 'TEST' and also appears when i run the select query in Java. Now if i delete the row through iSQL*Plus and run the select in Java again, I still get the test object as a result. This happens even though I've deleted the row, turned caching off in iBatis and even tried to call SqlMapClient().flushDataCache(). What gives? -- View this message in context: http://www.nabble.com/Weird-cache-behaviour-in-iBatis-tp14875443p14875443.ht ml Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
