aspose file tools*
The moose likes JDBC 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
JavaRanch » Java Forums » Databases » JDBC
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: 445
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