1 Reply Latest reply on May 12, 2004 11:57 AM by Adrian Brock

    transaction issue

    zhangj Newbie

      I have a jsp call a stateless session bean method,this method call and execute a stored procedure.
      this stored procudure failed beacuse inside stored procedure,it call
      master..xp_cmdshell

      but the login doesn't have permit to access master databse
      but some tables updated by this stored procedure.

      the ejb and method have transaction attribute as "Required".
      my question is ,if master..xp_cmdshell failed,the transaction should be roll back.but looks like it doesn't,why?