Query returning stale results existing
|
View:
New views
18 Messages
—
Rating Filter:
Alert me
|
 |
Query returning stale results existing
by cowwoc
::
Rate this Message:
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 |
|
|
Re: Query returning stale results existing
by tch
::
Rate this Message:
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@...> 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@... > https://dev.eclipse.org/mailman/listinfo/eclipselink-users > eclipselink-users mailing list eclipselink-users@... https://dev.eclipse.org/mailman/listinfo/eclipselink-users |
|
|
Re: Query returning stale results existing
by James Sutherland
::
Rate this Message:
If you do not want to have a cache, you can disable the cache using the persistence.xml property,
"eclipselink.cache.shared.default"="false"
James Sutherland EclipseLink, TopLink Wiki: EclipseLink, TopLink Forums: TopLink, EclipseLink Book: Java Persistence |
|
|
Re: Query returning stale results existing
by tch
::
Rate this Message:
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@...> 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@...> 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@... >>> https://dev.eclipse.org/mailman/listinfo/eclipselink-users >>> >> _______________________________________________ >> eclipselink-users mailing list >> eclipselink-users@... >> 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@... > https://dev.eclipse.org/mailman/listinfo/eclipselink-users > eclipselink-users mailing list eclipselink-users@... https://dev.eclipse.org/mailman/listinfo/eclipselink-users |
|
|
Re: Query returning stale results existing
by cowwoc
::
Rate this Message:
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
|
|
|
Re: Query returning stale results existing
by tch
::
Rate this Message:
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@...> 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@...> 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@... >>> https://dev.eclipse.org/mailman/listinfo/eclipselink-users >>> >> _______________________________________________ >> eclipselink-users mailing list >> eclipselink-users@... >> 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@... > https://dev.eclipse.org/mailman/listinfo/eclipselink-users > eclipselink-users mailing list eclipselink-users@... https://dev.eclipse.org/mailman/listinfo/eclipselink-users |
|
|
Re: Query returning stale results existing
by cowwoc
::
Rate this Message:
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
|
|
|
Re: Query returning stale results existing
by cowwoc
::
Rate this Message:
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
|
|
|
Re: Query returning stale results existing
by Neil Hauge
::
Rate this Message:
Gili,
The EclipseLink Workbench is intended for EclipseLink's native POJO ORM API, MOXy, and EIS development, but does not support JPA. Eclipse based JPA tooling for EclipseLink is available via the Dali project (http://www.eclipse.org/dali). In the 2.0 release (part of WTP 3.0) you will find support for EclipseLink specific persistence.xml properties, such as caching. The upcoming 2.1 release in December will support EclipseLink specific annotations and the EL XML Mapping File. Cache expiration can also be configured in the EclipseLink XML mapping file - http://wiki.eclipse.org/EclipseLink/Examples/JPA/EclipseLink-ORM.XML. Dali 2.1 will support both of these configurations via the UI. Neil 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@... 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@... wrote: _______________________________________________ eclipselink-users mailing list eclipselink-users@... https://dev.eclipse.org/mailman/listinfo/eclipselink-users |
|
|
Re: Query returning stale results existing
by James Sutherland
::
Rate this Message:
EntityManager.refresh() is the only way in the JPA spec to ensure an object is refreshed. If you use optimistic locking or the the read lock() API you can guarantee that the transaction will fail if the object is out of date.
EclipseLink also defines a Query hint "eclipselink.refresh" to allow a query to force a refresh. The are also may different caching options, such as invalidation, auto-refreshing, isolation, and cache coordination. >> 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")? I'm not sure where you found this in the docs, but it is wrong or at best confusing. You can absolutely use @GeneratedValue with an isolated session.
|
|
|
Re: Query returning stale results existing
by James Sutherland
::
Rate this Message:
Yes, the EntityManager will still maintain a cache of all objects read in its transaction context (JTA managed/JEE) or life-cycle (application managed/JSE). If you do not want to cache objects across transaction boundaries in JSE, then you should create a new EntityManager for each transaction/interaction.
James Sutherland EclipseLink, TopLink Wiki: EclipseLink, TopLink Forums: TopLink, EclipseLink Book: Java Persistence |
|
|
Re: Query returning stale results existing
by David Parker-10
::
Rate this Message:
Could somebody point me to some doc on using query hints? I didn't
realize this existed at the eclipselink level. Thanks. - DAP On Nov 19, 2008, at 9:09 AM, James Sutherland wrote: > > EntityManager.refresh() is the only way in the JPA spec to ensure an > object > is refreshed. If you use optimistic locking or the the read lock() > API you > can guarantee that the transaction will fail if the object is out of > date. > > EclipseLink also defines a Query hint "eclipselink.refresh" to allow > a query > to force a refresh. The are also may different caching options, > such as > invalidation, auto-refreshing, isolation, and cache coordination. > >>> 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")? > > I'm not sure where you found this in the docs, but it is wrong or at > best > confusing. You can absolutely use @GeneratedValue with an isolated > session. > > > > cowwoc wrote: >> >> 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@...> >>>> 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@...> >>>>>> 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 >>>> >>> >>> >> >> > > > ----- > --- > 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-tp20559804p20580548.html > Sent from the EclipseLink - Users mailing list archive at Nabble.com. > > _______________________________________________ > eclipselink-users mailing list > eclipselink-users@... > https://dev.eclipse.org/mailman/listinfo/eclipselink-users aloha -- DAP ===================================================== David Parker david@... "If you want sense you'll have to make it yourself" - The Dodecahedron _______________________________________________ eclipselink-users mailing list eclipselink-users@... https://dev.eclipse.org/mailman/listinfo/eclipselink-users |
|
|
Re: Query returning stale results existing
by tch
::
Rate this Message:
http://wiki.eclipse.org/Using_EclipseLink_JPA_Extensions_(ELUG)#How_to_Use_EclipseLink_JPA_Query_Hints
Also here's a little method I wrote to add a hint to prevent caching on any query: public static void setNoCacheHints(Query q) { q.setHint(QueryHints.REFRESH, HintValues.TRUE); } ./tch On Wed, Nov 19, 2008 at 10:06 AM, David Parker <david@...> wrote: > Could somebody point me to some doc on using query hints? I didn't realize > this existed at the eclipselink level. > > Thanks. > > - DAP > > On Nov 19, 2008, at 9:09 AM, James Sutherland wrote: > >> >> EntityManager.refresh() is the only way in the JPA spec to ensure an >> object >> is refreshed. If you use optimistic locking or the the read lock() API >> you >> can guarantee that the transaction will fail if the object is out of date. >> >> EclipseLink also defines a Query hint "eclipselink.refresh" to allow a >> query >> to force a refresh. The are also may different caching options, such as >> invalidation, auto-refreshing, isolation, and cache coordination. >> >>>> 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")? >> >> I'm not sure where you found this in the docs, but it is wrong or at best >> confusing. You can absolutely use @GeneratedValue with an isolated >> session. >> >> >> >> cowwoc wrote: >>> >>> 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@...> >>>>> 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@...> >>>>>>> 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 >>>>> >>>> >>>> >>> >>> >> >> >> ----- >> --- >> 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-tp20559804p20580548.html >> Sent from the EclipseLink - Users mailing list archive at Nabble.com. >> >> _______________________________________________ >> eclipselink-users mailing list >> eclipselink-users@... >> https://dev.eclipse.org/mailman/listinfo/eclipselink-users > > aloha > > -- DAP > ===================================================== > David Parker > david@... > > "If you want sense you'll have to make it yourself" > > - The Dodecahedron > > > > > > > _______________________________________________ > eclipselink-users mailing list > eclipselink-users@... > https://dev.eclipse.org/mailman/listinfo/eclipselink-users > eclipselink-users mailing list eclipselink-users@... https://dev.eclipse.org/mailman/listinfo/eclipselink-users |
|
|
Re: Query returning stale results existing
by cowwoc
::
Rate this Message:
Okay, then you might want to fix it at http://wiki.eclipse.org/Introduction_to_EclipseLink_Sessions_(ELUG)#Sequencing Thank you, Gili |
|
|
Re: Query returning stale results existing
by cowwoc
::
Rate this Message:
EntityManager.refresh() worked :) PS: It would be nice if cache expiration settings were available at the persistence.xml level. Ideally I want to isolate all EclipseLink-specific features to that file and keep my classes portable across all JPA implementations. Thank you, Gili |
|
|
Re: Query returning stale results existing
by James Sutherland
::
Rate this Message:
You can set cache setting per class in the EclipseLink orm XML file. This file can be used to supplement annotations or the JPA orm XML file, and will be ignored by other JPA implementations, so is a portable way. You can also use the @Cache annotation, which is still portable as it will be ignored by other JPA implementation, but does require a compile dependency.
persistence.xml properties can only do so much, more advanced settings need a real XML file.
James Sutherland EclipseLink, TopLink Wiki: EclipseLink, TopLink Forums: TopLink, EclipseLink Book: Java Persistence |
|
|
Re: Query returning stale results existing
by James Sutherland
::
Rate this Message:
Thanks, I updated the wiki.
What this was referring to was VPD security, not isolated sessions. When using VPD you have to give access to your sequence table or objects to the sequence connection pool user login, otherwise it will not be able to allocate the sequence.
James Sutherland EclipseLink, TopLink Wiki: EclipseLink, TopLink Forums: TopLink, EclipseLink Book: Java Persistence |
|
|
Re: Query returning stale results existing
by tch
::
Rate this Message:
Don't forget this bug when working with @Cache settings:
https://bugs.eclipse.org/bugs/show_bug.cgi?id=231843 To Quote Shawn: "If you define a "default" cache type in persistence.xml then this is not treated like a default but rather as a global override and any cache type setting in either annotations or mapping files are ignored thus rendering it impossible to configure caches on an Entity by Entity basis." ./tch On Thu, Nov 20, 2008 at 9:21 AM, James Sutherland <jamesssss@...> wrote: > > You can set cache setting per class in the EclipseLink orm XML file. This > file can be used to supplement annotations or the JPA orm XML file, and will > be ignored by other JPA implementations, so is a portable way. You can also > use the @Cache annotation, which is still portable as it will be ignored by > other JPA implementation, but does require a compile dependency. > > persistence.xml properties can only do so much, more advanced settings need > a real XML file. > > > > cowwoc wrote: >> >> >> James Sutherland wrote: >>> >>> EntityManager.refresh() is the only way in the JPA spec to ensure an >>> object is refreshed. If you use optimistic locking or the the read >>> lock() API you can guarantee that the transaction will fail if the object >>> is out of date. >>> >>> EclipseLink also defines a Query hint "eclipselink.refresh" to allow a >>> query to force a refresh. The are also may different caching options, >>> such as invalidation, auto-refreshing, isolation, and cache coordination. >>> >> >> EntityManager.refresh() worked :) >> >> PS: It would be nice if cache expiration settings were available at the >> persistence.xml level. Ideally I want to isolate all EclipseLink-specific >> features to that file and keep my classes portable across all JPA >> implementations. >> >> Thank you, >> Gili >> > > > ----- > --- > 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-tp20559804p20602036.html > Sent from the EclipseLink - Users mailing list archive at Nabble.com. > > _______________________________________________ > eclipselink-users mailing list > eclipselink-users@... > https://dev.eclipse.org/mailman/listinfo/eclipselink-users > eclipselink-users mailing list eclipselink-users@... https://dev.eclipse.org/mailman/listinfo/eclipselink-users |
| Free embeddable forum powered by Nabble | Forum Help |
