Yep; unforunately in my app I would love the cache to be there for long transaction checking... I solved it by switching off the cache and manually checking dirty fields on return and hand coding the two phase transactions...
All that would be needed to solve it would be someway to force a particular query to reload the cache; or possibly even clear the cache for a particular object type at certain times ?
Thanks, Colin
----------------------------------------------------------------------------------------
Colin
Canfield
[EMAIL PROTECTED]
Web Architect
0412 197 943
Explorative Software
Pty Ltd
www.exsoft.com.au
-----Original Message-----
From: Smith, Kevin [mailto:[EMAIL PROTECTED]]
Sent: Friday, 19 April 2002 10:31 PM
To: [EMAIL PROTECTED]
Subject: Re: [castor-dev] object being incorrectly read from cacheHowever, that can lead to "interesting" transaction and locking issues when trying to do an update.-----Original Message-----
From: Ebersole, Steven [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 19, 2002 8:24 AM
To: [EMAIL PROTECTED]
Subject: Re: [castor-dev] object being incorrectly read from cacheThe purpose of a cache is exactly what you describe: avoid having to hit the database every time. If you absolutely need the latest data from the DB (and there is a possiblity users will be directly updating the DB) then turn caching off.********************************************
Steve Ebersole
IT Integration Engineer
Vignette Corporation
512.741.4195
Visit http://www.vignette.com
********************************************-----Original Message-----
From: Colin Canfield [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 19, 2002 1:22 AM
To: [EMAIL PROTECTED]
Subject: [castor-dev] object being incorrectly read from cacheI am reading an object, processing it setting a value and storing it. When I edit the underlying database (in a seperate application not using castor); and then run the query again it returns me the original object from the castor cache rather than the new database entry...
is there anyway to clear the cache ? or force a reload into the cache ?
this object is implements long transactions , is that perhaps the problem ?
Thanks, Colin
Colin Canfield Proteus Solutions
02 8273 8100 [EMAIL PROTECTED]
http://www.proteussolutions.com.au
IMPORTANT NOTICE
-------------------------------
This electronic mail message is intended only for the named recipient(s). If you have received this message in error, you are prohibited from reading, copying, distributing or using the information. Please contact the sender immediately via return e-mail and destroy the original message.The contents of this message should not be relied upon by any person without subsequent written confirmation. The Firm accepts no liability for actions taken as a result of this message prior to receiving such written confirmation.