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 09:50:36 -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>
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.
Follow-Ups:
- Re: [eclipselink-users] Query returning stale results existing
  - From: Tim Hollosy
References:
- [eclipselink-users] Query returning stale results existing
  - From: cowwoc
- Re: [eclipselink-users] Query returning stale results existing
  - From: Tim Hollosy
Prev by Date: Re: [eclipselink-users] What am I missing?
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
