Skip to main content

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
Re: [eclipselink-users] EclipseLinkM6 doesn't properly detect added/changed details

Thanks for your assistance. Below I'll give you an idea of the queries executed.

Immediately after the import has been completed, and without Tomcat6 restart, I see the following query:

[EPS Finer]: 2008.05.07 14:48:33.001--ServerSession(1170294209)--Thread(Thread[http-8080-1,5,main])--client acquired
[EPS Finest]: 2008.05.07 14:48:33.003--UnitOfWork(1138967523)--Thread(Thread[http-8080-1,5,main])--Execute query ReadAllQuery(com.acme.lighting.guidecontrol.model.IndustrialFamily)
[EPS Finest]: 2008.05.07 14:48:33.003--ServerSession(1170294209)--Thread(Thread[http-8080-1,5,main])--reconnecting to external connection pool
[EPS Fine]: 2008.05.07 14:48:33.005--ServerSession(1170294209)--Connection(577184359)--Thread(Thread[http-8080-1,5,main])--SELECT DISTINCT t1.ID, t1.CODE, t1.NAME, t1.PROD_CAT, t0.ID, t0.PRODUCT_TYPE, t0.CODE, t0.SHORT_CODE, t0.NAME, t0.family_id, t0.GEAR_TYPE FROM PLI.PLI_CATALOG_PRODUCTS t0, PLI.PLI_INDUSTRIAL_FAMILIES t1 WHERE ((t1.ID = ?) AND (t0.family_id = t1.ID))
	bind => [21811]
[EPS Finest]: 2008.05.07 14:48:33.009--UnitOfWork(1138967523)--Thread(Thread[http-8080-1,5,main])--Register the existing object com.acme.lighting.guidecontrol.model.IndustrialFamily@22702270

No detail records are queried/displayed. 
But now when I restart tomcat6 I see:

[EPS Finer]: 2008.05.07 14:50:04.377--ServerSession(1076903984)--Thread(Thread[http-8080-2,5,main])--client acquired
[EPS Finest]: 2008.05.07 14:50:04.413--UnitOfWork(1834249556)--Thread(Thread[http-8080-2,5,main])--Execute query ReadAllQuery(com.acme.lighting.guidecontrol.model.IndustrialFamily)
[EPS Finest]: 2008.05.07 14:50:04.413--ServerSession(1076903984)--Thread(Thread[http-8080-2,5,main])--reconnecting to external connection pool
[EPS Finest]: 2008.05.07 14:50:04.414--ServerSession(1076903984)--Thread(Thread[Finalizer thread,5,system])--Begin undeploying Persistence Unit guidecontrol-web; state Deployed; factoryCount 4
[EPS Finest]: 2008.05.07 14:50:04.414--ServerSession(1076903984)--Thread(Thread[Finalizer thread,5,system])--End undeploying Persistence Unit guidecontrol-web; state Deployed; factoryCount 3
[EPS Finest]: 2008.05.07 14:50:04.414--ServerSession(1076903984)--Thread(Thread[Finalizer thread,5,system])--Begin undeploying Persistence Unit guidecontrol-web; state Deployed; factoryCount 3
[EPS Finest]: 2008.05.07 14:50:04.414--ServerSession(1076903984)--Thread(Thread[Finalizer thread,5,system])--End undeploying Persistence Unit guidecontrol-web; state Deployed; factoryCount 2
[EPS Finest]: 2008.05.07 14:50:04.414--ServerSession(1076903984)--Thread(Thread[Finalizer thread,5,system])--Begin undeploying Persistence Unit guidecontrol-web; state Deployed; factoryCount 2
[EPS Finest]: 2008.05.07 14:50:04.414--ServerSession(1076903984)--Thread(Thread[Finalizer thread,5,system])--End undeploying Persistence Unit guidecontrol-web; state Deployed; factoryCount 1
[EPS Fine]: 2008.05.07 14:50:04.416--ServerSession(1076903984)--Connection(1155679458)--Thread(Thread[http-8080-2,5,main])--SELECT DISTINCT t1.ID, t1.CODE, t1.NAME, t1.PROD_CAT, t0.ID, t0.PRODUCT_TYPE, t0.CODE, t0.SHORT_CODE, t0.NAME, t0.family_id, t0.GEAR_TYPE FROM PLI.PLI_CATALOG_PRODUCTS t0, PLI.PLI_INDUSTRIAL_FAMILIES t1 WHERE ((t1.ID = ?) AND (t0.family_id = t1.ID))
	bind => [21811]
