Hi Guys,

I tried to do some db operations( load, delete and update) in one transaction, after some steps I throw some exception and let the transaction rollback, but the db can not return to the state before I begin transaction, there are some data has been updated.

does any body know what's the problem it is?

Thanks

it's easy -- you're not in transaction.

the only things that I know which doesn't rollback -- are sequences.
well, and DDLs (CREATE TABLE,...) are not always transactional.

so -- you're not in transaction. show your code.

actually I am in transaction the code like this:
//get session
try {
session = factory().openSession();
tx = session.beginTransaction();
// do some things here like
session.load
session.delete
session.update
.....
.....
......

//here I tried to through excepion
throw new HibernateException("test rollback");
//tx.commit();
} catch (HibernateException he) {

if ( tx != null && !tx.wasCommitted() && !tx.wasRolledBack()
tx.rollback();
}
}
finally {

//TODO
}

well, the code looks more or less fine, except it's not complete.
I wrote many of similar blocks, and it works. always.

add logging to see if your rollback is called actually.

check that your database supports transactions.
MySQL doesn't if it's not InnoDB tables.

check also autocommit option of your datasource.
as far as I understand, hibernate turns that off by itself, but who knows...

The rollback method get called When I debuged it, one thing I think about maybe the problem comes from db side, I use Mysql, I will check it.

Thanks

I set the flush mode to commit in my code. so its not that problem.

That explains. Either InnoDB should be set as default table type,
or table should be created with InnoDB option:

CREATE TABLE ( ... ) Type="InnoDB";

Thanks

good news the problem comes from db side when I set table type to InnoDB every thing is work well.

Thank you guys