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?
Which part of "DO NOT POST USER QUESTIONS HERE" didn't you understand?