[EPS Finest]: 2008.05.07 14:50:04.424--ServerSession(1076903984)--Thread(Thread[http-8080-2,5,main])--Execute query ReadObjectQuery(com.acme.lighting.guidecontrol.model.IndustrialFamily)
[EPS Finest]: 2008.05.07 14:50:04.427--ServerSession(1076903984)--Thread(Thread[http-8080-2,5,main])--Execute query ReadObjectQuery(com.acme.lighting.guidecontrol.model.IndustrialFamily)
[EPS Finest]: 2008.05.07 14:50:04.427--ServerSession(1076903984)--Thread(Thread[http-8080-2,5,main])--Execute query ReadObjectQuery(com.acme.lighting.guidecontrol.model.IndustrialFamily)
[EPS Finest]: 2008.05.07 14:50:04.428--ServerSession(1076903984)--Thread(Thread[http-8080-2,5,main])--Execute query ReadObjectQuery(com.acme.lighting.guidecontrol.model.IndustrialFamily)
[EPS Finest]: 2008.05.07 14:50:04.428--UnitOfWork(1834249556)--Thread(Thread[http-8080-2,5,main])--Register the existing object com.acme.lighting.guidecontrol.model.IndustrialFamily@75c875c8
[EPS Finest]: 2008.05.07 14:50:04.429--UnitOfWork(1834249556)--Thread(Thread[http-8080-2,5,main])--Register the existing object Lamp
[EPS Finest]: 2008.05.07 14:50:04.430--UnitOfWork(1834249556)--Thread(Thread[http-8080-2,5,main])--Register the existing object com.acme.lighting.guidecontrol.model.IndustrialFamily@75c875c8
[EPS Finest]: 2008.05.07 14:50:04.431--UnitOfWork(1834249556)--Thread(Thread[http-8080-2,5,main])--Register the existing object Lamp
[EPS Finest]: 2008.05.07 14:50:04.431--UnitOfWork(1834249556)--Thread(Thread[http-8080-2,5,main])--Register the existing object com.acme.lighting.guidecontrol.model.IndustrialFamily@75c875c8
[EPS Finest]: 2008.05.07 14:50:04.431--UnitOfWork(1834249556)--Thread(Thread[http-8080-2,5,main])--Register the existing object Lamp
[EPS Finest]: 2008.05.07 14:50:04.431--UnitOfWork(1834249556)--Thread(Thread[http-8080-2,5,main])--Register the existing object com.acme.lighting.guidecontrol.model.IndustrialFamily@75c875c8
[EPS Finest]: 2008.05.07 14:50:04.432--UnitOfWork(1834249556)--Thread(Thread[http-8080-2,5,main])--Register the existing object Lamp
[EPS Finest]: 2008.05.07 14:50:04.432--UnitOfWork(1834249556)--Thread(Thread[http-8080-2,5,main])--Register the existing object com.acme.lighting.guidecontrol.model.IndustrialFamily@75c875c8

Obviously there is some difference, although I cannot explain it - because I see the exact same query being fired.

Any idea?
-J.



On Wed, 2008-05-07 at 08:17 -0400, Tim Hollosy wrote:
> Obvious question, but did you turn on logging to see what queries are
> being executed by EclipseLink?
> 
> -Tim
> 
> On Wed, May 7, 2008 at 3:53 AM, Jan Vissers <Jan.Vissers@xxxxxxxxxx> wrote:
> > Hi,
> >
> >  I'm hitting a serious issue using EclipseLinkM6. Our application
> >  declares a master|detail relationship between families and products.
> >  Data gets loaded asynchronously via Quartz which uses EclipseLink
> >  EntityManager's. What we're seeing is that after a successful import the
> >  master records show up in the application, but drilling down on the
> >  details doesn't show any details. An actual database query tells us that
> >  there *are* details available. Now when we restart our container
> >  (Tomcat6) and revisit the master|detail forms, the details *do* show up
> >  nicely. This behavior is the same for a pooling datasource em, as well
> >  as for a non-pooling, non-datasource em. What I find strange is that the
> >  master records do show up, but the details only after container restart.
> >
> >  My guess is that EclipseLink doesn't properly detect changed
> >  associations. Please tell me it isn't so - and that we're doing
> >  something wrong.
> >
> >  Thanks,
> >  -J.
> >
> >  _______________________________________________
> >  eclipselink-users mailing list
> >  eclipselink-users@xxxxxxxxxxx
> >  https://dev.eclipse.org/mailman/listinfo/eclipselink-users
> >
> 
> 
> 



Back to the top