Hi,
I m using Spring with Hibernate by extending the HibernateDaoSupport class.
I have a method which accepts a List Collection as the parameter.
I m iterating over the List and updating my database as follows:

//////////////////////////////

Iterator iterator = cabRequests.iterator(); //cabRequests is a List object containing cabRequest Objects.
CabRequestDTO cabRequest = null;
try {
while( iterator.hasNext() ) {
cabRequest = ( CabRequestDTO ) iterator.next();
getHibernateTemplate().update( cabRequest );
}
}

//////////////////////////////

Assume, the List has 5 objects to update.

if there is any problem in the third object, an exception is thrown.
Result is : Object 1 and Object 2 is updated while Object 3, 4, 5 is not updated.

My Requirement: I want to update all the objects in the list in one stroke.
if there is any problem in between, i want to rollback or Undo all the updates.
in Brief: i want to update All or Update none.

Pls help as i need to deliver this asap.

Thanks in Advance.

Abid

this is the property that you want. if you use like this all queries use same transaction and rollback in any error. if you use REQUIRES_NEW all queries use their own transaction.