But in this case if i use CMT and if i throw exception from updateUserTable3() method this transaction will be rolled back... am i right? m just confused.... So in this case rollback be acheived by CMT?!
if i use setRollbackonly if exception is thrown would this rollback the transaction?
In this case i am not at all using Entity bean. I am updating 3 table in single EO method. e.g. UpdateProfile. i.e. i am invoking 3 dao methods from updateProfile EO method.
Now in this case if call to update first two table is successful but if method call to update 3rd table fails i.e. 3rd DAO method fails i want rollback the whole transaction.
i.e i want to rollback the database updates to keep database in consistent state.
When one of the database update fails i am throwing application specific exception.
Can this database rollback be achieved using CMT? Please advise me how to do this without using entity beans.