wood burning stoves
The moose likes JDBC and Relational Databases and the fly likes How to handle transaction in DAO Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "How to handle transaction in DAO" Watch "How to handle transaction in DAO" New topic

How to handle transaction in DAO

amit sharma
Ranch Hand

Joined: Jul 19, 2006
Posts: 129
I make DAO for USER. I make a new connection in each method(CRUD) of DAO. I want to know what is the best strategy to handle transaction in DAO pattern. How can i call another DAO from DAO class.
Deepak Pant
Ranch Hand

Joined: Feb 13, 2004
Posts: 446
I think the answer to your question lies in following questions:
1. Are you using EJBs in your application ?
2. Or any other framework like Spring/Hibernate etc.

Generally I have not seen DAO calling another DAO. DAO to me are specialized extensions of the business components (EJB or POJO), which contain data access code. I think it should be Business component calling another business component.

The transaction handling will come from the first two questions.
I agree. Here's the link: http://aspose.com/file-tools
subject: How to handle transaction in DAO
It's not a secret anymore!