Re: [eclipselink-users] Query returning stale results existing

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]

Re: [eclipselink-users] Query returning stale results existing

From: Neil Hauge <neil.hauge@xxxxxxxxxx>
Date: Tue, 18 Nov 2008 14:31:52 -0500
Delivered-to: eclipselink-users@xxxxxxxxxxx
List-archive: <https://dev.eclipse.org/mailman/private/eclipselink-users>
List-help: <mailto:eclipselink-users-request@eclipse.org?subject=help>
List-subscribe: <https://dev.eclipse.org/mailman/listinfo/eclipselink-users>, <mailto:eclipselink-users-request@eclipse.org?subject=subscribe>
List-unsubscribe: <https://dev.eclipse.org/mailman/listinfo/eclipselink-users>, <mailto:eclipselink-users-request@eclipse.org?subject=unsubscribe>
User-agent: Thunderbird 2.0.0.9 (Windows/20071031)

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@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, 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, 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, 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, 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, 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, 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, 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, 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, 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, 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, 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, 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, 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, 99, 111, 110, 116,
101,
110, 116, 115, 32, 111, 102, 32, 102, 105, 108, 101, 50, 46, 103, 105,
102,
46, 46, 46], name=Media2]
[EL Finest]: 2008.11.18
08:26:27.627--UnitOfWork(726392421)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--Register
the existing object
adcaster.server.domain.Media[objects=blueeye.lang.Objects@27e4e751,
id=101,
version=1]
[EL Finer]: 2008.11.18
08:26:27.627--UnitOfWork(726392421)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--begin
unit of work commit
[EL Finer]: 2008.11.18
08:26:27.628--UnitOfWork(726392421)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--end
unit of work commit
[EL Finer]: 2008.11.18
08:26:27.628--UnitOfWork(726392421)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--resume
unit of work
[EL Finer]: 2008.11.18
08:26:27.629--UnitOfWork(726392421)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--release
unit of work
[EL Finer]: 2008.11.18
08:26:27.629--ClientSession(256032021)--Thread(Thread[httpSSLWorkerThread-8080-0,10,Grizzly])--client
released
----------------------------------------

Thanks,
Gili
--
View this message in context:
http://www.nabble.com/Query-returning-stale-results-existing-tp20559804p20559804.html
Sent from the EclipseLink - Users mailing list archive at Nabble.com.

_______________________________________________
eclipselink-users mailing list
eclipselink-users@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/eclipselink-users

_______________________________________________
eclipselink-users mailing list
eclipselink-users@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/eclipselink-users

--
View this message in context:
http://www.nabble.com/Query-returning-stale-results-existing-tp20559804p20564772.html
Sent from the EclipseLink - Users mailing list archive at Nabble.com.

_______________________________________________
eclipselink-users mailing list
eclipselink-users@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/eclipselink-users

_______________________________________________
eclipselink-users mailing list
eclipselink-users@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/eclipselink-users

References:
- [eclipselink-users] Query returning stale results existing
  - From: cowwoc
- Re: [eclipselink-users] Query returning stale results existing
  - From: Tim Hollosy
- Re: [eclipselink-users] Query returning stale results existing
  - From: cowwoc
- Re: [eclipselink-users] Query returning stale results existing
  - From: Tim Hollosy
- Re: [eclipselink-users] Query returning stale results existing
  - From: cowwoc

Prev by Date: Re: [eclipselink-users] Query returning stale results existing
Next by Date: Re: [eclipselink-users] Documentation clarification
Previous by thread: Re: [eclipselink-users] Query returning stale results existing
Next by thread: Re: [eclipselink-users] What am I missing?
Index(es):
- Date
- Thread

Breadcrumbs