Hibernate version:3.2.6

Name and version of the database you are using:Oracle 9

Hi,

I am new to hibernate. Please help me with the following problem.

i doing a logical transaction which involves more than two database operations i want to commit only if all the database operations have successfully executed. My code structure looks like..
//business class
sessionFactory.openSession();
dao1.method1();
dao2.method3()
//i actually want to do a commit here
session.close();

//data access classes
class DAO1{
method1(){
//1. begin transaction
//2. db operation
//3. commit transation
}
method2(){
}
}
class DAO2{
method3(){
}
..
methodn(){
}
}
currenly im calling commit in all the dao methods, but i want to commit only once after executing all the dao methods. How should i do it? is it possible to call commit in the business service class?

I read few documentation. But im not finding it easy to understand.

Thanks in advance.
Appreciate if someone can provide some code samples.

I have implemented nested transactions to handle transaction from business layer: implement business level transactions that span multiple data layers.

So here is how it works in my business layer:

MyBusinessController


DataContrller1.executeMethod()


DataContrller2.executeMethod()


This way a new transaction is open in business layer and same is used in data layers. Let me know if you need sample code for this implementation.

Thanks dude! It really helped a lot. Please send me sample code. Thanks again