2

I am using a struts2 framework which is basically like:-

ActionClass
execute
{
    call function in business class which returns an object and store this object in session
    redirect to jsp
}

BusinessClass
function()
{
    sysout("start");
    call a stored procedure via jdbc //this procedure returns 40 cursors and takes 6,7 mins to execute
    call setter methods of object and return object
    sysout("end");
}

JSP

The problem is that the procedure is taking a lot of time to execute and after that its called again and again because i am getting the sysouts "start"again and again.Finally,I see a gateway timeout error even adding session timeout in web.xml.If i dont put session timeout in web.xml then its throwing null pointer exception in action class while storing the object in session.Also,This problem is happening only after i deployed the code in unix server.In local,its working fine.I am using Tomcat 6.0 as web container.Can someone please explain why the procedure is called many times even though there is no looping.Is it somehow related to the fact that the procedure is returning 40 cursers.

Improve this question
1
  • Please rearrange your question. Commented May 4, 2011 at 8:38
Related questions
1
Asp.Net Gives a Timeout Error While Running a Stored Procedure
3
Oracle stored procedure hanging when called via jdbc
0
jsp mysql server connection timeout
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.