SessionBean invoked in loop & error:EJBException:Transactionwas rolled back

[Prasad]

Hello there,

Description of the problem:

Struts Action class calling a method in a stateless session bean. The
session bean method calls a PL/SQL procedure and gives the results back
to the Action class.

We are using j2sdk1.4.2_11. Container: OC4J Version 9.0.3.0.0

This works fine if there is less data to process. But the same app
behaves the following way when it has to process large data.

-- Action class calls session bean method - processOrder().
-- Session bean method calls PL/SQL procedure and gets back the results
QUICKLY, BUT just before returning results to the Action class, it goes
back to the first line of session bean method (processOrder()) and
calls PL/SQL, gets the results. Just before returning the results,
again goes to the first line of the method.

-- The above process repeats for 4 times and it throws the following
error.

javax.ejb.EJBException: Transaction was rolled back: timed out; nested
exception is: java.rmi.RemoteException: No Exception - originate
from:java.lang.Exception: No Exception - originate from:; nested
exception is:
java.lang.Exception: No Exception - originate from:
java.rmi.RemoteException: No Exception - originate
from:java.lang.Exception: No Exception - originate from:; nested
exception is:
java.lang.Exception: No Exception - originate from:
java.lang.Exception: No Exception - originate from:
at com.evermind.server.ejb.EJBUtils.makeException(EJBUtils.java:913)
at
ShipmentLocal_StatelessSessionBeanWrapper6.createShipment(ShipmentLocal_StatelessSessionBeanWrapper6.java:195)
at
com.genco.rps.action.operation.PrepareShipmentAction.processAction(PrepareShipmentAction.java:125)
at com.genco.rps.action.common.BaseAction.execute(BaseAction.java:165)
at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:721)
at
com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:306)
at
com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:767)
at
com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:259)
at
com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:106)
at
EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:803)
at java.lang.Thread.run(Thread.java:479)


Thank you for your help.

Regards,
Prasad Pondugula.