Return-Path: 
 <users-return-2782-apmail-openjpa-users-archive=openjpa.apache.org@openjpa.apache.org>
Delivered-To: apmail-openjpa-users-archive@locus.apache.org
Received: (qmail 29480 invoked from network); 16 Sep 2008 14:40:17 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 16 Sep 2008 14:40:17 -0000
Received: (qmail 61479 invoked by uid 500); 16 Sep 2008 14:40:06 -0000
Delivered-To: apmail-openjpa-users-archive@openjpa.apache.org
Received: (qmail 61417 invoked by uid 500); 16 Sep 2008 14:40:06 -0000
Mailing-List: contact users-help@openjpa.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:users-help@openjpa.apache.org>
List-Unsubscribe: <mailto:users-unsubscribe@openjpa.apache.org>
List-Post: <mailto:users@openjpa.apache.org>
List-Id: <users.openjpa.apache.org>
Reply-To: users@openjpa.apache.org
Delivered-To: mailing list users@openjpa.apache.org
Received: (qmail 61383 invoked by uid 99); 16 Sep 2008 14:40:06 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 16 Sep 2008 07:40:06 -0700
X-ASF-Spam-Status: No, hits=0.2 required=10.0
	tests=SPF_HELO_PASS,SPF_PASS,WHOIS_MYPRIVREG
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of
 lists+1214986160035-208411@n2.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; Tue, 16 Sep 2008 14:39:07 +0000
Received: from tervel.nabble.com ([192.168.236.150])
	by kuber.nabble.com with esmtp (Exim 4.63)
	(envelope-from <lists+1214986160035-208411@n2.nabble.com>)
	id 1KfbiN-0002ID-3R
	for users@openjpa.apache.org; Tue, 16 Sep 2008 07:39:39 -0700
Message-ID: <1221575979101-1092833.post@n2.nabble.com>
Date: Tue, 16 Sep 2008 07:39:39 -0700 (PDT)
From: egoosen <egoosen2@metropolitan.co.za>
To: users@openjpa.apache.org
Subject: Cache Problem
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Nabble-From: egoosen2@metropolitan.co.za
X-Virus-Checked: Checked by ClamAV on apache.org


I'm experiencing a cache problem with the current version of OpenJPA (1.2.0),
and previous versions.
I've setup the cache as follows in persistence.xml:
<property name="openjpa.DataCache"
				value="true(CacheSize=25000, SoftReferenceSize=0)" />
<property name="openjpa.QueryCache"
				value="CacheSize=5000, SoftReferenceSize=100" />
<property name="openjpa.RemoteCommitProvider" value="sjvm"/>

We're using Spring JpaDaoSupport.
The org.springframework.orm.jpa.LocalEntityManagerFactoryBean is Spring
loaded.

The problem is that my query is returning stale data after an update/insert.
The update/insert is happening in a separate transaction from the select.

I've tried calling em.refresh(entity), but that didn't work.

Any ideas how I can fix this besides turning cacheing off completely?
-- 
View this message in context: http://n2.nabble.com/Cache-Problem-tp1092833p1092833.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.