Eclipse Community Forums: EclipseLink » JPA/DCN - working for INSERT; trouble with UPDATE

Home » Eclipse Projects » EclipseLink » JPA/DCN - working for INSERT; trouble with UPDATE(Not getting updated record when DCN received after update in DB)

Show: Today's Messages :: Show Polls :: Message Navigator

JPA/DCN - working for INSERT; trouble with UPDATE [message #1028088]

Wed, 27 March 2013 20:27

Julie Schenk

Messages: 18
Registered: August 2012

Junior Member

I have the JPA/DCN set up and working in my application. Any time there is a change in the Oracle 11g DB, my application receives a notification and fires a property change event, sending the table name in the "new value" argument.

When I attempt to re-read the values from the table upon receiving the property change notification, I always get a new record if there was an INSERT performed however I do NOT get an updated record if there was an UPDATE performed.

S, I receive the change notification from the DB but it seems like the cache isn't invalidated for the update like it is for the insert.

Do I have to do something special to make that work? It seems like it works in the JPA/DCN example: http://wiki.eclipse.org/EclipseLink/Examples/JPA/DCN

Report message to a moderator

Re: JPA/DCN - working for INSERT; trouble with UPDATE [message #1028754 is a reply to message #1028088]

Thu, 28 March 2013 17:40

Chris Delahunt

Messages: 1389
Registered: July 2009

Senior Member

How are you reading the existing updated entities? Be sure you are either getting a new EntityManager or clearing it occasionally, as the managed entities it references are meant to operate like a transaction - once read in, they are cached by the EM and will not see external changes.

Report message to a moderator

Re: JPA/DCN - working for INSERT; trouble with UPDATE [message #1032256 is a reply to message #1028754]

Tue, 02 April 2013 19:28

Julie Schenk

Messages: 18
Registered: August 2012

Junior Member

Thank you. I had not been doing either. I now retrieve a new EntityManager when the DCN is due to an UPDATE operation and so far it seems to be working.

Really appreciate the reply.

Report message to a moderator

Previous Topic:	Inheritance and TYPE
Next Topic:	Commit object with ID

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 16:48:45 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter