Eclipse Community Forums: EclipseLink » Delay betwen persist and find of a relationship

Help

Home

Home » Eclipse Projects » EclipseLink » Delay betwen persist and find of a relationship

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

Delay betwen persist and find of a relationship [message #531943]

Thu, 06 May 2010 14:48

Mauro Flores

Messages: 84
Registered: September 2009
Location: Brasil

Member

I facing the folowing problem.

a) I have an entity A with a OneToOne relationship with B with fetch EAGER
b) I populate A and B properties
c)I persist A
d)The database is updated correctly: table A and B.
e)I make a find of A with the same ID, the properties of A comes correctly, except the B relationship that comes with null
f)I wait aroud 10 minutes, and repeat the find, now the relationship B appears.

I'm using the eclipselink implementation of weblogic 11g.

Any hint?

Thanks. Mauro.

Report message to a moderator

Re: Delay betwen persist and find of a relationship [message #531990 is a reply to message #531943]

Thu, 06 May 2010 17:28

James Sutherland

Messages: 1939
Registered: July 2009
Location: Ottawa, Canada

Senior Member

Very odd.

Were both A and B new to begin with? Is the 1-1 cascade persist?

What type of caching are you using? Can you try disabling the shared cache (shared=false).

Do you have issues on your database that defers writes?

James : Wiki : Book : Blog : Twitter

Report message to a moderator

Re: Delay betwen persist and find of a relationship [message #532017 is a reply to message #531990]

Thu, 06 May 2010 18:58

Mauro Flores

Messages: 84
Registered: September 2009
Location: Brasil

Member

a) Problem solved disabling the shared cache. Thanks.

<property name="eclipselink.cache.shared.default" value="false"/>

b) I'm new to eclipselink, we are migrating our systems from openjpa to eclipselink. I have to study about cache policies of eclipselink.

c) Analizing more the entity, I saw a weird thing:

- the entity A has the id of entity B as a property too.
- when A is persisted, B already exists, and the id of B is setted to A.

@Entity
@Table(name = "A")
public class A {
  @Id
  private Integer nroIntA;

  @Column(name = "NRO_INT_B")  
  private int nroIntB;
  
  @OneToOne(fetch = FetchType.EAGER)
  @JoinColumn(name = "NRO_INT_B", insertable = false, updatable = false)
  private B b ;
}

Report message to a moderator

Re: Delay betwen persist and find of a relationship [message #532281 is a reply to message #532017]

Fri, 07 May 2010 18:57

Chris Delahunt

Messages: 1389
Registered: July 2009

Senior Member

This is because the relationship from A to B is marked insertable = false, updatable = false; essentially that it is read-only. Since new A objects won't have this relationship, it starts off as null and will not change for as long as it is in the cache unless the NRO_INT_B field is changed (through the commiting A's changes to the nroIntB attribute or through changes outside JPA), and hte Entity is refreshed.

By turning the cache off, or waiting for the object to be purged/garbage collected from the cache, it causes the relationship to be read in/refreshed from the database, causing changes to the NRO_INT_B to show up. You can verify this by calling em.refresh(yourEntity) after your transaction commits and see that the A->B relationship will be set.

Ways around this
1) turn off the shared cache. This might not be the ideal solution, as the shared cache may provide some performance improvements for your app.
2) remove one of the fields from the A entity. For instance, if you have the A->B relationship, you can call a.b.id to get the value that is in A's NRO_INT_B field. Or you can use em.find(B.class, a.nroIntB) to get the B.
3) explicietly refresh the object when you make changes that affect the A->B relationship

Report message to a moderator

Previous Topic:	NamedNativeQuery
Next Topic:	[Unidirectional OneToOne Relationships] eclipselink doesn't understand MapsId=" "

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 09:07:52 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter