Hi Could u please tell me what happens if a database stored procedure is called when a conflicting ejb transaction is in progress? In my case, the stored procedure is unable to modify anything but doesn't throw any exception! here is a scenario to simulate such a conflict : ============================================ ...inside a session bean method (TRANSACTION_SERIALIZABLE and TX_REQUIRED) ... String name; name = entityBeanObj.getCompanyName(id); //1 sleep(10000); //execute servlet X during this interval name = entityBeanObj.getCompanyName(id); //2 ... ============================================ Servlet X This calls a stored proc that updates the company name for the same id ============================================ As expected, I got the same name for both invocations of getCompanyName. But the stored procedure does not return any exception though it was unable to update. Am i doing something wrong here? Thanks in anticipation. Sriram Narayan =========================================================================== To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff EJB-INTEREST". For general help, send email to [EMAIL PROTECTED] and include in the body of the message "help".
