You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-cs@ibatis.apache.org by La...@sungard.com on 2008/10/24 22:06:53 UTC
cache is not flush after delete
Hi All,
I am using ibatis.net DataMapper (recent build of 1.6.1 source) and have
many mapping files where I use LRU cacheModel with no issues.
There is one, however, where the object is not flushed when the record
is deleted from the Database. If I try to load the object after is
deleted I get back the old record (which should have been flushed). I
have tried very hard to find any fault in the mapping but have not
succeeded so far.
An extract from my mapping:
---------------------------------------------
<cacheModel id="SpecificVehicleCache" implementation="LRU"
readOnly="false" serialize="true">
<flushInterval hours="1" />
<flushOnExecute statement="updateSpecificVehicle" />
<flushOnExecute statement="insertSpecificVehicle" />
<flushOnExecute statement="deleteSpecificVehicle" />
</cacheModel>
....
<procedure id="getSpecificVehicleById" resultClass="SpecificVehicle"
resultMap="SpecificVehicle"
parameterMap="IdParameterMap" cacheModel="SpecificVehicleCache" >
<![CDATA[IRM_spSpecificVehicleGetById]]>
</procedure>
<procedure id="deleteSpecificVehicle"
parameterMap="SpecificVehicleIdAndCallerParameterMap">
<![CDATA[IRM_spSpecificVehicleDelete]]>
</procedure>
---------------------------------------------
Any ideas why this might be happening?
Thanks in advance,
Lazaro Pi
RE: New Release For .NET?
Posted by "Michael McCurrey (5318)" <mi...@pinggolf.com>.
We are looking to migrade to V3 soon on our side as well. I have been doing some prelimnary work on migrating the Castle iBatis facility to work with the V3 of IBatis.NET. Has anybody else been doing the same? I'd hate to do duplicate work.
________________________________
From: Gilles Bayon [mailto:ibatis.net@gmail.com]
Sent: Monday, October 27, 2008 11:53 PM
To: user-cs@ibatis.apache.org
Subject: Re: New Release For .NET?
me too, :-)
On Mon, Oct 27, 2008 at 11:54 PM, Vincent Apesa <va...@hotmail.com>> wrote:
I've been running the v3 build in a production environment for around two months and haven't seen any problems. It seems pretty stable.
----- Original Message -----
From: Clinton Begin<ma...@gmail.com>
To: user-cs@ibatis.apache.org<ma...@ibatis.apache.org>
Sent: Monday, October 27, 2008 4:07 PM
Subject: Re: New Release For .NET?
Funny, I'm committing the most right now on the Java side, and often I feel like I'm trying to keep up with Gilles! :-)
I think the .NET release will arrive before the Java counterpart. Race ya!
Cheers,
Clinton
On Mon, Oct 27, 2008 at 1:54 PM, Sal Bass <sa...@hotmail.com>> wrote:
Lol. Thanks. I know how annoying this sort of question is....just checking to see if there is still life out there. ;-)
Now that I have your attention, is "soon" pre-2009? (Bullet-proof vest on).
________________________________
Date: Mon, 27 Oct 2008 20:37:56 +0100
From: ibatis.net<http://ibatis.net/>@gmail.com<http://gmail.com/>
To: user-cs@ibatis.apache.org<ma...@ibatis.apache.org>
Subject: Re: New Release For .NET?
soon.
Cheers,
Gilles
________________________________
Store, manage and share up to 5GB with Windows Live SkyDrive. Start uploading now<http://skydrive.live.com/welcome.aspx?provision=1?ocid=TXT_TAGLM_WL_skydrive_102008>
--
Cheers,
Gilles
Join my network on LinkedIn
http://www.linkedin.com/in/sellig
Re: New Release For .NET?
Posted by Gilles Bayon <ib...@gmail.com>.
me too, :-)
On Mon, Oct 27, 2008 at 11:54 PM, Vincent Apesa <va...@hotmail.com> wrote:
> I've been running the v3 build in a production environment for around two
> months and haven't seen any problems. It seems pretty stable.
>
>
> ----- Original Message -----
> *From:* Clinton Begin <cl...@gmail.com>
> *To:* user-cs@ibatis.apache.org
> *Sent:* Monday, October 27, 2008 4:07 PM
> *Subject:* Re: New Release For .NET?
>
> Funny, I'm committing the most right now on the Java side, and often I feel
> like I'm trying to keep up with Gilles! :-)
>
> I think the .NET release will arrive before the Java counterpart. Race ya!
>
> Cheers,
> Clinton
>
> On Mon, Oct 27, 2008 at 1:54 PM, Sal Bass <sa...@hotmail.com> wrote:
>
>> Lol. Thanks. I know how annoying this sort of question is....just checking
>> to see if there is still life out there. ;-)
>>
>> Now that I have your attention, is "soon" pre-2009? (Bullet-proof vest
>> on).
>>
>>
>>
>> ------------------------------
>>
>> Date: Mon, 27 Oct 2008 20:37:56 +0100
>> From: ibatis.net@gmail.com
>> To: user-cs@ibatis.apache.org
>> Subject: Re: New Release For .NET?
>>
>> soon.
>>
>> Cheers,
>> Gilles
>>
>>
>>
>> ------------------------------
>> Store, manage and share up to 5GB with Windows Live SkyDrive. Start
>> uploading now<http://skydrive.live.com/welcome.aspx?provision=1?ocid=TXT_TAGLM_WL_skydrive_102008>
>>
>
>
--
Cheers,
Gilles
Join my network on LinkedIn
http://www.linkedin.com/in/sellig
Re: New Release For .NET?
Posted by Vincent Apesa <va...@hotmail.com>.
I've been running the v3 build in a production environment for around two months and haven't seen any problems. It seems pretty stable.
----- Original Message -----
From: Clinton Begin
To: user-cs@ibatis.apache.org
Sent: Monday, October 27, 2008 4:07 PM
Subject: Re: New Release For .NET?
Funny, I'm committing the most right now on the Java side, and often I feel like I'm trying to keep up with Gilles! :-)
I think the .NET release will arrive before the Java counterpart. Race ya!
Cheers,
Clinton
On Mon, Oct 27, 2008 at 1:54 PM, Sal Bass <sa...@hotmail.com> wrote:
Lol. Thanks. I know how annoying this sort of question is....just checking to see if there is still life out there. ;-)
Now that I have your attention, is "soon" pre-2009? (Bullet-proof vest on).
----------------------------------------------------------------------------
Date: Mon, 27 Oct 2008 20:37:56 +0100
From: ibatis.net@gmail.com
To: user-cs@ibatis.apache.org
Subject: Re: New Release For .NET?
soon.
Cheers,
Gilles
----------------------------------------------------------------------------
Store, manage and share up to 5GB with Windows Live SkyDrive. Start uploading now
Re: New Release For .NET?
Posted by Clinton Begin <cl...@gmail.com>.
Funny, I'm committing the most right now on the Java side, and often I feel
like I'm trying to keep up with Gilles! :-)
I think the .NET release will arrive before the Java counterpart. Race ya!
Cheers,
Clinton
On Mon, Oct 27, 2008 at 1:54 PM, Sal Bass <sa...@hotmail.com> wrote:
> Lol. Thanks. I know how annoying this sort of question is....just checking
> to see if there is still life out there. ;-)
>
> Now that I have your attention, is "soon" pre-2009? (Bullet-proof vest on).
>
>
>
> ------------------------------
>
> Date: Mon, 27 Oct 2008 20:37:56 +0100
> From: ibatis.net@gmail.com
> To: user-cs@ibatis.apache.org
> Subject: Re: New Release For .NET?
>
> soon.
>
> Cheers,
> Gilles
>
>
>
> ------------------------------
> Store, manage and share up to 5GB with Windows Live SkyDrive. Start
> uploading now<http://skydrive.live.com/welcome.aspx?provision=1?ocid=TXT_TAGLM_WL_skydrive_102008>
>
Re: New Release For .NET?
Posted by Gilles Bayon <ib...@gmail.com>.
The next week, I will do a maintenance release 1.6.2.
For iBATIS V3, a BETA will be available before the end of the year or on the
next beginning year.
Cheers,
Gilles
RE: New Release For .NET?
Posted by Sal Bass <sa...@hotmail.com>.
Lol. Thanks. I know how annoying this sort of question is....just checking to see if there is still life out there. ;-)
Now that I have your attention, is "soon" pre-2009? (Bullet-proof vest on).
Date: Mon, 27 Oct 2008 20:37:56 +0100From: ibatis.net@gmail.comTo: user-cs@ibatis.apache.orgSubject: Re: New Release For .NET?soon.Cheers,Gilles
_________________________________________________________________
Store, manage and share up to 5GB with Windows Live SkyDrive.
http://skydrive.live.com/welcome.aspx?provision=1?ocid=TXT_TAGLM_WL_skydrive_102008
Re: New Release For .NET?
Posted by Gilles Bayon <ib...@gmail.com>.
soon.
Cheers,
Gilles
New Release For .NET?
Posted by Sal Bass <sa...@hotmail.com>.
There seems to be a lot of activity on the Java side, but when can we expect the next full release version of Ibatis.NET?
_________________________________________________________________
You live life beyond your PC. So now Windows goes beyond your PC.
http://clk.atdmt.com/MRT/go/115298556/direct/01/
RE: cache is not flush after delete
Posted by La...@sungard.com.
I thought I was always using deleteSpecificVehicle but in some cases the
code is calling a delete for the parent object (calls deleteVehicle). I
corrected the cacheModel to include a flush on delete of the parent
object and now it works as expected:
<cacheModel id="SpecificVehicleCache" implementation="LRU"
readOnly="false" serialize="true">
<flushInterval hours="1" />
<flushOnExecute statement="updateSpecificVehicle" />
<flushOnExecute statement="insertSpecificVehicle" />
<flushOnExecute statement="deleteSpecificVehicle" />
<flushOnExecute statement="Vehicle.updateVehicle" />
<flushOnExecute statement="Vehicle.deleteVehicle" />
</cacheModel>
Thank you very much,
Lazaro Pi
________________________________
From: Milivoj Milani [mailto:milivojm@gzr.hr]
Sent: Monday, October 27, 2008 4:39 AM
To: user-cs@ibatis.apache.org
Subject: RE: cache is not flush after delete
Did you delete the record using your application (ie. Using
deleteSpecificVehicle) or through some other database client tool?
From: Lazaro.Pi@sungard.com [mailto:Lazaro.Pi@sungard.com]
Sent: Friday, October 24, 2008 10:07 PM
To: user-cs@ibatis.apache.org
Subject: cache is not flush after delete
Hi All,
I am using ibatis.net DataMapper (recent build of 1.6.1 source) and have
many mapping files where I use LRU cacheModel with no issues.
There is one, however, where the object is not flushed when the record
is deleted from the Database. If I try to load the object after is
deleted I get back the old record (which should have been flushed). I
have tried very hard to find any fault in the mapping but have not
succeeded so far.
An extract from my mapping:
---------------------------------------------
<cacheModel id="SpecificVehicleCache" implementation="LRU"
readOnly="false" serialize="true">
<flushInterval hours="1" />
<flushOnExecute statement="updateSpecificVehicle" />
<flushOnExecute statement="insertSpecificVehicle" />
<flushOnExecute statement="deleteSpecificVehicle" />
</cacheModel>
....
<procedure id="getSpecificVehicleById" resultClass="SpecificVehicle"
resultMap="SpecificVehicle"
parameterMap="IdParameterMap" cacheModel="SpecificVehicleCache" >
<![CDATA[IRM_spSpecificVehicleGetById]]>
</procedure>
<procedure id="deleteSpecificVehicle"
parameterMap="SpecificVehicleIdAndCallerParameterMap">
<![CDATA[IRM_spSpecificVehicleDelete]]>
</procedure>
---------------------------------------------
Any ideas why this might be happening?
Thanks in advance,
Lazaro Pi
RE: cache is not flush after delete
Posted by Milivoj Milani <mi...@gzr.hr>.
Did you delete the record using your application (ie. Using
deleteSpecificVehicle) or through some other database client tool?
From: Lazaro.Pi@sungard.com [mailto:Lazaro.Pi@sungard.com]
Sent: Friday, October 24, 2008 10:07 PM
To: user-cs@ibatis.apache.org
Subject: cache is not flush after delete
Hi All,
I am using ibatis.net DataMapper (recent build of 1.6.1 source) and have
many mapping files where I use LRU cacheModel with no issues.
There is one, however, where the object is not flushed when the record
is deleted from the Database. If I try to load the object after is
deleted I get back the old record (which should have been flushed). I
have tried very hard to find any fault in the mapping but have not
succeeded so far.
An extract from my mapping:
---------------------------------------------
<cacheModel id="SpecificVehicleCache" implementation="LRU"
readOnly="false" serialize="true">
<flushInterval hours="1" />
<flushOnExecute statement="updateSpecificVehicle" />
<flushOnExecute statement="insertSpecificVehicle" />
<flushOnExecute statement="deleteSpecificVehicle" />
</cacheModel>
....
<procedure id="getSpecificVehicleById" resultClass="SpecificVehicle"
resultMap="SpecificVehicle"
parameterMap="IdParameterMap" cacheModel="SpecificVehicleCache" >
<![CDATA[IRM_spSpecificVehicleGetById]]>
</procedure>
<procedure id="deleteSpecificVehicle"
parameterMap="SpecificVehicleIdAndCallerParameterMap">
<![CDATA[IRM_spSpecificVehicleDelete]]>
</procedure>
---------------------------------------------
Any ideas why this might be happening?
Thanks in advance,
Lazaro Pi