Results 1 to 2 of 2
  1. #1
    progyan das is offline Member
    Join Date
    May 2011
    Posts
    1
    Rep Power
    0

    Default getting gateway timeout while executing a stored procedure via jdbc

    Hi,

    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.

  2. #2
    doWhile is offline Moderator
    Join Date
    Jul 2010
    Location
    California
    Posts
    1,641
    Rep Power
    7

Similar Threads

  1. java call stored procedure
    By namalsera in forum JDBC
    Replies: 1
    Last Post: 01-04-2011, 03:53 PM
  2. Debug mySql stored procedure
    By ulix83 in forum NetBeans
    Replies: 0
    Last Post: 10-29-2009, 11:48 AM
  3. Replies: 2
    Last Post: 01-30-2009, 12:53 PM
  4. stored procedure
    By sankarigopi in forum JDBC
    Replies: 1
    Last Post: 11-13-2008, 04:53 PM
  5. How to get multiple rows from Stored Procedure
    By SRJ1957 in forum Advanced Java
    Replies: 0
    Last Post: 08-11-2008, 08:26 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •