Hi all,

I'm working on a very simple setting from
openejb(3.1)/openjpa(1.2.1)/Postgres-8.3

I can retrieve a persistent object without problem, but if I attempt to
update a column to null, the value is not set.

The object basically has a min and max (Long) values.

Here is my abbreviated mapping:
Range {
  Long min;
  Long max;

  @Column(name="min", nullable=true, updatable=true, insertable=true)
  Long getMin() { return min;}
  void setMin(Long a) { min=a;}
 
  @Column(name="max", nullable=true, updatable=true, insertable=true)
  Long getMax() { return max;}
  void setMax(Long a) { max=a;}
}

when I run the following code:
...  the object is disconnected and retrieved from probably another entity
manager.
   Range r = ....
   r.setMin(null);
   entityManager.merge(r);

The update does not happen.  But, if I update setMin(1) the update does take
place.

However if I run the following code things seem to behave:
   Range r = ...
   Range newRangeInThisTransaction = entityManager.find(Range.class,
r.getID());
   newRangeInThisTransation.setMin(r.getMin());
   newRangeInThisTransaction.setMax(r.getMax());
   entityManager.merge(newRangeInThisTransaction);

any help would be greatly appreciated...  If the problem is not obvious, I
will work on a small working example to show the problem.

-chris
-- 
View this message in context: 
http://n2.nabble.com/null-values-not-updating-tp3224059p3224059.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.

Reply via email to