Skip to main content
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
Re: [eclipselink-users] Query returning stale results existing
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@xxxxxxxxxxxxxxxx>
wrote:
I am familiar with the 2nd-level cache, except that for Hibernate it 
was off
by default (because of these kinds of side-effects).

I found this kind of surprising too: "EclipseLink does not access
sequencing
objects using the isolated session's dedicated connection, and so the sequence values are not available to the isolated session." Really? So 
I
can't use @GeneratedValue(generator = "foo")?

It isn't clear from
http://wiki.eclipse.org/Configuring_a_Project_(ELUG)#Configuring_Cache_Isolation_at_the_Project_Level
how to configure this without the workbench (which I don't use). How do 
I
configure this from Java code or persistence.xml?

To be honest, I find this documentation to be an exercise in
frustration. It
jumps from one document to another with very little example code. Very 
often
the only example given requires the use of the workbench GUI. That's 
nice,
but if there is a portable way for me to do it using JPA code I'd
prefer
that instead.

Gili


Tim Hollosy wrote:
Remember EclipseLink uses a 2nd Level Cache -- the Shared Cache. This 
is per Entity Manager Factory.

See: http://wiki.eclipse.org/Introduction_to_Cache_(ELUG)

./tch



On Tue, Nov 18, 2008 at 8:40 AM, cowwoc <cowwoc@xxxxxxxxxxxxxxxx>
wrote:


Hi,
I am issuing the same query in subsequent HTTP queries and getting 
back
stale results (cached from the first request). As far as I can tell I 
am
using the Session-Per-HTTP-Request paradigm so this shouldn't be
happening.
I need your help to interpret the EclipseLink logs (included at the 
end
of
this email).
1) Does "client released" mean EntityManager.close() has been issued? 2) What would cause queries to cache results across EntityManagers?
I will now include my log. The first line is issued in request #1, 
the
subsequent lines are issued by subsequent requests. The lines that 
caught
my
eyes were the ones reading "Register the existing object"... I
believe
EclipseLink isn't actually contacting the database.
One warning: media_version.version is *not* the optimistic- locking 
versioning field. It is used purely for business logic.


-------------log----------------------
[EL Finer]: 2008.11.18
08:25:22.872--ClientSession(58019908)-- Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--client 
released
[EL Finer]: 2008.11.18
08:26:25.538--ServerSession(290077830)-- Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--client 
acquired
[EL Finest]: 2008.11.18
08:26:25.539--UnitOfWork(884597793)-- Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--Execute 
query ReadAllQuery(adcaster.server.domain.Media)
[EL Finest]: 2008.11.18
08:26:25.540--ServerSession(290077830)-- Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])-- reconnecting 
to external connection pool
[EL Fine]: 2008.11.18
08:26:25.540--ServerSession(290077830)--Connection(405818770)-- Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--SELECT 
ID, VERSION FROM MEDIA
[EL Finest]: 2008.11.18
08:26:25.542--UnitOfWork(884597793)-- Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--Register 
the existing object
adcaster .server.domain.Media[objects=blueeye.lang.Objects@27e4e751, 
id=101,
version=1]
[EL Finer]: 2008.11.18
08:26:25.543--UnitOfWork(884597793)-- Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--begin 
unit of work commit
[EL Finer]: 2008.11.18
08:26:25.543--UnitOfWork(884597793)-- Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--end 
unit of work commit
[EL Finer]: 2008.11.18
08:26:25.544--UnitOfWork(884597793)-- Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--resume 
unit of work
[EL Finer]: 2008.11.18
08:26:25.544--UnitOfWork(884597793)-- Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--release 
unit of work
[EL Finer]: 2008.11.18
08:26:25.545--ClientSession(2110771332)-- Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--client 
released
[EL Finer]: 2008.11.18
08:26:25.565--ServerSession(290077830)-- Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--client 
acquired
[EL Finest]: 2008.11.18
08:26:25.565--UnitOfWork(616939444)-- Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Execute 
query ReadObjectQuery(adcaster.server.domain.Media)
[EL Finer]: 2008.11.18
08:26:25.566--UnitOfWork(616939444)-- Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--begin 
unit of work commit
[EL Finer]: 2008.11.18
08:26:25.566--UnitOfWork(616939444)-- Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--end 
unit of work commit
[EL Finer]: 2008.11.18
08:26:25.567--UnitOfWork(616939444)-- Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--resume 
unit of work
[EL Finest]: 2008.11.18
08:26:25.567--UnitOfWork(616939444)-- Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Execute 
query ReadAllQuery(adcaster.server.domain.MediaVersion)
[EL Finest]: 2008.11.18
08:26:25.568--ServerSession(290077830)-- Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])-- reconnecting 
to external connection pool
[EL Fine]: 2008.11.18
08:26:25.568--ServerSession(290077830)--Connection(814711173)-- Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--SELECT ID, NAME, VERSION, data_, MEDIA_ID FROM media_version WHERE (MEDIA_ID 
=
?)
ORDER BY VERSION ASC
      bind => [101]
[EL Finest]: 2008.11.18
08:26:25.571--UnitOfWork(616939444)-- Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register 
the existing object
adcaster .server .domain.MediaVersion[objects=blueeye.lang.Objects@48b85e03, 
id=151,
media = adcaster .server.domain.Media[objects=blueeye.lang.Objects@27e4e751, id=101, version=1], version=0, data=[46, 46, 46, 99, 111, 110, 116, 
101,
110, 116, 115, 32, 111, 102, 32, 102, 105, 108, 101, 50, 46, 103, 
105,
102,
46, 46, 46], name=Media2]
[EL Finest]: 2008.11.18
08:26:25.572--UnitOfWork(616939444)-- Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register 
the existing object
adcaster .server.domain.Media[objects=blueeye.lang.Objects@27e4e751, 
id=101,
version=1]
[EL Finest]: 2008.11.18
08:26:25.572--UnitOfWork(616939444)-- Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register 
the existing object
adcaster .server .domain.MediaVersion[objects=blueeye.lang.Objects@48b85e03, 
id=201,
media = adcaster .server.domain.Media[objects=blueeye.lang.Objects@27e4e751, id=101, version=1], version=1, data=[46, 46, 46, 99, 111, 110, 116, 
101,
110, 116, 115, 32, 111, 102, 32, 102, 105, 108, 101, 50, 46, 103, 
105,
102,
46, 46, 46], name=Media2]
[EL Finest]: 2008.11.18
08:26:25.573--UnitOfWork(616939444)-- Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register 
the existing object
adcaster .server.domain.Media[objects=blueeye.lang.Objects@27e4e751, 
id=101,
version=1]
[EL Finest]: 2008.11.18
08:26:25.574--UnitOfWork(616939444)-- Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register 
the existing object
adcaster .server .domain.MediaVersion[objects=blueeye.lang.Objects@48b85e03, 
id=251,
media = adcaster .server.domain.Media[objects=blueeye.lang.Objects@27e4e751, id=101, version=1], version=2, data=[46, 46, 46, 99, 111, 110, 116, 
101,
110, 116, 115, 32, 111, 102, 32, 102, 105, 108, 101, 50, 46, 103, 
105,
102,
46, 46, 46], name=Media2]
[EL Finest]: 2008.11.18
08:26:25.574--UnitOfWork(616939444)-- Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register 
the existing object
adcaster .server.domain.Media[objects=blueeye.lang.Objects@27e4e751, 
id=101,
version=1]
[EL Finest]: 2008.11.18
08:26:25.575--UnitOfWork(616939444)-- Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register 
the existing object
adcaster .server .domain.MediaVersion[objects=blueeye.lang.Objects@48b85e03, 
id=301,
media = adcaster .server.domain.Media[objects=blueeye.lang.Objects@27e4e751, id=101, version=1], version=3, data=[46, 46, 46, 99, 111, 110, 116, 
101,
110, 116, 115, 32, 111, 102, 32, 102, 105, 108, 101, 50, 46, 103, 
105,
102,
46, 46, 46], name=Media2]
[EL Finest]: 2008.11.18
08:26:25.575--UnitOfWork(616939444)-- Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register 
the existing object
adcaster .server.domain.Media[objects=blueeye.lang.Objects@27e4e751, 
id=101,
version=1]
[EL Finest]: 2008.11.18
08:26:25.576--UnitOfWork(616939444)-- Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register 
the existing object
adcaster .server .domain.MediaVersion[objects=blueeye.lang.Objects@48b85e03, 
id=351,
media = adcaster .server.domain.Media[objects=blueeye.lang.Objects@27e4e751, id=101, version=1], version=4, data=[46, 46, 46, 99, 111, 110, 116, 
101,
110, 116, 115, 32, 111, 102, 32, 102, 105, 108, 101, 50, 46, 103, 
105,
102,
46, 46, 46], name=Media2]
[EL Finest]: 2008.11.18
08:26:25.576--UnitOfWork(616939444)-- Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register 
the existing object
adcaster .server.domain.Media[objects=blueeye.lang.Objects@27e4e751, 
id=101,
version=1]
[EL Finest]: 2008.11.18
08:26:25.577--UnitOfWork(616939444)-- Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register 
the existing object
adcaster .server .domain.MediaVersion[objects=blueeye.lang.Objects@48b85e03, 
id=401,
media = adcaster .server.domain.Media[objects=blueeye.lang.Objects@27e4e751, id=101, version=1], version=5, data=[46, 46, 46, 99, 111, 110, 116, 
101,
110, 116, 115, 32, 111, 102, 32, 102, 105, 108, 101, 50, 46, 103, 
105,
102,
46, 46, 46], name=Media2]
[EL Finest]: 2008.11.18
08:26:25.578--UnitOfWork(616939444)-- Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register 
the existing object
adcaster .server.domain.Media[objects=blueeye.lang.Objects@27e4e751, 
id=101,
version=1]
[EL Finest]: 2008.11.18
08:26:25.578--UnitOfWork(616939444)-- Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register 
the existing object
adcaster .server .domain.MediaVersion[objects=blueeye.lang.Objects@48b85e03, 
id=451,
media = adcaster .server.domain.Media[objects=blueeye.lang.Objects@27e4e751, id=101, version=1], version=6, data=[46, 46, 46, 99, 111, 110, 116, 
101,
110, 116, 115, 32, 111, 102, 32, 102, 105, 108, 101, 50, 46, 103, 
105,
102,
46, 46, 46], name=Media2]
[EL Finest]: 2008.11.18
08:26:25.579--UnitOfWork(616939444)-- Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register 
the existing object
adcaster .server.domain.Media[objects=blueeye.lang.Objects@27e4e751, 
id=101,
version=1]
[EL Finest]: 2008.11.18
08:26:25.580--UnitOfWork(616939444)-- Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register 
the existing object
adcaster .server .domain.MediaVersion[objects=blueeye.lang.Objects@48b85e03, 
id=501,
media = adcaster .server.domain.Media[objects=blueeye.lang.Objects@27e4e751, id=101, version=1], version=7, data=[46, 46, 46, 99, 111, 110, 116, 
101,
110, 116, 115, 32, 111, 102, 32, 102, 105, 108, 101, 50, 46, 103, 
105,
102,
46, 46, 46], name=Media2]
[EL Finest]: 2008.11.18
08:26:25.580--UnitOfWork(616939444)-- Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register 
the existing object
adcaster .server.domain.Media[objects=blueeye.lang.Objects@27e4e751, 
id=101,
version=1]
[EL Finest]: 2008.11.18
08:26:25.581--UnitOfWork(616939444)-- Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register 
the existing object
adcaster .server .domain.MediaVersion[objects=blueeye.lang.Objects@48b85e03, 
id=502,
media = adcaster .server.domain.Media[objects=blueeye.lang.Objects@27e4e751, id=101, version=1], version=8, data=[46, 46, 46, 99, 111, 110, 116, 
101,
110, 116, 115, 32, 111, 102, 32, 102, 105, 108, 101, 50, 46, 103, 
105,
102,
46, 46, 46], name=Media2]
[EL Finest]: 2008.11.18
08:26:25.581--UnitOfWork(616939444)-- Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register 
the existing object
adcaster .server.domain.Media[objects=blueeye.lang.Objects@27e4e751, 
id=101,
version=1]
[EL Finest]: 2008.11.18
08:26:25.582--UnitOfWork(616939444)-- Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register 
the existing object
adcaster .server .domain.MediaVersion[objects=blueeye.lang.Objects@48b85e03, 
id=551,
media = adcaster .server.domain.Media[objects=blueeye.lang.Objects@27e4e751, id=101, version=1], version=9, data=[46, 46, 46, 99, 111, 110, 116, 
101,
110, 116, 115, 32, 111, 102, 32, 102, 105, 108, 101, 50, 46, 103, 
105,
102,
46, 46, 46], name=Media2]
[EL Finest]: 2008.11.18
08:26:25.583--UnitOfWork(616939444)-- Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register 
the existing object
adcaster .server.domain.Media[objects=blueeye.lang.Objects@27e4e751, 
id=101,
version=1]
[EL Finer]: 2008.11.18
08:26:25.583--UnitOfWork(616939444)-- Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--begin 
unit of work commit
[EL Finer]: 2008.11.18
08:26:25.584--UnitOfWork(616939444)-- Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--end 
unit of work commit
[EL Finer]: 2008.11.18
08:26:25.584--UnitOfWork(616939444)-- Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--resume 
unit of work
[EL Finer]: 2008.11.18
08:26:27.351--UnitOfWork(616939444)-- Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--release 
unit of work
[EL Finer]: 2008.11.18
08:26:27.352--ClientSession(1319818785)-- Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--client 
released
[EL Finer]: 2008.11.18
08:26:27.549--ServerSession(290077830)-- Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--client 
acquired
[EL Finest]: 2008.11.18
08:26:27.550--UnitOfWork(567212311)-- Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--Execute 
query ReadObjectQuery(adcaster.server.domain.Media)
[EL Finer]: 2008.11.18
08:26:27.550--UnitOfWork(567212311)-- Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--begin 
unit of work commit
[EL Finer]: 2008.11.18
08:26:27.550--UnitOfWork(567212311)-- Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--end 
unit of work commit
[EL Finer]: 2008.11.18
08:26:27.551--UnitOfWork(567212311)-- Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--resume 
unit of work
[EL Finest]: 2008.11.18
08:26:27.551--UnitOfWork(567212311)-- Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--Execute 
query ReadAllQuery(adcaster.server.domain.MediaVersion)
[EL Finest]: 2008.11.18
08:26:27.552--ServerSession(290077830)-- Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])-- reconnecting 
to external connection pool
[EL Fine]: 2008.11.18
08:26:27.552--ServerSession(290077830)--Connection(577145991)-- Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--SELECT 
ID, NAME, VERSION, data_, MEDIA_ID FROM media_version WHERE
((MEDIA_ID =
?)
AND (VERSION = ?))
      bind => [101, 9]
[EL Finest]: 2008.11.18
08:26:27.553--UnitOfWork(567212311)-- Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--Register 
the existing object
adcaster .server .domain.MediaVersion[objects=blueeye.lang.Objects@48b85e03, 
id=551,
media = adcaster .server.domain.Media[objects=blueeye.lang.Objects@27e4e751, id=101, version=1], version=9, data=[46, 46, 46, 99, 111, 110, 116, 
101,
110, 116, 115, 32, 111, 102, 32, 102, 105, 108, 101, 50, 46, 103, 
105,
102,
46, 46, 46], name=Media2]
[EL Finest]: 2008.11.18
08:26:27.554--UnitOfWork(567212311)-- Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--Register 
the existing object
adcaster .server.domain.Media[objects=blueeye.lang.Objects@27e4e751, 
id=101,
version=1]
[EL Finer]: 2008.11.18
08:26:27.554--UnitOfWork(567212311)-- Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--begin 
unit of work commit
[EL Finer]: 2008.11.18
08:26:27.554--UnitOfWork(567212311)-- Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--end 
unit of work commit
[EL Finer]: 2008.11.18
08:26:27.555--UnitOfWork(567212311)-- Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--resume 
unit of work
[EL Finest]: 2008.11.18
08:26:27.556--UnitOfWork(567212311)-- Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--Execute 
query ReadAllQuery(adcaster.server.domain.MediaVersion)
[EL Finest]: 2008.11.18
08:26:27.556--ServerSession(290077830)-- Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])-- reconnecting 
to external connection pool
[EL Fine]: 2008.11.18
08:26:27.556--ServerSession(290077830)-- Connection(1249576400)-- Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--SELECT 
ID, NAME, VERSION, data_, MEDIA_ID FROM media_version WHERE
((MEDIA_ID =
?)
AND (VERSION = ?))
      bind => [101, 10]
