Hello, 

I am using JBoss 4.0.5, Eclipse 3.2 on windows XP. MySQL 5.0 as backend.

I have strange scenario, where in a stateless session bean, i am counting 
number of times a method A is called as per application requirement. The 
scenario is put in psuedo code as follows:


  | SessionBean1{
  | @TransactionAttribute(REQUIRED)
  |  methodA() throws exception{} 
  | 
  | @TransactionAttribute(REQUIRED)
  |  methodB() throws exception{}
  | }
  | SessionBean2{
  |  count(){
  |      read counter from database and increase counter
  |   }
  | }
  | 

The counter must increase even when the methodA() is throws exception. The 
method execution is:
methodA() -> count() -> methodB()

The database changes that occur in all these methods are OK when things go 
right and all methods are executed sucessfuly. The peoblem occurs when any of 
the method throws exception. The changes are rolled back including the counter. 
Is there anyway i can execute count() method outside transaction so the changes 
in the database are not rolled back. 

I am sure we can set database to read_uncommit but this is not what the rest of 
the application requires except for count table which is used to store count.

I'll appreciate your quick response.

Regards,
Murtuza

View the original post : 
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3994950#3994950

Reply to the post : 
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3994950
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user

Reply via email to