TS 7.2.1
Hi
We have a callserver in a DCT item which hits a JSP page.This JSP is used to instantiate a java class to do some DB operation. The response time varies depending upon the DB rows retrieved. The alerts given after java function call are not working if the response time is more. The process bar shows 'Done' even before the server side execution is over.Java code executes fully but the JSP alerts are lost. How can we handle this? Please provide your comments.
JSP:
[html]
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<%
@page import="com.gen.DBDataUpdate"%>
<%
@page import="com.interwoven.cssdk.common.CSClient"%>
<%
@page import="org.apache.log4j.Logger"%>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
DB Update
<%@ taglib uri="/WEB-INF/tlds/context.tld" prefix="context" %>
<%!String itemName; %>
createIfNeeded="true"
contextClass="com.interwoven.ui.teamsite.auth.CSClientContext"/>
<%
Logger logger = Logger.getLogger("com.gen.DBDataUpdate");
logger.info("Gen.jsp Call Initiated");
CSClient client = null;
String query = request.getParameter("queryName");
client = user_context.getCSClient();
if(DBDataUpdate.getIsSuccessFull()==0 ){
DBDataUpdate g= new DBDataUpdate(query,client);
g.populateItems(); //This function may take more time depending upon db resultset
if(DBDataUpdate.getIsSuccessFull()==1){
out.println("<script language=\"JavaScript\">");
out.println("alert(\"Completed without errors. Please check the log file for warnings.\");");
out.println("</script>");
}else {
out.println("<script language=\"JavaScript\">");
out.println("alert(\"Exception occurred. Check Log file for errors.\");");
out.println("</script>");
}g=null;
}else{
out.println("<script language=\"JavaScript\">");
out.println("alert(\"Update is already running. Please wait.\");");
out.println("</script>");
}
logger.info("Gen.jsp Finished Executing");
%>
[/html]