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: "Tim Hollosy" <hollosyt@xxxxxxxxx>
Date: Tue, 18 Nov 2008 09:10:36 -0500
Delivered-to: eclipselink-users@xxxxxxxxxxx
Domainkey-signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=OAE0yUYWxzgtaL7h1aLT4fHhh1yIrZylTHgY2CY31E8drVmUoRpigS5JCwQC/7zvwQ MlBs3ApGy59L5sOJArEFg2ulMHKFPT9O1km0P2aYtfnVbUeXoboPi6JdNbJf5aac3adw agFtH6b0AvRV2G1U43Y8dtCwyDr2dcnCI/u3Q=
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>
James,
Just to be clear, even if you're in isolated mode you'll still have an
EntityManager cache correct?

So if I had executed a stored procedure that touched 4 different
tables, I'd have to make sure to grab fresh entities from those tables
while still in that EntityManager, correct?

./tch



On Tue, Nov 18, 2008 at 9:08 AM, James Sutherland <jamesssss@xxxxxxxxx> wrote:
>
> If you do not want to have a cache, you can disable the cache using the
> persistence.xml property,
>
> "eclipselink.cache.shared.default"="false"
>
>
> 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
>>
>>
>
>
> -----
> ---
> http://wiki.eclipse.org/User:James.sutherland.oracle.com James Sutherland
> http://www.eclipse.org/eclipselink/
>  EclipseLink ,  http://www.oracle.com/technology/products/ias/toplink/
> TopLink
> Wiki:  http://wiki.eclipse.org/EclipseLink EclipseLink ,
> http://wiki.oracle.com/page/TopLink TopLink
> Forums:  http://forums.oracle.com/forums/forum.jspa?forumID=48 TopLink ,
> http://www.nabble.com/EclipseLink-f26430.html EclipseLink
> Book:  http://en.wikibooks.org/wiki/Java_Persistence Java Persistence
> --
> View this message in context: http://www.nabble.com/Query-returning-stale-results-existing-tp20559804p20560308.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
>
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: James Sutherland
Prev by Date: Re: [eclipselink-users] Query returning stale results existing
Next by Date: Re: [eclipselink-users] What am I missing?
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
