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

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.



Back to the top