AFAIK the best answer to date is
http://www.theserverside.com/patterns/thread.jsp?thread_id=9597.
Basically you respond immediately to the user (via flushBuffer) while still processing
the request in the
service method.
Ciao,
Marco
----- Original Message -----
From: Andrea
To: [EMAIL PROTECTED]
Sent: Thursday, January 17, 2002 4:17 PM
Subject: servlet and oracle procedures
Hi all
I'm new to servlet and I have a problem
I call a oracle procedure from a servlet in this way
CallableStatement cstmt;
cstmt=DB.connection.prepareCall(sql);
cstmt.setString(1, PROFILO);
cstmt.setString(2, DESCR);
cstmt.setInt(3, codtask);
cstmt.setInt(4, Integer.parseInt(COD_PROGETTO) );
int risultato=cstmt.executeUpdate();
the procedure starts and ends but tooks a lot of time and i take a websever timeout
can i do nothing to avoid this situation?
Can I call a procedure an regain control whitout waiting for the procedure
response ?
Thanks
Andrea
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