[EL Finer]: 2008.11.18
08:26:27.557--UnitOfWork(567212311)-- Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--begin 
unit of work commit
[EL Finer]: 2008.11.18
08:26:27.558--UnitOfWork(567212311)-- Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--end 
unit of work commit
[EL Finer]: 2008.11.18
08:26:27.558--UnitOfWork(567212311)-- Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--resume 
unit of work
[EL Finest]: 2008.11.18
08:26:27.558--UnitOfWork(567212311)-- Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--Execute 
query ReadAllQuery(adcaster.server.domain.MediaVersion)
[EL Finest]: 2008.11.18
08:26:27.558--ServerSession(290077830)-- Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])-- reconnecting 
to external connection pool
[EL Fine]: 2008.11.18
08:26:27.559--ServerSession(290077830)-- Connection(1521339340)-- Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--SELECT 
ID, NAME, VERSION, data_, MEDIA_ID FROM media_version WHERE
((MEDIA_ID =
?)
AND (VERSION = ?))
      bind => [101, 8]
[EL Finest]: 2008.11.18
08:26:27.560--UnitOfWork(567212311)-- Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--Register 
the existing object
adcaster .server .domain.MediaVersion[objects=blueeye.lang.Objects@48b85e03, 
id=502,
media = adcaster .server.domain.Media[objects=blueeye.lang.Objects@27e4e751, id=101, version=1], version=8, data=[46, 46, 46, 99, 111, 110, 116, 
101,
110, 116, 115, 32, 111, 102, 32, 102, 105, 108, 101, 50, 46, 103, 
105,
102,
46, 46, 46], name=Media2]
[EL Finest]: 2008.11.18
08:26:27.560--UnitOfWork(567212311)-- Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--Register 
the existing object
adcaster .server.domain.Media[objects=blueeye.lang.Objects@27e4e751, 
id=101,
version=1]
[EL Finer]: 2008.11.18
08:26:27.561--UnitOfWork(567212311)-- Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--begin 
unit of work commit
[EL Finer]: 2008.11.18
08:26:27.561--UnitOfWork(567212311)-- Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--end 
unit of work commit
[EL Finer]: 2008.11.18
08:26:27.561--UnitOfWork(567212311)-- Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--resume 
unit of work
[EL Finer]: 2008.11.18
08:26:27.562--UnitOfWork(567212311)-- Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--release 
unit of work
[EL Finer]: 2008.11.18
08:26:27.563--ClientSession(2128871984)-- Thread(Thread[httpSSLWorkerThread-8080-1,10,Grizzly])--client 
released
[EL Finer]: 2008.11.18
08:26:27.614--ServerSession(290077830)-- Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--client 
acquired
[EL Finest]: 2008.11.18
08:26:27.614--UnitOfWork(726392421)-- Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Execute 
query ReadObjectQuery(adcaster.server.domain.Media)
[EL Finer]: 2008.11.18
08:26:27.615--UnitOfWork(726392421)-- Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--begin 
unit of work commit
[EL Finer]: 2008.11.18
08:26:27.615--UnitOfWork(726392421)-- Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--end 
unit of work commit
[EL Finer]: 2008.11.18
08:26:27.615--UnitOfWork(726392421)-- Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--resume 
unit of work
[EL Finest]: 2008.11.18
08:26:27.616--UnitOfWork(726392421)-- Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Execute 
query ReadAllQuery(adcaster.server.domain.MediaVersion)
[EL Finest]: 2008.11.18
08:26:27.617--ServerSession(290077830)-- Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])-- reconnecting 
to external connection pool
[EL Fine]: 2008.11.18
08:26:27.617--ServerSession(290077830)-- Connection(1545852605)-- Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--SELECT 
ID, NAME, VERSION, data_, MEDIA_ID FROM media_version WHERE
((MEDIA_ID =
?)
AND (VERSION = ?))
      bind => [101, 9]
