Dear All,
I am new to hibernate. Please help me regarding the multiple save object within single transaction.
try {
Transaction tx = session.beginTransaction();
session.save(emp);
session.save(dept);
tx.commit;
} catch (Exception e) {
tx.rollback;
}

Above code is saving "emp" and "dept" object in single transaction. If "session.save(emp)" is executed properly but "session.save(dept)" given error, while executing "tx.commit".

My question is, if "emp" and "dept" is saving within single transaction then either both has to commit or rollback, but "emp" is committed and "dept" came out with error.

Is there any way to commit or rollback both object within single transaction.

Thanks and regards.

Just a guess, but don't you have somehow autocommit turned on? Because normally it should work as you would await.
Or maybe you have observed the changes with read/uncommited issolation level on database.

Thanks for the reply.

In cfg.xml file properties is set to autocommit=false
--------------
<property name="hibernate.connection.autocommit">false</property>

Oracle is also set as autocommit = Off
----------------------
Connected to:
Oracle Database 10g Release 10.2.0.1.0 - Production

SQL> show autocommit
autocommit OFF
SQL>