object deleted in multiple sessions

mvalentin · **Joined:** Thu Jan 08, 2004 12:05 pm **Posts:** 14

Hi!

Anyone have any idea what is the best aproach for this situation :
I have to hibernate sessions, S1 and S2, and I load two objects with the same primary key, O1 loaded by S1 and O2 loaded by S2. The problem appear when I delete first O1 and then O2, as hibernate throw an exception if the coresponding row from database isn't there anymore.

How do you guys threat situations like this ? does hibernate provide a way to handle this or you handle this outside hibernate ?

thanks

mvalentin · **Joined:** Thu Jan 08, 2004 12:05 pm **Posts:** 14

Here is code snippet

Code:

   Session ses1 = sf.openSession();
   Session ses2 = sf.openSession();
   UserRole ur1 = (UserRole) ses1.load(UserRole.class, id);
   UserRole ur2 = (UserRole) ses2.load(UserRole.class, is);

   Transaction t2 = ses2.beginTransaction();
   Transaction t1 = ses1.beginTransaction();

   ses1.delete(ur1);
   t1.commit();
   ses1.close();

   ses2.delete(ur2);
   t2.commit();
   ses2.close();

[/code]

jlawmi · **Joined:** Mon Nov 24, 2003 6:36 pm **Posts:** 105

why do you need to load the 2 classes in diff sessions?
Are they different databases?

why not
User user = (User)sess.load(object1.class, key);
sess.delete(user)
user = sess.load(object2.class,key)
sess.delete(user)
tx.commit?

--James

emmanuel · **Posted:** Mon Jan 12, 2004 8:05 pm

Try to use <version> tag. It may raise a staleObjectException. Not sure however (interested by the result).