Hi, I have 2 Entity Beans and one Session Bean. One method in the session bean ("placeOrder") has to update two DIfferent DB tables (eg: customer wants to buy, therefore insert record into ORDER table and UPDATE a record in CURRENT_STOCK table). This method MUST perform BOTH these operations as *ONE* DB transaction to maintain DB integrity. How do I achieve this using CMP2.0 ???? (I have created the tables and modelled the relationships bet. them already, just not sure how to specify the transaction related stuff)
Also, if I use BMP then I'm hoping that this will be sufficient (put into ONE of the entity beans) :- con = getConnection() con.setAutoCommmit(false) *--CALL ENTITY EJB method 1 - create Order--* *--CALL ENTITY EJB method 2 - reduce current stock--* con.Commit() IS THE ABOVE ENUFF/OK? THANKS A MILLION!!! __________________________________________________ Do you Yahoo!? New DSL Internet Access from SBC & Yahoo! http://sbc.yahoo.com ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user