Transaction Management Across Multiple DAOs

[Murat Balkan]

Hi,
I am working on an application where I have 2 DAOs:
CustomerDAO and SubscriptionDAO. I am using pure JDBC within those daos. A manager SLSB creates and call CRUD methods on these DAOs.
In the scenario, whenever a new Customer is created, I need to create a Subscription automatically. (giving the customer id to the subscription)
I do this like this:

...
int id=customerdao.insert(customerVO);
...
subscriptionVO.customerid=id;
subscriptionDAO.insert(subscriptionvo);

I wonder how can I include transactional capabilities to this code. (If I use Tomcat alone, or Tomcat with an AS I havent decided yet).
That is to say, if theres a problem in the subscription insert section, customerdao.insert should be rollbacked.

Thank you for your help,
Murat

[Hebert Coelho]

Murat Balkan wrote:I wonder how can I include transactional capabilities to this code.

You mean JPA/EJB?

[Murat Balkan]

Hi,
it is not JPA or EJB. It is implemented as POJO.
Thanks,