Can a DAO call DAO?

Jack BeNimble picture Jack BeNimble · Jan 24, 2012 · Viewed 7.9k times · Source

I have component which needs to update the database for the customer and customer address (via JDBC). Is it appropriate to call the CustomerAddressDAO from the CustomerDAO? Or create a separate "CustomerDataManager" component which calls them separately?

Answer

hvgotcodes picture hvgotcodes · Jan 24, 2012

You can do it, but that doesn't mean you should. In these cases, I like to use a Service (CustomerService in this case) that has a method call that uses both DAOs. You can define the transaction around the service method, so if one call fails, they both roll back.

The problem with DAOs that call other DAOs is you will quite quickly end up with circular references. Dependency injection becomes much more difficult.