I am pasting the code snippet here ...check and help me out ....
1st JSP PAGE
--------------------
strSQL = "SELECT Product_Status,Product_Id,Product_Desc,Bucket_ID,Bucket_Desc,";
strSQL = strSQL + " Bucket_Type_Code,bmr,base_coverage_code,coverage_desc,price_factor";
strSQL = strSQL + " FROM SPT_Price_Query_VW WHERE ";
if (trim(document.oDoSubmit.txtProduct_ID.value).length != 0)
{
Condition = Condition + " lower(Product_ID) LIKE '" + trim(document.oDoSubmit.txtProduct_ID.value).toLowerCase()
+ "%' AND";
}
if (trim(document.oDoSubmit.txtProduct_Desc.value).length != 0)
{
Condition = Condition + " lower(Product_Desc) LIKE '" + trim(document.oDoSubmit.txtProduct_Desc.value).toLowerCase()
+ "%' AND";
}
if (trim(document.oDoSubmit.txtBucket_ID.value).length != 0)
{
Condition = Condition + " lower(Bucket_ID) LIKE '" + trim(document.oDoSubmit.txtBucket_ID.value).toLowerCase()
+ "%' AND";
}
if (trim(document.oDoSubmit.txtBucket_Desc.value).length != 0)
{
Condition = Condition + " lower(Bucket_Desc) LIKE '" + trim(document.oDoSubmit.txtBucket_Desc.value).toLowerCase()
+ "%' AND";
}
idx = Condition.length;
if (idx == 0)
{
alert("Enter Value for One or More Fields");
return false;
}
Condition = Condition.substring(1,(idx -4));
strSQL = strSQL + Condition + " ORDER BY Product_ID";
document.oDoSubmit.SQLsmt.value = strSQL;
document.oDoSubmit.action="SPTRepPriceQ.jsp";
if (document.oDoSubmit.rdoView(0).checked)
{
document.oDoSubmit.OutputToBrowser.value ="Yes";
}
else
{
document.oDoSubmit.OutputToBrowser.value="No";
}
document.oDoSubmit.submit();
}
CALLS THE SECOND ....JSP PAGE
----------------------------
response.setContentType ("text/html; charset=utf-8");
String SPT = "SPT";
String FILE = "SPTRepPriceQ.jsp";
String strSQL = request.getParameter("SQLsmt");
SptRepPIDQ.setQuery(strSQL);
int status = SptRepPIDQ.QExecute();
String userCountryCode = request.getParameter("currencyCountryCode").trim();
String userProductID = request.getParameter("txtProduct_ID").trim().toLowerCase();
String userProductDescription = request.getParameter("txtProduct_Desc").trim().toLowerCase();
String userBucketID = request.getParameter("txtBucket_ID").trim().toLowerCase();
String userBucketDescription = request.getParameter("txtBucket_Desc").trim().toLowerCase();
String outputType = request.getParameter("OutputToBrowser");
boolean useBrowser = outputType.equalsIgnoreCase("YES");
GETTIN THE VALUES AND DISPLAYING THE .....PAGE ...
THIS IS GIVIN THE BELOW EXCEPTION.........
USING THE WEBLOGIC 6.1 on SOLARIS.....
###<Mar 7, 2003 11:13:32 AM EST> <Error> <HTTP> <susmn210017> <myserver> <ExecuteThread:
'13' for queue: 'default'> <> <> <101020> <[WebAppServletContext(7317111,SPT,/SPT)]
Servlet failed with Exception>
java.net.SocketException: Connection reset by peer: JVM_recv in socket input stream
read
at java.net.SocketInputStream.socketRead(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:85)
at weblogic.servlet.internal.PostInputStream.read(PostInputStream.java:180)
at weblogic.servlet.internal.ServletInputStreamImpl.read(ServletInputStreamImpl.java:125)
at weblogic.servlet.internal.ServletRequestImpl.mergePostParams(ServletRequestImpl.java:1130)
at weblogic.servlet.internal.ServletRequestImpl.parseQueryParams(ServletRequestImpl.java:998)
at weblogic.servlet.internal.ServletRequestImpl.getParameter(ServletRequestImpl.java:1204)
at weblogic.servlet.internal.ServletRequestImpl.getParameter(ServletRequestImpl.java:1190)
at jsp_servlet._jsp._spt._reports.__sptreppriceq._jspService(__sptreppriceq.java:111)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:27)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:265)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:304)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:200)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:2546)
at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2260)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:139)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120)
--------------- nested within: ------------------
weblogic.utils.NestedRuntimeException: Cannot parse POST parameters of request:
'/SPT/jsp/spt/reports/SPTRepPriceQ.jsp' - with nested exception:
[java.net.SocketException: Connection reset by peer: JVM_recv in socket input
stream read]
at weblogic.servlet.internal.ServletRequestImpl.mergePostParams(ServletRequestImpl.java:1157)
at weblogic.servlet.internal.ServletRequestImpl.parseQueryParams(ServletRequestImpl.java:998)
at weblogic.servlet.internal.ServletRequestImpl.getParameter(ServletRequestImpl.java:1204)
at weblogic.servlet.internal.ServletRequestImpl.getParameter(ServletRequestImpl.java:1190)
at jsp_servlet._jsp._spt._reports.__sptreppriceq._jspService(__sptreppriceq.java:111)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:27)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:265)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:304)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:200)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:2546)
at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2260)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:139)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120)