Session.evict() and update() doesn't works.

[Kunal Lakhani]

I am updating a record with the following code :

public void saveOrUpdateAdmission(StudentAdmissionEntity sae1){
		
		
		System.out.println("In Dao updating");
		
		Configuration config = new Configuration();
		config.configure();
		
		SessionFactory factory = config.buildSessionFactory();
		
		Session session = factory.openSession();
		
		Transaction trans = session.beginTransaction();
		
		Criteria cr = session.createCriteria(org.nit.Entity.StudentAdmissionEntity.class).add(Restrictions.eq("enrollmentNo", 		sae1.getEnrollmentNo()))
		.add(Restrictions.eq("year", sae1.getYear()));
		
		List<StudentAdmissionEntity> l = cr.list();
		
		if(l.size()==0){
			System.out.println("Saving");
			session.save(sae1);
			trans.commit();
		} else {
			System.out.println("Updating");
			StudentAdmissionEntity sae = l.get(0);
			session.evict(sae);
			System.out.println("old : "+sae.getClassAdmitted() +": "+sae.getSection()+" : "+sae.getRollNo()+ " : "+sae.getYear()); //this prints "old :12 A 10 2014
			//sae.setEnrollmentNo(sae1.getEnrollmentNo());
			sae.setClassAdmitted(sae1.getClassAdmitted());
			sae.setSection(sae1.getSection());
			sae.setRollNo(sae1.getRollNo());
			sae.setAdmissionDate(sae1.getAdmissionDate());
			//sae.setStatus(sae1.getStatus());
			//sae.setYear(sae1.getYear());
			//sae.setStatus(sae1.getStatus());
			System.out.println("new : "+sae1.getClassAdmitted() +": "+sae1.getSection()+" : "+sae1.getRollNo()+" : "+sae.getYear()); //this prints "old :12 A 2 2014
			session.update(sae);
			trans.commit();
		}
		
		
		
		session.close();
		factory.close();
		
	}

The table which gets updated has composite primary key (class,section,rollno,year)

But this code throws an exception relating to primary key violation.
I wonder how pk is violated, since the rollno is changed, and this rollno is not allotted to anyone.

Strange thing is that this code works with same values

Criteria cr = session.createCriteria(org.nit.Entity.StudentAdmissionEntity.class).add(Restrictions.eq("enrollmentNo", sae1.getEnrollmentNo()))
		.add(Restrictions.eq("year", sae1.getYear()));
		
		List<StudentAdmissionEntity> l = cr.list();
		
		if(l.size()==0){
			System.out.println("Saving");
			session.save(sae1);
			trans.commit();
		} else {
			
			StudentAdmissionEntity sae = l.get(0);
			//session.evict(sae);
			session.delete(sae);
			System.out.println("deleted");
			StudentAdmissionEntity saa = new StudentAdmissionEntity();
			//System.out.println("old : "+sae.getClassAdmitted() +": "+sae.getSection()+" : "+sae.getRollNo()+ " : "+sae.getYear());
			saa.setEnrollmentNo(sae1.getEnrollmentNo());
			saa.setClassAdmitted(sae1.getClassAdmitted());
			saa.setSection(sae1.getSection());
			saa.setRollNo(sae1.getRollNo());
			saa.setAdmissionDate(sae1.getAdmissionDate());
			saa.setStatus(sae1.getStatus());
			saa.setYear(sae1.getYear());
			saa.setStatus(sae1.getStatus());
			System.out.println("new : "+sae1.getClassAdmitted() +": "+sae1.getSection()+" : "+sae1.getRollNo()+" : "+sae.getYear());
			session.save(saa);
			System.out.println("Updating");
			trans.commit();

In this code i have deleted the old record and then, save the new one (wrong way of updating)

[James Boswell]

Have you tried the call to update() method without the call to evict?

[Kunal Lakhani]

Thanks for your reply James Boswell.
No , i haven't tried that.

But before trying that i wonder why the code posted by me doesn't works

[Kunal Lakhani]

The problem i am facing is that the delete() deletes all the records with that specified roll no regardless of year.

[James Boswell]

How have you defined your composite key on the entity? It sounds like it isn't working correctly.