Hello,

I am using Hibernate3 with Spring 2.

Can somebody show me how to implement a DAO to update two
tables? Let me explain, there are two tables one is for order line
item and the other for products. Whenever a line item is inserted
I need to update the stock in product table. This should came under
same transaction.

Thank you.

Sudheer

Hi!

If you might update the stock with the help of the the database instead of using your application you might be using a trigger.

btw... The are a few ways to write daos :) Are you using a GenericDAO object something like the one described on http://www.hibernate.org/328.html and http://www.ibm.com/developerworks/java/library/j-genericdao.html? If not, you might want to have a look at it.


-Kaj :)