updating row multiple times in a single transaction

t990922 · **Posted:** Fri Feb 25, 2005 6:15 am

Hello,

I need to update a row several times during one transaction. For concurrency control I use versioning. The problem is that when I call save method on the second update I get StaleObjectStateException.

As far as I see, the problem is in incremented version number that Hibernate doesn't like, so it thinks that the object is stale. Is there some general pattern that we could employ to solve this issue?

wbr,
Vladimir

ernst_pluess · **Posted:** Fri Feb 25, 2005 8:27 am

Without your code (the red box!) I can just guess, that you're trying to save the same instance twice.

HTH
Ernst

a_gura · **Posted:** Fri Feb 25, 2005 11:00 am

t990922 wrote:

Hello,

I need to update a row several times during one transaction. For concurrency control I use versioning. The problem is that when I call save method on the second update I get StaleObjectStateException.

As far as I see, the problem is in incremented version number that Hibernate doesn't like, so it thinks that the object is stale. Is there some general pattern that we could employ to solve this issue?

wbr,
Vladimir

Try saveOrUpdate() method instead of save().

michael · **Posted:** Fri Feb 25, 2005 11:11 am

Yes, don't call save() or update() at all as long as you are within Session scope and not reattatching a detatched object. Automatic dirty checking is there for this.

t990922 · **Posted:** Mon Feb 28, 2005 5:13 am

I'm using this object in different sessions, at least I hope so, couse I get these sessions from SessionFactory.
And I'm actually using saveOrUpdate method, not save.
Any more ideas?