aspose file tools
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 Meteor in Action this week in the JavaScript 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
Author

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