Return-Path: 
 <user-java-return-13441-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 5740 invoked from network); 16 Jan 2008 09:20:35 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 16 Jan 2008 09:20:35 -0000
Received: (qmail 38091 invoked by uid 500); 16 Jan 2008 09:20:22 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 38073 invoked by uid 500); 16 Jan 2008 09:20:22 -0000
Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-java-help@ibatis.apache.org>
List-Unsubscribe: <mailto:user-java-unsubscribe@ibatis.apache.org>
List-Post: <mailto:user-java@ibatis.apache.org>
List-Id: <user-java.ibatis.apache.org>
Reply-To: user-java@ibatis.apache.org
Delivered-To: mailing list user-java@ibatis.apache.org
Received: (qmail 38060 invoked by uid 99); 16 Jan 2008 09:20:22 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 16 Jan 2008 01:20:22 -0800
X-ASF-Spam-Status: No, hits=2.6 required=10.0
	tests=DNS_FROM_OPENWHOIS,SPF_HELO_PASS,SPF_PASS,WHOIS_MYPRIVREG
X-Spam-Check-By: apache.org
Received-SPF: pass (nike.apache.org: domain of lists@nabble.com designates
 216.139.236.158 as permitted sender)
Received: from [216.139.236.158] (HELO kuber.nabble.com) (216.139.236.158)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 16 Jan 2008 09:20:10 +0000
Received: from isper.nabble.com ([192.168.236.156])
	by kuber.nabble.com with esmtp (Exim 4.63)
	(envelope-from <lists@nabble.com>)
	id 1JF4RG-0002sg-V4
	for user-java@ibatis.apache.org; Wed, 16 Jan 2008 01:20:02 -0800
Message-ID: <14875443.post@talk.nabble.com>
Date: Wed, 16 Jan 2008 01:20:02 -0800 (PST)
From: JohannesK <johannes.kuusela@eficode.fi>
To: user-java@ibatis.apache.org
Subject: Weird cache behaviour in iBatis
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Nabble-From: johannes.kuusela@eficode.fi
X-Virus-Checked: Checked by ClamAV on apache.org


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.