[
https://issues.apache.org/jira/browse/CAY-596?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13560397#comment-13560397
]
Brian Dickinson commented on CAY-596:
-------------------------------------
We have definitely had issues with stale cache data. It only seems to happen
occasionally. One thread makes an update and another thread consistently
retrieves the old data. In one case we basically have a thread that checks
order.getOrderItems every few seconds. If all of the order items are completed
then the thread can exit but sometimes it never does. We can see that the
changes were committed to the database, but they don't propagate back to the
other thread. We have had to work around this by either passing any desired
updates into the thread that does the checking and allowing it to make the
changes, or by explicitly refreshing from the database occasionally. We
haven't had any issues with the workarounds in place. We are using the shared
object cache exclusively. Cayenne version is 3.0.1.
> DataObject cache works incorrect !
> ----------------------------------
>
> Key: CAY-596
> URL: https://issues.apache.org/jira/browse/CAY-596
> Project: Cayenne
> Issue Type: Bug
> Components: Core Library
> Affects Versions: 1.2 branch
> Environment: Windows XP, 1.4.2_06 by Sun Microsystems Inc., DB
> Oracle
> Reporter: Paul Ponec
> Priority: Critical
>
> Data object util method:
> DataObjectUtils.objectForPK(context, persistentClass, (Object) id);
> returns sometimes (freqency 30% on my sample) a DataObject with an old
> property value.
> If I am using code:
> Expression expr = ExpressionFactory.matchExp("id", id);
> SelectQuery query = new SelectQuery(persistentType, expr);
> List list = context.performQuery(query);
> return list.size()==1 ? list.get(0) : null;
> then result (all object properties) is OK always.
> ---
> A selection from map.xml:
> <db-entity name="CALL" schema="TEST">
> <db-attribute name="id" type="NUMERIC" isPrimaryKey="true"
> isMandatory="true"/>
> <db-attribute name="sign" type="VARCHAR" length="1"/>
> </db-entity>
> <obj-entity name="Call" className="xxx.Call" dbEntityName="CALL">
> <obj-attribute name="id" type="java.math.BigDecimal"
> db-attribute-path="id"/>
> <obj-attribute name="sign" type="java.lang.String"
> db-attribute-path="sign"/>
> </obj-entity>
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
