Same session second time right attempt also fails

senthilid14 · **Joined:** Fri Apr 06, 2007 7:08 am **Posts:** 4

In a single session, in any (same/or different) transaction, if my save attempts fails first time (because of constraint violation), second time i will set value properly and i should be able to save'.

but second time also my save fails (even though values are properly set)

Code:

package example;

import org.hibernate.FlushMode;
import org.hibernate.Session;
import org.hibernate.SessionFactory;

public class PersonTest {
   @SuppressWarnings("unchecked")
   public static void main(String args[]) {
      SessionFactory sessionFactory = HibernateUtil.getSessionFactory();
      Session session = sessionFactory.openSession();
      session.setFlushMode(FlushMode.MANUAL);

      Person person = new Person();
      person.setId(2);
      person.setName("Kumar");
      
      log("--- First Attempt");
      try{
         session.beginTransaction();
      
         session.save(person);
         session.flush();
         
         session.getTransaction().commit();
      }catch(Exception e) {
         log("--- fail "+e);
      }
      
      log("--- Second Attempt");
      try{
         person.setAge(24);
         session.beginTransaction();
         
         session.save(person);
         log("Age "+person.getAge());
         session.flush();
         
         session.getTransaction().commit();
      }catch(Exception e) {
         log("--- fail "+e);
      }
      
      session.close();
   }
   
   private static <T> void log(T t) {
      System.out.println(t);
   }
}

appreciate your help

himawan · **Joined:** Sat Aug 19, 2006 6:31 pm **Posts:** 139

Try session.evict(person) before doing the second transaction.

amila733 · **Posted:** Fri Jun 15, 2007 3:15 am

Hi

Send your mapping file and class file

in second time use saveOrUpdate() instead of save()

Amila

(Don't forget to rate if helps)

senthilid14 · **Joined:** Fri Apr 06, 2007 7:08 am **Posts:** 4

Guys, i am trying with this (sorry for unclear)

in the first attempt (which is going to fail defintely)

Code:

try{
  ....
catch(Exception e) {
  failure = true;
  session.clear();
}

in the second attempt (it should pass, since for not-null column we are setting value)

Code:

try {
  person.setAge(24);
  if(failure) 
    person = session.merge(person);
  session.save(person);
  session.flush();
}catch(...) { 

}

i am trying to apply this in our project(one save will trigger 23 tables- all associations and several childrens), once i did & tested sufficiently i will let you know more