Did you commit the delete in isql*plus? Larry
On Jan 16, 2008 2:20 AM, JohannesK <[EMAIL PROTECTED]> wrote: > > 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.html > Sent from the iBATIS - User - Java mailing list archive at Nabble.com. > >