[EL Finest]: 2008.11.18
08:26:27.619--UnitOfWork(726392421)-- Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register 
the existing object
adcaster .server .domain.MediaVersion[objects=blueeye.lang.Objects@48b85e03, 
id=551,
media = adcaster .server.domain.Media[objects=blueeye.lang.Objects@27e4e751, id=101, version=1], version=9, data=[46, 46, 46, 99, 111, 110, 116, 
101,
110, 116, 115, 32, 111, 102, 32, 102, 105, 108, 101, 50, 46, 103, 
105,
102,
46, 46, 46], name=Media2]
[EL Finest]: 2008.11.18
08:26:27.619--UnitOfWork(726392421)-- Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register 
the existing object
adcaster .server.domain.Media[objects=blueeye.lang.Objects@27e4e751, 
id=101,
version=1]
[EL Finer]: 2008.11.18
08:26:27.619--UnitOfWork(726392421)-- Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--begin 
unit of work commit
[EL Finer]: 2008.11.18
08:26:27.620--UnitOfWork(726392421)-- Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--end 
unit of work commit
[EL Finer]: 2008.11.18
08:26:27.620--UnitOfWork(726392421)-- Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--resume 
unit of work
[EL Finest]: 2008.11.18
08:26:27.621--UnitOfWork(726392421)-- Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Execute 
query ReadAllQuery(adcaster.server.domain.MediaVersion)
[EL Finest]: 2008.11.18
08:26:27.622--ServerSession(290077830)-- Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])-- reconnecting 
to external connection pool
[EL Fine]: 2008.11.18
08:26:27.622--ServerSession(290077830)-- Connection(1232567244)-- Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--SELECT 
ID, NAME, VERSION, data_, MEDIA_ID FROM media_version WHERE
((MEDIA_ID =
?)
AND (VERSION = ?))
      bind => [101, 10]
