Re: [eclipselink-users] Query returning stale results existing

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
Re: [eclipselink-users] Query returning stale results existing
From: cowwoc <cowwoc@xxxxxxxxxxxxxxxx>
Date: Tue, 18 Nov 2008 10:37:32 -0800 (PST)
Delivered-to: eclipselink-users@xxxxxxxxxxx
List-archive: <https://dev.eclipse.org/mailman/private/eclipselink-users>
List-help: <mailto:eclipselink-users-request@eclipse.org?subject=help>
List-subscribe: <https://dev.eclipse.org/mailman/listinfo/eclipselink-users>, <mailto:eclipselink-users-request@eclipse.org?subject=subscribe>
List-unsubscribe: <https://dev.eclipse.org/mailman/listinfo/eclipselink-users>, <mailto:eclipselink-users-request@eclipse.org?subject=unsubscribe>
Another question: is there a portable way for me to ensure that I am looking
at the latest version of an object as defined by the database (bypassing the
shared cache)?

I know I can use EclipseLink-specific query hints, but what about
EntityManager.refresh() or EntityManager.lock(queryResult,
LockModeType.READ)? Will such calls help me at all? How can you use the
shared cache 95% of the time but instruct JPA to retrieve directly from the
databases other times?

Thanks,
Gili


cowwoc wrote:
> 
> 
> 1) How does one export the Workbench settings to be used with a JPA
> project? I tried configuring the cache expiration TTL and exporting it
> using Workbench -> Export -> Project Deployment XML but the resulting file
> didn't contain the TTL information at all.
> 
> 2) Is there a way to configure cache expiration via persistence.xml or is
> @Cache the only way?
> 
> I guess I should stick to
> http://wiki.eclipse.org/Using_EclipseLink_JPA_Extensions_(ELUG) in the
> future. It seems to be written in the style I'm looking for (more goal
> oriented).
> 
> Thanks,
> Gili
> 
> 
> Tim Hollosy wrote:
>> 
>> The docs can be frustrating because they appear to be a search/replace
>> on the TopLink docs. However, the good thing with EclipseLink is there
>> is a team of pro's working on the code at all times.
>> 
>> Anyway:
>> <property name="eclipselink.cache.shared.default" value="false"/>
>> 
>> In your persistence.xml will put you in isolated mode. You can also do
>> it with PersistenceUnitProperties if you're creating your
>> EntityManagerFactory programatically...
>> 
>> ./tch
>> 
>> 
>> 
>> On Tue, Nov 18, 2008 at 12:50 PM, cowwoc <cowwoc@xxxxxxxxxxxxxxxx> wrote:
>>>
>>> I am familiar with the 2nd-level cache, except that for Hibernate it was
>>> off
>>> by default (because of these kinds of side-effects).
>>>
>>> I found this kind of surprising too: "EclipseLink does not access
>>> sequencing
>>> objects using the isolated session's dedicated connection, and so the
>>> sequence values are not available to the isolated session." Really? So I
>>> can't use @GeneratedValue(generator = "foo")?
>>>
>>> It isn't clear from
>>> http://wiki.eclipse.org/Configuring_a_Project_(ELUG)#Configuring_Cache_Isolation_at_the_Project_Level
>>> how to configure this without the workbench (which I don't use). How do
>>> I
>>> configure this from Java code or persistence.xml?
>>>
>>> To be honest, I find this documentation to be an exercise in
>>> frustration. It
>>> jumps from one document to another with very little example code. Very
>>> often
>>> the only example given requires the use of the workbench GUI. That's
>>> nice,
>>> but if there is a portable way for me to do it using JPA code I'd prefer
>>> that instead.
>>>
>>> Gili
>>>
>>>
>>> Tim Hollosy wrote:
>>>>
>>>> Remember EclipseLink uses a 2nd Level Cache -- the Shared Cache. This
>>>> is per Entity Manager Factory.
>>>>
>>>> See: http://wiki.eclipse.org/Introduction_to_Cache_(ELUG)
>>>>
>>>> ./tch
>>>>
>>>>
>>>>
>>>> On Tue, Nov 18, 2008 at 8:40 AM, cowwoc <cowwoc@xxxxxxxxxxxxxxxx>
>>>> wrote:
>>>>>
>>>>> Hi,
>>>>>
>>>>> I am issuing the same query in subsequent HTTP queries and getting
>>>>> back
>>>>> stale results (cached from the first request). As far as I can tell I
>>>>> am
>>>>> using the Session-Per-HTTP-Request paradigm so this shouldn't be
>>>>> happening.
>>>>> I need your help to interpret the EclipseLink logs (included at the
>>>>> end
>>>>> of
>>>>> this email).
>>>>>
>>>>> 1) Does "client released" mean EntityManager.close() has been issued?
>>>>> 2) What would cause queries to cache results across EntityManagers?
>>>>>
>>>>> I will now include my log. The first line is issued in request #1, the
>>>>> subsequent lines are issued by subsequent requests. The lines that
>>>>> caught
>>>>> my
>>>>> eyes were the ones reading "Register the existing object"... I believe
>>>>> EclipseLink isn't actually contacting the database.
>>>>>
>>>>> One warning: media_version.version is *not* the optimistic-locking
>>>>> versioning field. It is used purely for business logic.
>>>>>
>>>>>
>>>>> -------------log----------------------
>>>>> [EL Finer]: 2008.11.18
>>>>> 08:25:22.872--ClientSession(58019908)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--client
>>>>> released
>>>>> [EL Finer]: 2008.11.18
>>>>> 08:26:25.538--ServerSession(290077830)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--client
>>>>> acquired
>>>>> [EL Finest]: 2008.11.18
>>>>> 08:26:25.539--UnitOfWork(884597793)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--Execute
>>>>> query ReadAllQuery(adcaster.server.domain.Media)
>>>>> [EL Finest]: 2008.11.18
>>>>> 08:26:25.540--ServerSession(290077830)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--reconnecting
>>>>> to external connection pool
>>>>> [EL Fine]: 2008.11.18
>>>>> 08:26:25.540--ServerSession(290077830)--Connection(405818770)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--SELECT
>>>>> ID, VERSION FROM MEDIA
>>>>> [EL Finest]: 2008.11.18
>>>>> 08:26:25.542--UnitOfWork(884597793)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--Register
>>>>> the existing object
>>>>> adcaster.server.domain.Media[objects=blueeye.lang.Objects@27e4e751,
>>>>> id=101,
>>>>> version=1]
>>>>> [EL Finer]: 2008.11.18
>>>>> 08:26:25.543--UnitOfWork(884597793)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--begin
>>>>> unit of work commit
>>>>> [EL Finer]: 2008.11.18
>>>>> 08:26:25.543--UnitOfWork(884597793)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--end
>>>>> unit of work commit
>>>>> [EL Finer]: 2008.11.18
>>>>> 08:26:25.544--UnitOfWork(884597793)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--resume
>>>>> unit of work
>>>>> [EL Finer]: 2008.11.18
>>>>> 08:26:25.544--UnitOfWork(884597793)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--release
>>>>> unit of work
>>>>> [EL Finer]: 2008.11.18
>>>>> 08:26:25.545--ClientSession(2110771332)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--client
>>>>> released
>>>>> [EL Finer]: 2008.11.18
>>>>> 08:26:25.565--ServerSession(290077830)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--client
>>>>> acquired
>>>>> [EL Finest]: 2008.11.18
>>>>> 08:26:25.565--UnitOfWork(616939444)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Execute
>>>>> query ReadObjectQuery(adcaster.server.domain.Media)
>>>>> [EL Finer]: 2008.11.18
>>>>> 08:26:25.566--UnitOfWork(616939444)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--begin
>>>>> unit of work commit
>>>>> [EL Finer]: 2008.11.18
>>>>> 08:26:25.566--UnitOfWork(616939444)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--end
>>>>> unit of work commit
>>>>> [EL Finer]: 2008.11.18
>>>>> 08:26:25.567--UnitOfWork(616939444)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--resume
>>>>> unit of work
>>>>> [EL Finest]: 2008.11.18
>>>>> 08:26:25.567--UnitOfWork(616939444)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Execute
>>>>> query ReadAllQuery(adcaster.server.domain.MediaVersion)
>>>>> [EL Finest]: 2008.11.18
>>>>> 08:26:25.568--ServerSession(290077830)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--reconnecting
>>>>> to external connection pool
>>>>> [EL Fine]: 2008.11.18
>>>>> 08:26:25.568--ServerSession(290077830)--Connection(814711173)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--SELECT
>>>>> ID, NAME, VERSION, data_, MEDIA_ID FROM media_version WHERE (MEDIA_ID
>>>>> =
>>>>> ?)
>>>>> ORDER BY VERSION ASC
>>>>>        bind => [101]
>>>>> [EL Finest]: 2008.11.18
>>>>> 08:26:25.571--UnitOfWork(616939444)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register
>>>>> the existing object
>>>>> adcaster.server.domain.MediaVersion[objects=blueeye.lang.Objects@48b85e03,
>>>>> id=151,
>>>>> media=adcaster.server.domain.Media[objects=blueeye.lang.Objects@27e4e751,
>>>>> id=101, version=1], version=0, data=[46, 46, 46, 99, 111, 110, 116,
>>>>> 101,
>>>>> 110, 116, 115, 32, 111, 102, 32, 102, 105, 108, 101, 50, 46, 103, 105,
>>>>> 102,
>>>>> 46, 46, 46], name=Media2]
>>>>> [EL Finest]: 2008.11.18
>>>>> 08:26:25.572--UnitOfWork(616939444)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register
>>>>> the existing object
>>>>> adcaster.server.domain.Media[objects=blueeye.lang.Objects@27e4e751,
>>>>> id=101,
>>>>> version=1]
>>>>> [EL Finest]: 2008.11.18
>>>>> 08:26:25.572--UnitOfWork(616939444)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register
>>>>> the existing object
>>>>> adcaster.server.domain.MediaVersion[objects=blueeye.lang.Objects@48b85e03,
>>>>> id=201,
>>>>> media=adcaster.server.domain.Media[objects=blueeye.lang.Objects@27e4e751,
>>>>> id=101, version=1], version=1, data=[46, 46, 46, 99, 111, 110, 116,
>>>>> 101,
>>>>> 110, 116, 115, 32, 111, 102, 32, 102, 105, 108, 101, 50, 46, 103, 105,
>>>>> 102,
>>>>> 46, 46, 46], name=Media2]
>>>>> [EL Finest]: 2008.11.18
>>>>> 08:26:25.573--UnitOfWork(616939444)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register
>>>>> the existing object
>>>>> adcaster.server.domain.Media[objects=blueeye.lang.Objects@27e4e751,
>>>>> id=101,
>>>>> version=1]
>>>>> [EL Finest]: 2008.11.18
>>>>> 08:26:25.574--UnitOfWork(616939444)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register
>>>>> the existing object
>>>>> adcaster.server.domain.MediaVersion[objects=blueeye.lang.Objects@48b85e03,
>>>>> id=251,
>>>>> media=adcaster.server.domain.Media[objects=blueeye.lang.Objects@27e4e751,
>>>>> id=101, version=1], version=2, data=[46, 46, 46, 99, 111, 110, 116,
>>>>> 101,
>>>>> 110, 116, 115, 32, 111, 102, 32, 102, 105, 108, 101, 50, 46, 103, 105,
>>>>> 102,
>>>>> 46, 46, 46], name=Media2]
>>>>> [EL Finest]: 2008.11.18
>>>>> 08:26:25.574--UnitOfWork(616939444)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register
>>>>> the existing object
>>>>> adcaster.server.domain.Media[objects=blueeye.lang.Objects@27e4e751,
>>>>> id=101,
>>>>> version=1]
>>>>> [EL Finest]: 2008.11.18
>>>>> 08:26:25.575--UnitOfWork(616939444)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register
>>>>> the existing object
>>>>> adcaster.server.domain.MediaVersion[objects=blueeye.lang.Objects@48b85e03,
>>>>> id=301,
>>>>> media=adcaster.server.domain.Media[objects=blueeye.lang.Objects@27e4e751,
>>>>> id=101, version=1], version=3, data=[46, 46, 46, 99, 111, 110, 116,
>>>>> 101,
>>>>> 110, 116, 115, 32, 111, 102, 32, 102, 105, 108, 101, 50, 46, 103, 105,
>>>>> 102,
>>>>> 46, 46, 46], name=Media2]
>>>>> [EL Finest]: 2008.11.18
>>>>> 08:26:25.575--UnitOfWork(616939444)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register
>>>>> the existing object
>>>>> adcaster.server.domain.Media[objects=blueeye.lang.Objects@27e4e751,
>>>>> id=101,
>>>>> version=1]
>>>>> [EL Finest]: 2008.11.18
>>>>> 08:26:25.576--UnitOfWork(616939444)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register
>>>>> the existing object
>>>>> adcaster.server.domain.MediaVersion[objects=blueeye.lang.Objects@48b85e03,
>>>>> id=351,
>>>>> media=adcaster.server.domain.Media[objects=blueeye.lang.Objects@27e4e751,
>>>>> id=101, version=1], version=4, data=[46, 46, 46, 99, 111, 110, 116,
>>>>> 101,
>>>>> 110, 116, 115, 32, 111, 102, 32, 102, 105, 108, 101, 50, 46, 103, 105,
>>>>> 102,
>>>>> 46, 46, 46], name=Media2]
>>>>> [EL Finest]: 2008.11.18
>>>>> 08:26:25.576--UnitOfWork(616939444)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register
>>>>> the existing object
>>>>> adcaster.server.domain.Media[objects=blueeye.lang.Objects@27e4e751,
>>>>> id=101,
>>>>> version=1]
>>>>> [EL Finest]: 2008.11.18
>>>>> 08:26:25.577--UnitOfWork(616939444)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register
>>>>> the existing object
>>>>> adcaster.server.domain.MediaVersion[objects=blueeye.lang.Objects@48b85e03,
>>>>> id=401,
>>>>> media=adcaster.server.domain.Media[objects=blueeye.lang.Objects@27e4e751,
>>>>> id=101, version=1], version=5, data=[46, 46, 46, 99, 111, 110, 116,
>>>>> 101,
>>>>> 110, 116, 115, 32, 111, 102, 32, 102, 105, 108, 101, 50, 46, 103, 105,
>>>>> 102,
>>>>> 46, 46, 46], name=Media2]
>>>>> [EL Finest]: 2008.11.18
>>>>> 08:26:25.578--UnitOfWork(616939444)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register
>>>>> the existing object
>>>>> adcaster.server.domain.Media[objects=blueeye.lang.Objects@27e4e751,
>>>>> id=101,
>>>>> version=1]
>>>>> [EL Finest]: 2008.11.18
>>>>> 08:26:25.578--UnitOfWork(616939444)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register
>>>>> the existing object
>>>>> adcaster.server.domain.MediaVersion[objects=blueeye.lang.Objects@48b85e03,
>>>>> id=451,
>>>>> media=adcaster.server.domain.Media[objects=blueeye.lang.Objects@27e4e751,
>>>>> id=101, version=1], version=6, data=[46, 46, 46, 99, 111, 110, 116,
>>>>> 101,
>>>>> 110, 116, 115, 32, 111, 102, 32, 102, 105, 108, 101, 50, 46, 103, 105,
>>>>> 102,
>>>>> 46, 46, 46], name=Media2]
>>>>> [EL Finest]: 2008.11.18
>>>>> 08:26:25.579--UnitOfWork(616939444)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register
>>>>> the existing object
>>>>> adcaster.server.domain.Media[objects=blueeye.lang.Objects@27e4e751,
>>>>> id=101,
>>>>> version=1]
>>>>> [EL Finest]: 2008.11.18
>>>>> 08:26:25.580--UnitOfWork(616939444)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register
>>>>> the existing object
>>>>> adcaster.server.domain.MediaVersion[objects=blueeye.lang.Objects@48b85e03,
>>>>> id=501,
>>>>> media=adcaster.server.domain.Media[objects=blueeye.lang.Objects@27e4e751,
>>>>> id=101, version=1], version=7, data=[46, 46, 46, 99, 111, 110, 116,
>>>>> 101,
>>>>> 110, 116, 115, 32, 111, 102, 32, 102, 105, 108, 101, 50, 46, 103, 105,
>>>>> 102,
>>>>> 46, 46, 46], name=Media2]
>>>>> [EL Finest]: 2008.11.18
>>>>> 08:26:25.580--UnitOfWork(616939444)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register
>>>>> the existing object
>>>>> adcaster.server.domain.Media[objects=blueeye.lang.Objects@27e4e751,
>>>>> id=101,
>>>>> version=1]
>>>>> [EL Finest]: 2008.11.18
>>>>> 08:26:25.581--UnitOfWork(616939444)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register
>>>>> the existing object
>>>>> adcaster.server.domain.MediaVersion[objects=blueeye.lang.Objects@48b85e03,
>>>>> id=502,
>>>>> media=adcaster.server.domain.Media[objects=blueeye.lang.Objects@27e4e751,
>>>>> id=101, version=1], version=8, data=[46, 46, 46, 99, 111, 110, 116,
>>>>> 101,
>>>>> 110, 116, 115, 32, 111, 102, 32, 102, 105, 108, 101, 50, 46, 103, 105,
>>>>> 102,
>>>>> 46, 46, 46], name=Media2]
>>>>> [EL Finest]: 2008.11.18
>>>>> 08:26:25.581--UnitOfWork(616939444)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register
>>>>> the existing object
>>>>> adcaster.server.domain.Media[objects=blueeye.lang.Objects@27e4e751,
>>>>> id=101,
>>>>> version=1]
>>>>> [EL Finest]: 2008.11.18
>>>>> 08:26:25.582--UnitOfWork(616939444)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register
>>>>> the existing object
>>>>> adcaster.server.domain.MediaVersion[objects=blueeye.lang.Objects@48b85e03,
>>>>> id=551,
>>>>> media=adcaster.server.domain.Media[objects=blueeye.lang.Objects@27e4e751,
>>>>> id=101, version=1], version=9, data=[46, 46, 46, 99, 111, 110, 116,
>>>>> 101,
>>>>> 110, 116, 115, 32, 111, 102, 32, 102, 105, 108, 101, 50, 46, 103, 105,
>>>>> 102,
>>>>> 46, 46, 46], name=Media2]
>>>>> [EL Finest]: 2008.11.18
>>>>> 08:26:25.583--UnitOfWork(616939444)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register
>>>>> the existing object
>>>>> adcaster.server.domain.Media[objects=blueeye.lang.Objects@27e4e751,
>>>>> id=101,
>>>>> version=1]
>>>>> [EL Finer]: 2008.11.18
>>>>> 08:26:25.583--UnitOfWork(616939444)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--begin
>>>>> unit of work commit
>>>>> [EL Finer]: 2008.11.18
>>>>> 08:26:25.584--UnitOfWork(616939444)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--end
>>>>> unit of work commit
>>>>> [EL Finer]: 2008.11.18
>>>>> 08:26:25.584--UnitOfWork(616939444)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--resume
>>>>> unit of work
>>>>> [EL Finer]: 2008.11.18
>>>>> 08:26:27.351--UnitOfWork(616939444)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--release
>>>>> unit of work
>>>>> [EL Finer]: 2008.11.18
>>>>> 08:26:27.352--ClientSession(1319818785)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--client
>>>>> released
>>>>> [EL Finer]: 2008.11.18
>>>>> 08:26:27.549--ServerSession(290077830)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--client
>>>>> acquired
>>>>> [EL Finest]: 2008.11.18
>>>>> 08:26:27.550--UnitOfWork(567212311)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--Execute
>>>>> query ReadObjectQuery(adcaster.server.domain.Media)
>>>>> [EL Finer]: 2008.11.18
>>>>> 08:26:27.550--UnitOfWork(567212311)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--begin
>>>>> unit of work commit
>>>>> [EL Finer]: 2008.11.18
>>>>> 08:26:27.550--UnitOfWork(567212311)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--end
>>>>> unit of work commit
>>>>> [EL Finer]: 2008.11.18
>>>>> 08:26:27.551--UnitOfWork(567212311)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--resume
>>>>> unit of work
>>>>> [EL Finest]: 2008.11.18
>>>>> 08:26:27.551--UnitOfWork(567212311)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--Execute
>>>>> query ReadAllQuery(adcaster.server.domain.MediaVersion)
>>>>> [EL Finest]: 2008.11.18
>>>>> 08:26:27.552--ServerSession(290077830)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--reconnecting
>>>>> to external connection pool
>>>>> [EL Fine]: 2008.11.18
>>>>> 08:26:27.552--ServerSession(290077830)--Connection(577145991)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--SELECT
>>>>> ID, NAME, VERSION, data_, MEDIA_ID FROM media_version WHERE ((MEDIA_ID
>>>>> =
>>>>> ?)
>>>>> AND (VERSION = ?))
>>>>>        bind => [101, 9]
>>>>> [EL Finest]: 2008.11.18
>>>>> 08:26:27.553--UnitOfWork(567212311)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--Register
>>>>> the existing object
>>>>> adcaster.server.domain.MediaVersion[objects=blueeye.lang.Objects@48b85e03,
>>>>> id=551,
>>>>> media=adcaster.server.domain.Media[objects=blueeye.lang.Objects@27e4e751,
>>>>> id=101, version=1], version=9, data=[46, 46, 46, 99, 111, 110, 116,
>>>>> 101,
>>>>> 110, 116, 115, 32, 111, 102, 32, 102, 105, 108, 101, 50, 46, 103, 105,
>>>>> 102,
>>>>> 46, 46, 46], name=Media2]
>>>>> [EL Finest]: 2008.11.18
>>>>> 08:26:27.554--UnitOfWork(567212311)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--Register
>>>>> the existing object
>>>>> adcaster.server.domain.Media[objects=blueeye.lang.Objects@27e4e751,
>>>>> id=101,
>>>>> version=1]
>>>>> [EL Finer]: 2008.11.18
>>>>> 08:26:27.554--UnitOfWork(567212311)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--begin
>>>>> unit of work commit
>>>>> [EL Finer]: 2008.11.18
>>>>> 08:26:27.554--UnitOfWork(567212311)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--end
>>>>> unit of work commit
>>>>> [EL Finer]: 2008.11.18
>>>>> 08:26:27.555--UnitOfWork(567212311)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--resume
>>>>> unit of work
>>>>> [EL Finest]: 2008.11.18
>>>>> 08:26:27.556--UnitOfWork(567212311)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--Execute
>>>>> query ReadAllQuery(adcaster.server.domain.MediaVersion)
>>>>> [EL Finest]: 2008.11.18
>>>>> 08:26:27.556--ServerSession(290077830)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--reconnecting
>>>>> to external connection pool
>>>>> [EL Fine]: 2008.11.18
>>>>> 08:26:27.556--ServerSession(290077830)--Connection(1249576400)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--SELECT
>>>>> ID, NAME, VERSION, data_, MEDIA_ID FROM media_version WHERE ((MEDIA_ID
>>>>> =
>>>>> ?)
>>>>> AND (VERSION = ?))
>>>>>        bind => [101, 10]
>>>>> [EL Finer]: 2008.11.18
>>>>> 08:26:27.557--UnitOfWork(567212311)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--begin
>>>>> unit of work commit
>>>>> [EL Finer]: 2008.11.18
>>>>> 08:26:27.558--UnitOfWork(567212311)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--end
>>>>> unit of work commit
>>>>> [EL Finer]: 2008.11.18
>>>>> 08:26:27.558--UnitOfWork(567212311)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--resume
>>>>> unit of work
>>>>> [EL Finest]: 2008.11.18
>>>>> 08:26:27.558--UnitOfWork(567212311)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--Execute
>>>>> query ReadAllQuery(adcaster.server.domain.MediaVersion)
>>>>> [EL Finest]: 2008.11.18
>>>>> 08:26:27.558--ServerSession(290077830)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--reconnecting
>>>>> to external connection pool
>>>>> [EL Fine]: 2008.11.18
>>>>> 08:26:27.559--ServerSession(290077830)--Connection(1521339340)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--SELECT
>>>>> ID, NAME, VERSION, data_, MEDIA_ID FROM media_version WHERE ((MEDIA_ID
>>>>> =
>>>>> ?)
>>>>> AND (VERSION = ?))
>>>>>        bind => [101, 8]
>>>>> [EL Finest]: 2008.11.18
>>>>> 08:26:27.560--UnitOfWork(567212311)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--Register
>>>>> the existing object
>>>>> adcaster.server.domain.MediaVersion[objects=blueeye.lang.Objects@48b85e03,
>>>>> id=502,
>>>>> media=adcaster.server.domain.Media[objects=blueeye.lang.Objects@27e4e751,
>>>>> id=101, version=1], version=8, data=[46, 46, 46, 99, 111, 110, 116,
>>>>> 101,
>>>>> 110, 116, 115, 32, 111, 102, 32, 102, 105, 108, 101, 50, 46, 103, 105,
>>>>> 102,
>>>>> 46, 46, 46], name=Media2]
>>>>> [EL Finest]: 2008.11.18
>>>>> 08:26:27.560--UnitOfWork(567212311)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--Register
>>>>> the existing object
>>>>> adcaster.server.domain.Media[objects=blueeye.lang.Objects@27e4e751,
>>>>> id=101,
>>>>> version=1]
>>>>> [EL Finer]: 2008.11.18
>>>>> 08:26:27.561--UnitOfWork(567212311)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--begin
>>>>> unit of work commit
>>>>> [EL Finer]: 2008.11.18
>>>>> 08:26:27.561--UnitOfWork(567212311)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--end
>>>>> unit of work commit
>>>>> [EL Finer]: 2008.11.18
>>>>> 08:26:27.561--UnitOfWork(567212311)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--resume
>>>>> unit of work
>>>>> [EL Finer]: 2008.11.18
>>>>> 08:26:27.562--UnitOfWork(567212311)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--release
>>>>> unit of work
>>>>> [EL Finer]: 2008.11.18
>>>>> 08:26:27.563--ClientSession(2128871984)--Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--client
>>>>> released
>>>>> [EL Finer]: 2008.11.18
>>>>> 08:26:27.614--ServerSession(290077830)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--client
>>>>> acquired
>>>>> [EL Finest]: 2008.11.18
>>>>> 08:26:27.614--UnitOfWork(726392421)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Execute
>>>>> query ReadObjectQuery(adcaster.server.domain.Media)
>>>>> [EL Finer]: 2008.11.18
>>>>> 08:26:27.615--UnitOfWork(726392421)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--begin
>>>>> unit of work commit
>>>>> [EL Finer]: 2008.11.18
>>>>> 08:26:27.615--UnitOfWork(726392421)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--end
>>>>> unit of work commit
>>>>> [EL Finer]: 2008.11.18
>>>>> 08:26:27.615--UnitOfWork(726392421)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--resume
>>>>> unit of work
>>>>> [EL Finest]: 2008.11.18
>>>>> 08:26:27.616--UnitOfWork(726392421)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Execute
>>>>> query ReadAllQuery(adcaster.server.domain.MediaVersion)
>>>>> [EL Finest]: 2008.11.18
>>>>> 08:26:27.617--ServerSession(290077830)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--reconnecting
>>>>> to external connection pool
>>>>> [EL Fine]: 2008.11.18
>>>>> 08:26:27.617--ServerSession(290077830)--Connection(1545852605)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--SELECT
>>>>> ID, NAME, VERSION, data_, MEDIA_ID FROM media_version WHERE ((MEDIA_ID
>>>>> =
>>>>> ?)
>>>>> AND (VERSION = ?))
>>>>>        bind => [101, 9]
>>>>> [EL Finest]: 2008.11.18
>>>>> 08:26:27.619--UnitOfWork(726392421)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register
>>>>> the existing object
>>>>> adcaster.server.domain.MediaVersion[objects=blueeye.lang.Objects@48b85e03,
>>>>> id=551,
>>>>> media=adcaster.server.domain.Media[objects=blueeye.lang.Objects@27e4e751,
>>>>> id=101, version=1], version=9, data=[46, 46, 46, 99, 111, 110, 116,
>>>>> 101,
>>>>> 110, 116, 115, 32, 111, 102, 32, 102, 105, 108, 101, 50, 46, 103, 105,
>>>>> 102,
>>>>> 46, 46, 46], name=Media2]
>>>>> [EL Finest]: 2008.11.18
>>>>> 08:26:27.619--UnitOfWork(726392421)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register
>>>>> the existing object
>>>>> adcaster.server.domain.Media[objects=blueeye.lang.Objects@27e4e751,
>>>>> id=101,
>>>>> version=1]
>>>>> [EL Finer]: 2008.11.18
>>>>> 08:26:27.619--UnitOfWork(726392421)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--begin
>>>>> unit of work commit
>>>>> [EL Finer]: 2008.11.18
>>>>> 08:26:27.620--UnitOfWork(726392421)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--end
>>>>> unit of work commit
>>>>> [EL Finer]: 2008.11.18
>>>>> 08:26:27.620--UnitOfWork(726392421)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--resume
>>>>> unit of work
>>>>> [EL Finest]: 2008.11.18
>>>>> 08:26:27.621--UnitOfWork(726392421)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Execute
>>>>> query ReadAllQuery(adcaster.server.domain.MediaVersion)
>>>>> [EL Finest]: 2008.11.18
>>>>> 08:26:27.622--ServerSession(290077830)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--reconnecting
>>>>> to external connection pool
>>>>> [EL Fine]: 2008.11.18
>>>>> 08:26:27.622--ServerSession(290077830)--Connection(1232567244)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--SELECT
>>>>> ID, NAME, VERSION, data_, MEDIA_ID FROM media_version WHERE ((MEDIA_ID
>>>>> =
>>>>> ?)
>>>>> AND (VERSION = ?))
>>>>>        bind => [101, 10]
>>>>> [EL Finer]: 2008.11.18
>>>>> 08:26:27.623--UnitOfWork(726392421)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--begin
>>>>> unit of work commit
>>>>> [EL Finer]: 2008.11.18
>>>>> 08:26:27.624--UnitOfWork(726392421)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--end
>>>>> unit of work commit
>>>>> [EL Finer]: 2008.11.18
>>>>> 08:26:27.624--UnitOfWork(726392421)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--resume
>>>>> unit of work
>>>>> [EL Finest]: 2008.11.18
>>>>> 08:26:27.625--UnitOfWork(726392421)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Execute
>>>>> query ReadAllQuery(adcaster.server.domain.MediaVersion)
>>>>> [EL Finest]: 2008.11.18
>>>>> 08:26:27.625--ServerSession(290077830)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--reconnecting
>>>>> to external connection pool
>>>>> [EL Fine]: 2008.11.18
>>>>> 08:26:27.625--ServerSession(290077830)--Connection(139849089)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--SELECT
>>>>> ID, NAME, VERSION, data_, MEDIA_ID FROM media_version WHERE ((MEDIA_ID
>>>>> =
>>>>> ?)
>>>>> AND (VERSION = ?))
>>>>>        bind => [101, 8]
>>>>> [EL Finest]: 2008.11.18
>>>>> 08:26:27.627--UnitOfWork(726392421)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register
>>>>> the existing object
>>>>> adcaster.server.domain.MediaVersion[objects=blueeye.lang.Objects@48b85e03,
>>>>> id=502,
>>>>> media=adcaster.server.domain.Media[objects=blueeye.lang.Objects@27e4e751,
>>>>> id=101, version=1], version=8, data=[46, 46, 46, 99, 111, 110, 116,
>>>>> 101,
>>>>> 110, 116, 115, 32, 111, 102, 32, 102, 105, 108, 101, 50, 46, 103, 105,
>>>>> 102,
>>>>> 46, 46, 46], name=Media2]
>>>>> [EL Finest]: 2008.11.18
>>>>> 08:26:27.627--UnitOfWork(726392421)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register
>>>>> the existing object
>>>>> adcaster.server.domain.Media[objects=blueeye.lang.Objects@27e4e751,
>>>>> id=101,
>>>>> version=1]
>>>>> [EL Finer]: 2008.11.18
>>>>> 08:26:27.627--UnitOfWork(726392421)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--begin
>>>>> unit of work commit
>>>>> [EL Finer]: 2008.11.18
>>>>> 08:26:27.628--UnitOfWork(726392421)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--end
>>>>> unit of work commit
>>>>> [EL Finer]: 2008.11.18
>>>>> 08:26:27.628--UnitOfWork(726392421)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--resume
>>>>> unit of work
>>>>> [EL Finer]: 2008.11.18
>>>>> 08:26:27.629--UnitOfWork(726392421)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--release
>>>>> unit of work
>>>>> [EL Finer]: 2008.11.18
>>>>> 08:26:27.629--ClientSession(256032021)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--client
>>>>> released
>>>>> ----------------------------------------
>>>>>
>>>>> Thanks,
>>>>> Gili
>>>>> --
>>>>> View this message in context:
>>>>> http://www.nabble.com/Query-returning-stale-results-existing-tp20559804p20559804.html
>>>>> Sent from the EclipseLink - Users mailing list archive at Nabble.com.
>>>>>
>>>>> _______________________________________________
>>>>> eclipselink-users mailing list
>>>>> eclipselink-users@xxxxxxxxxxx
>>>>> https://dev.eclipse.org/mailman/listinfo/eclipselink-users
>>>>>
>>>> _______________________________________________
>>>> eclipselink-users mailing list
>>>> eclipselink-users@xxxxxxxxxxx
>>>> https://dev.eclipse.org/mailman/listinfo/eclipselink-users
>>>>
>>>>
>>>
>>> --
>>> View this message in context:
>>> http://www.nabble.com/Query-returning-stale-results-existing-tp20559804p20564772.html
>>> Sent from the EclipseLink - Users mailing list archive at Nabble.com.
>>>
>>> _______________________________________________
>>> eclipselink-users mailing list
>>> eclipselink-users@xxxxxxxxxxx
>>> https://dev.eclipse.org/mailman/listinfo/eclipselink-users
>>>
>> _______________________________________________
>> eclipselink-users mailing list
>> eclipselink-users@xxxxxxxxxxx
>> https://dev.eclipse.org/mailman/listinfo/eclipselink-users
>> 
>> 
> 
> 

-- 
View this message in context: http://www.nabble.com/Query-returning-stale-results-existing-tp20559804p20565632.html
Sent from the EclipseLink - Users mailing list archive at Nabble.com.
Follow-Ups:
- Re: [eclipselink-users] Query returning stale results existing
  - From: James Sutherland
References:
- [eclipselink-users] Query returning stale results existing
  - From: cowwoc
- Re: [eclipselink-users] Query returning stale results existing
  - From: Tim Hollosy
- Re: [eclipselink-users] Query returning stale results existing
  - From: cowwoc
- Re: [eclipselink-users] Query returning stale results existing
  - From: Tim Hollosy
- Re: [eclipselink-users] Query returning stale results existing
  - From: cowwoc
Prev by Date: [eclipselink-users] Documentation clarification
Next by Date: Re: [eclipselink-users] Query returning stale results existing
Previous by thread: Re: [eclipselink-users] Query returning stale results existing
Next by thread: Re: [eclipselink-users] Query returning stale results existing
Index(es):
- Date
- Thread
Breadcrumbs
