I am calling a Stored procedure from stateless session bean method. Stateless bean's method is having Transaction attribute as RequiresNew. I have not done any commit/rollback in Stored procedure expecting ejb container to do it.
But the db changes made by stored procedure are not getting commited.
Is there any restriction of calling stored procedures from EJBs???
Is there any work around to control transaction from ejb,yet doing updations in stored procedure?