[EL Finer]: 2008.11.18
08:26:27.623--UnitOfWork(726392421)-- Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--begin 
unit of work commit
[EL Finer]: 2008.11.18
08:26:27.624--UnitOfWork(726392421)-- Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--end 
unit of work commit
[EL Finer]: 2008.11.18
08:26:27.624--UnitOfWork(726392421)-- Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--resume 
unit of work
[EL Finest]: 2008.11.18
08:26:27.625--UnitOfWork(726392421)-- Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Execute 
query ReadAllQuery(adcaster.server.domain.MediaVersion)
[EL Finest]: 2008.11.18
08:26:27.625--ServerSession(290077830)-- Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])-- reconnecting 
to external connection pool
[EL Fine]: 2008.11.18
08:26:27.625--ServerSession(290077830)--Connection(139849089)-- Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--SELECT 
ID, NAME, VERSION, data_, MEDIA_ID FROM media_version WHERE
((MEDIA_ID =
?)
AND (VERSION = ?))
      bind => [101, 8]
[EL Finest]: 2008.11.18
08:26:27.627--UnitOfWork(726392421)-- Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register 
the existing object
adcaster .server .domain.MediaVersion[objects=blueeye.lang.Objects@48b85e03, 
id=502,
media = adcaster .server.domain.Media[objects=blueeye.lang.Objects@27e4e751, id=101, version=1], version=8, data=[46, 46, 46, 99, 111, 110, 116, 
101,
110, 116, 115, 32, 111, 102, 32, 102, 105, 108, 101, 50, 46, 103, 
105,
102,
46, 46, 46], name=Media2]
[EL Finest]: 2008.11.18
08:26:27.627--UnitOfWork(726392421)-- Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register 
the existing object
adcaster .server.domain.Media[objects=blueeye.lang.Objects@27e4e751, 
id=101,
version=1]
[EL Finer]: 2008.11.18
08:26:27.627--UnitOfWork(726392421)-- Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--begin 
unit of work commit
[EL Finer]: 2008.11.18
08:26:27.628--UnitOfWork(726392421)-- Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--end 
unit of work commit
[EL Finer]: 2008.11.18
08:26:27.628--UnitOfWork(726392421)-- Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--resume 
unit of work
[EL Finer]: 2008.11.18
08:26:27.629--UnitOfWork(726392421)-- Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--release 
unit of work
[EL Finer]: 2008.11.18
08:26:27.629--ClientSession(256032021)-- Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--client 
released
----------------------------------------

Thanks,
Gili











-----
---
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@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/eclipselink-users


aloha

-- DAP
=====================================================
David Parker                                                  david@xxxxxxxxxxxxxxxxx

"If you want sense you'll have to make it yourself"
										- The Dodecahedron

Back to the top