SQLException: No data found

[Harshal Gurav]

Hi All,
What will be possible reasons of above exception?
In program once user added all data in add operation,my next operation will be view.once i click on the save button,after inserting all data i make operation as view which call view part of the program. but getting above mentioned exception at marked lines
here is code

  
 
/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
 
package com.stores;
 
import java.sql.*;
import javax.sql.*;
import java.text.*;
import java.io.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
 
/**
 *
 * @author admin
 */
public class Gatepassreturn extends HttpServlet {
 
    /**
    * Processes requests for both HTTP <code>GET</code> and <code>POST</code> methods.
    * @param request servlet request
    * @param response servlet response
    */
    public void doGet(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException
    {
doPost(request,response);
}
    public void doPost(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException
    {
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter out = response.getWriter();
        HttpSession session = request.getSession();
 
        try {
 
                SimpleDateFormat slashdate = new SimpleDateFormat("dd/MM/yyyy");
                SimpleDateFormat dashdate = new SimpleDateFormat("dd-MMM-yyyy");
                SimpleDateFormat databasedate = new SimpleDateFormat("yyyy-MM-dd");
                String uid = getServletConfig().getServletContext().getInitParameter("conuser");
String pas = getServletConfig().getServletContext().getInitParameter("conpass");
String usercode = "CIRIUS";
ArrayList<String> hdrdetails = new ArrayList<String>();
ArrayList<String> hdrcode = new ArrayList<String>();
                ArrayList<String> rowdetails = new ArrayList<String>();
                ArrayList<String> errorarray = new ArrayList<String>();
                ArrayList<String> header = new ArrayList<String>();
                ArrayList<String> details = new ArrayList<String>();
                String dt = request.getParameter("dt");
                String entrynumber = "";
String errorcode = null;
String errorfield = "";
                String actrows = request.getParameter("actualrows");
                System.out.println("actrows"+actrows);
 
               ResultSet datarst = (ResultSet)session.getAttribute("rst");
 

                String oper = request.getParameter("operation");
                System.out.println("operation"+oper);
 
                        ResultSet rst=null;
                        ResultSet rst1=null;
                        ResultSet rst2=null;
                        String date="";
                        String Eno="";
 
                        String rows = request.getParameter("rows");
                        out.println("rows"+rows);
                        System.out.println("rows"+rows);
//String actrows = request.getParameter("actualrows");
String entryn = request.getParameter("entryno");
                        System.out.println("entryn"+entryn);
                        String Gateno="";
                        Gateno = request.getParameter("gatepassno");
                        out.println("Gateno"+Gateno);
                       // System.out.println("date"+request.getParameter("todate").trim());
                        String dat="";
                        String todate="";
                        try{
                        todate=(dashdate.format(slashdate.parse(request.getParameter("todate").trim())));
                        System.out.println("todate"+todate);
                        }catch(Exception e)
                        {
                          e.printStackTrace();
                        }
 

                    /*
                        String unit = (String)session.getAttribute("unitname");
                        String dept = (String)session.getAttribute("deptname");
                        String div = (String)session.getAttribute("divname");
                        String cocode = (String)session.getAttribute("cocode");
                        String coname = (String)session.getAttribute("coname");
                        String ayear = (String)session.getAttribute("finyear");
                        String usercode = (String)session.getAttribute("usercode");
                       */
                    String Gateentrydate = dashdate.format(new java.util.Date());
                    out.println("Gateentrydate"+Gateentrydate);
                     String gateno = request.getParameter("gateno");
                     String Prepby = request.getParameter("prepare");
                     System.out.println("Prepby"+Prepby);
                    String authhsign = request.getParameter("sign");
 
                    ArrayList<Integer> serials = new ArrayList<Integer>();
    ArrayList<String> material = new ArrayList<String>();
                    ArrayList<Integer> quantity = new ArrayList<Integer>();
                    ArrayList<String> uom = new ArrayList<String>();
                    ArrayList<String> bearername = new ArrayList<String>();
                    ArrayList<String> uconsignee = new ArrayList<String>();
                    ArrayList<String> modvat = new ArrayList<String>();
                    ArrayList<String> remark = new ArrayList<String>();
 
                        int entryno = 0,deprequest = 0,actualrows = 0,rowcount = 0;
 

 
               /*         String entrydt = dashdate.format(new java.util.Date());
                *
                *
 

                  */
 
        try{
                    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                    Connection connection = DriverManager.getConnection("jdbc:odbc:Sample1",uid,pas);
                    Statement stmt= connection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
                    Statement stmt2 = connection.createStatement();
                    Statement stmt3 = connection.createStatement();
                    Statement stmt4 = connection.createStatement();
                if (oper.equals("add")) {
 

                    System.out.println("Inside the add operation");
                    try {
                        rst1 = stmt2.executeQuery("select seqentryno.nextval as Eno from dual");
                        while (rst1.next()) {
                            Eno = rst1.getString("Eno");
                           out.println("Eno"+Eno);
                        }
 
                    } finally {
                        if (rst1 != null) {
                            rst1.close();
                            rst1 = null;
                        }
                    }
 
                      }
                 else if(oper!=null && oper.equals("quit")){
                                    session.removeAttribute("rst");
                                    oper = null;
                                            }
                else if(oper.equals("save") || oper.equals("update")) {
                    System.out.println("inside the save");
 
                       if(entryn!=null){
 
                            entryno = Integer.valueOf(entryn);
             }
 
                       if(!rows.equals("") && !actrows.equals("")){
                                    rowcount = Integer.valueOf(rows);
                                    actualrows = Integer.valueOf(actrows);
 
                                                                    }
 
                    try{
                        /*
             * Retrieving various field description from form(visible description)
             */
 

                        try{         for(int i=1;i<=rowcount;i++){
 
                                         if(request.getParameter("srno"+i)!=null){
 
                                          out.println("rowcount  rowcount  rowcount14haresh"+rowcount);
                                            serials.add(Integer.valueOf(request.getParameter("srno"+i).trim()));
                                             out.println("serial size"+serials);
                                    }}
                  }catch(Exception e)
                  {
                  out.println("first exception+e"+e);
                  }
 

                       for(int i=1;i<=rowcount;i++){
 
                                        if(request.getParameter("dom"+i)!=null){
material.add(request.getParameter("dom"+i));
hdrdetails.add(request.getParameter("dom"+i));
}else{
                                  material.add("");
                                  hdrdetails.add("");
                                }
                                        if(request.getParameter("qty"+i)!=null){
quantity.add(Integer.valueOf(request.getParameter("qty"+i)));
hdrdetails.add(request.getParameter("qty"+i));
}else{
                                  quantity.add(0);
                                  hdrdetails.add("");
                                }
                                        if(request.getParameter("uom"+i)!=null){
uom.add(request.getParameter("uom"+i));
hdrdetails.add(request.getParameter("uom"+i));
}else{
                                  uom.add("");
                                  hdrdetails.add("");
                                }
 
                                        if(request.getParameter("bname"+i)!=null){
bearername.add(request.getParameter("bname"+i));
hdrdetails.add(request.getParameter("bname"+i));
}else{
                                  bearername.add("");
                                  hdrdetails.add("");
                                }
                                        if(request.getParameter("consignee"+i)!=null){
uconsignee.add(request.getParameter("consignee"+i));
hdrdetails.add(request.getParameter("consignee"+i));
}else{
                                  uconsignee.add("");
                                  hdrdetails.add("");
                                }
                                        if(request.getParameter("modvat"+i)!=null){
modvat.add(request.getParameter("modvat"+i));
hdrdetails.add(request.getParameter("modvat"+i));
}else{
                                  modvat.add("");
                                  hdrdetails.add("");
                                }
 
                                        if(request.getParameter("remark"+i)!=null){
remark.add(request.getParameter("remark"+i));
hdrdetails.add(request.getParameter("remark"+i));
}else{
                                  remark.add("");
                                  hdrdetails.add("");
                                }
 
                                }
                       System.out.println("hdrdetails;"+hdrdetails+"");
 
                            }catch(Exception e)
                            {
                    System.out.println("error2;"+e+"");
                        }
                       try{
                        if(oper.equals("save")){
                       CallableStatement cstmt = connection.prepareCall("{? = call f_docnumsub(?,?,?,?,?,?,?)}");
                            cstmt.registerOutParameter(1, java.sql.Types.VARCHAR);
                            cstmt.setString(2, "BML001");
                            cstmt.setString(3, "AMB001");
                            cstmt.setString(4, "WS");
                            cstmt.setString(5, "RQ");
                            cstmt.setString(6, "2008");
                            cstmt.setString(7, "01-Apr-2008");
                            cstmt.setString(8, "XXXXXX");
                            cstmt.execute();
                            Gateno = cstmt.getString(1);
                            System.out.println("gate Number = "+Gateno);
                            cstmt.close();
 
                            if(Gateno.equals("XXXXXX")){
                                    String query4 = "insert into CMSTDOCFRQ(COCODE,FYBEGDT,FREQNUM,PREFIX,SUFFIX,TXNTYPE,BANKCODE,SUBCODE,DIVCODE)"+
                                    " values('BML001','01-Apr-2008','Y','RQ','WS','RQ','WS','XXXXXX','AMB001')";
                                    System.out.println(query4);
                                    int ans1 = stmt2.executeUpdate(query4);
                                    query4 = "insert into CMSTDOCNUM(alertmsg,cocode,txntype,finperiod,prefix,suffix,lusedno,bankcode,"+
                                    "divcode,subcode,fybegdt) values('','BML001','RQ','2008','RQ','WS',0,'WS','AMB001','XXXXXX','01-Apr-2008')";
                                    System.out.println(query4);
                                    int ans2 = stmt2.executeUpdate(query4);
                                    if(ans1==1 && ans2==1){
                                            cstmt = connection.prepareCall("{? = call f_docnumsub(?,?,?,?,?,?,?)}");
                                            cstmt.registerOutParameter(1, java.sql.Types.VARCHAR);
                                            cstmt.setString(2, "BML001");
                                            cstmt.setString(3, "AMB001");
                                            cstmt.setString(4, "WS");
                                            cstmt.setString(5, "RQ");
                                            cstmt.setString(6, "2008");
                                            cstmt.setString(7, "01-Apr-2008");
                                            cstmt.setString(8, "XXXXXX");
                                            cstmt.execute();
                                            Gateno = cstmt.getString(1);
                                            System.out.println("New gateno Number = "+Gateno);
                                            cstmt.close();
                                    }
                            }
                       //  stmt3=connection.createStatement();
                        connection.setAutoCommit(false);
                        String query="Insert into PTXNRTGPHDR (ENTRYNO,GATEPASSNO,ENTRYDT,ISDEPT,AUTHSIGN,USERCODE,RTDT)VALUES("+entryn+",'"+Gateno+"','"+Gateentrydate+"','"+Prepby+"','"+authhsign+"','"+usercode+"','"+todate+"')";
                        System.out.println(query);
                        stmt3.addBatch(query);
                        System.out.println("serials size"+serials.size());
                       for(int i=0,j=1;i<serials.size();i++,j++){
                            System.out.println("Inside the Statement");
                            query="Insert into PTXNRTGPDTL (BRKNO,ENTRYNO, MATERIAL, SCRQTY, SUOM, BEARER, UCONSIGNER, MODVAT, REMARKS)VALUES("+serials.get(i)+","+entryn+",'"+material.get(i)+"',"+ quantity.get(i)+",'"+ uom.get(i)+"','"+ bearername.get(i)+"','"+ uconsignee.get(i)+"','"+ modvat.get(i)+"','"+ remark.get(i)+"')";
                            System.out.println(query);
                            stmt3.addBatch(query);
                         }
 
                       int[] result=stmt3.executeBatch();
                       stmt3.close();
                       connection.commit();
                       for(int k=0;k<result.length;k++)
                        {
                       System.out.println("rows updated by "+(k+1)+"insert sta:"+result[k]+"");
                       }
 
                        }
                     }catch(BatchUpdateException bue)
                            {
                    System.out.println("error1;"+bue+"");
                    }
                    catch(SQLException sql)
                            {
                    System.out.println("error2;"+sql+"");
                    }
                    catch(Exception l)
                            {
                    System.out.println("error3;"+l+"");
                    }
 
                    if(oper.equals("update")){
 
                        try{
                         int erows = 0,erowsadd=0,actualrowsadd=0;
                                    String query = "select count(*) from PTXNRTGPDTL where ENTRYNO='"+entryn+"'";
                                    System.out.println(query);
                                    rst = stmt2.executeQuery(query);
                                    if(rst.next()){
                                            erows = rst.getInt(1);
                                    }
                                    erowsadd=erows-1;
                                    actualrowsadd=actualrows+1;
                                    System.out.println("erows"+erows);
                                    System.out.println("actualrows"+actualrows);
                                    System.out.println("actualrowsadd"+actualrowsadd);
                                    //System.out.println("erows " +erows + " & rows= " + rowcount + " & actualrows= " + actualrows);
                                    //c1.setAutoCommit(false);
                                    query = "update PTXNRTGPHDR set ISDEPT='"+Prepby+"',AUTHSIGN='"+authhsign+"',RTDT='"+todate+"'where ENTRYNO='"+entryn+"'";
                                    System.out.println(query);
                                    int a = stmt2.executeUpdate(query);
                                    //stmt2.addBatch(query);
                                    if(erows<actualrows){
                                            for(int i=0;i<erows;i++){
                                                System.out.println("when rows are added into table");
                                                    query = "update PTXNRTGPDTL set MATERIAL='"+material.get(i)+"',SCRQTY='"+quantity.get(i)+"',SUOM='"+uom.get(i)+"',BEARER='"+bearername.get(i)+"',UCONSIGNER='"+uconsignee.get(i)+"',MODVAT='"+modvat.get(i)+"',REMARKS='"+remark.get(i)+"' where ENTRYNO='"+entryn+"' and BRKNO='"+serials.get(i)+"'";
                                                    System.out.println(query);
                                                    a = stmt2.executeUpdate(query);
                                                    System.out.println("upddim= "+a);
                                            }
                                            for(int i=erows;i<actualrows;i++){
                                                    query="Insert into PTXNRTGPDTL (BRKNO,ENTRYNO, MATERIAL, SCRQTY, SUOM, BEARER, UCONSIGNER, MODVAT, REMARKS)VALUES("+serials.get(i)+","+entryn+",'"+material.get(i)+"',"+ quantity.get(i)+",'"+ uom.get(i)+"','"+ bearername.get(i)+"','"+ uconsignee.get(i)+"','"+ modvat.get(i)+"','"+ remark.get(i)+"')";
                                                    System.out.println(query);
                                                    a = stmt2.executeUpdate(query);
                                                    System.out.println("adddtl= "+a);
 
                                            }
                                    }else{
                                            if(erows>actualrows){
                                                System.out.println("when rows are deleted");
                                                    for(int i=0;i<actualrows;i++){
                                                           query = "update PTXNRTGPDTL  set MATERIAL='"+material.get(i)+"',SCRQTY='"+quantity.get(i)+"',SUOM='"+uom.get(i)+"',BEARER='"+bearername.get(i)+"',UCONSIGNER='"+uconsignee.get(i)+"',MODVAT='"+modvat.get(i)+"',REMARKS='"+remark.get(i)+"' where ENTRYNO='"+entryn+"' and BRKNO='"+serials.get(i)+"'";
                                                            System.out.println(query);
                                                            a = stmt2.executeUpdate(query);
                                                            //stmt2.addBatch(query);
 
                                                    }
                                                    for(int i=actualrowsadd;i<=erows;i++){
 
                                                            query = "delete from PTXNRTGPDTL  where ENTRYNO='"+entryno+"' and BRKNO='"+i+"'";
                                                            System.out.println(query);
                                                            a = stmt2.executeUpdate(query);
                                                            //stmt2.addBatch(query);
                                                    }
                                            }else{
                                                    if(erows==actualrows){
                                                        System.out.println("when no row added and deleted");
                                                            for(int i=0;i<actualrows;i++){
                                                                    query = "update PTXNRTGPDTL  set MATERIAL='"+material.get(i)+"',SCRQTY='"+quantity.get(i)+"',SUOM='"+uom.get(i)+"',BEARER='"+bearername.get(i)+"',UCONSIGNER='"+uconsignee.get(i)+"',MODVAT='"+modvat.get(i)+"',REMARKS='"+remark.get(i)+"' where ENTRYNO='"+entryn+"' and BRKNO='"+serials.get(i)+"'";
                                                                    System.out.println(query);
                                                                    a = stmt2.executeUpdate(query);
                                                            }
                                                    }
                                            }
                                    }
                                    /*int[] check = stmt2.executeBatch();
                                    c1.commit();*/
                                    Gateno = "";
                                    Prepby = "";
                                    authhsign = "";
                                    todate="";
                                    oper = "view";
 
                    }catch(Exception e)
                        {
                          System.out.println("exception"+e);
                        }
                    }
 
                }
                else if(oper!=null && oper.equals("delete")){
                if(!entryn.equals("")){
                   entryno = Integer.valueOf(entryn);
                }
                //c1.setAutoCommit(false);
                String query = "delete from PTXNRTGPHDR where ENTRYNO='"+entryno+"'";
                System.out.println(query);
                stmt2.executeUpdate(query);
 
                query = "delete from PTXNRTGPDTL where ENTRYNO='"+entryno+"'";
                System.out.println(query);
                stmt2.executeUpdate(query);
                gateno ="";
                Prepby ="";
                todate="";
                authhsign ="";
                oper = "view";
            }
                    if(oper!=null && (oper.equals("view") || oper.equals("modify"))){
                    System.out.println("Inside the view operation");
                    int op = -1;
                     if (datarst != null) {
                    rst = datarst;
                    System.out.println("datarst");
                    if(oper.equals("view")){
                        String viewop = request.getParameter("viewop");
                        System.out.println("viewop"+viewop);
                        if(!viewop.equals("")){
                            op = Integer.valueOf(viewop);
                            System.out.println("opop"+op);
                            if (op != -1) {
                                switch (op) {
                                    case 0:
                                        if (!rst.isFirst()) {
                                            rst.previous();
                                        }
                                        break;
                                    case 1:
                                        if (!rst.isLast()) {
                                            System.out.println("case1");
                                            rst.next();
                                        }
                                        break;
                                    case 2:
                                        rst.first();
                                        break;
                                    case 3:
                                        rst.last();
                                        break;
                                }
                            }
                        }
                     }
                    System.out.println("errorcode= "+errorcode);
                    } else {
                    System.out.println("new");
                    StringBuffer query = new StringBuffer("select NVL(ENTRYNO,''),NVL(GATEPASSNO,''),NVL(ENTRYDT,''),NVL(ISDEPT,''),NVL(AUTHSIGN,''),NVL(RTDT,'') from PTXNRTGPHDR");
                    if( !Gateno.equals("") || !entryn.equals("")  || (dt!=null && !dt.equals(""))){
                        query.append(" where");
                    }
                    int qchk = 0;
                    if(!Gateno.equals("")){
                        if(qchk==1){
                            query.append(" and GATEPASSNO like '"+Gateno+"%'");
                        }else{
                            query.append(" GATEPASSNO like '"+Gateno+"%'");
                            qchk = 1;
                        }
                    }
                    if(!entryn.equals("")){
                        if(qchk==1){
                            query.append(" and ENTRYNO like '"+entryn+"%'");
                        }else{
                            query.append(" ENTRYNO like '"+entryn+"%'");
                            qchk = 1;
                        }
                    }
                    if((dt!=null && !dt.equals(""))){
                        dt = dashdate.format(slashdate.parse(dt));
                        if(qchk==1){
                            query.append(" and ENTRYDT ='"+dt+"'");
                        }else{
                            query.append(" ENTRYDT = '"+dt+"'");
                            qchk = 1;
                        }
                    }
                    if(errorcode==null){
                        System.out.println("query= "+query.toString());
                        rst = stmt.executeQuery(query.toString());
                        if(rst.next()){
                            System.out.println("setting session variable here ");
                            session.setAttribute("rst", rst);
                        }else{
                            errorcode = "No Matching Records found";
                        }
                    }
                }
                if(errorcode==null){
                    session.setAttribute("rst", rst);
                    System.out.println("rowdetails1="+header);
                    [B]header.add(rst.getString(1));[/B]
                    header.add(rst.getString(2));
                    header.add(slashdate.format(databasedate.parse(rst.getDate(3).toString())));
                    header.add(rst.getString(4));
 
                    header.add(rst.getString(5));
 
                    header.add(slashdate.format(databasedate.parse(rst.getDate(6).toString())));
 

                    System.out.println("rowdetails= "+header);
                    if(oper.equals("modify")){
                        entrynumber = rst.getString(1);
                    }
                    try{
                    String query7="select BRKNO,MATERIAL, SCRQTY, SUOM, BEARER, UCONSIGNER, NVL(MODVAT,''),NVL(REMARKS,'') from PTXNRTGPDTL where ENTRYNO ='"+rst.getString(1)+"'";
                    System.out.println("query= "+query7);
                    System.out.println("inside the details part ");
                    rst2 = stmt3.executeQuery(query7);
                    while(rst2.next()){
 
                   String BRKNOs=rst2.getString(1);
                    if(BRKNOs!=null){
                    details.add(BRKNOs);
                    }else
                    {
                     details.add("")   ;
                    }
                  String MATERIALs=rst2.getString(2);
                    if(MATERIALs!=null){
                    details.add(MATERIALs);
                    }else
                    {
                     details.add("")   ;
                    }
                  String SCRQTYs=rst2.getString(3);
                    if(SCRQTYs!=null){
                    details.add(SCRQTYs);
                    }else
                    {
                     details.add("")   ;
                    }
                  String SUOMs=rst2.getString(4);
                    if(SUOMs!=null){
                    details.add(SUOMs);
                    }else
                    {
                     details.add("")   ;
                    }
                  String BEARERs=rst2.getString(5);
                    if(BEARERs!=null){
                    details.add(BEARERs);
                    }else
                    {
                     details.add("")   ;
                    }
                  String UCONSIGNERs=rst2.getString(6);
                    if(UCONSIGNERs!=null){
                    details.add(UCONSIGNERs);
                    }else
                    {
                     details.add("")   ;
                    }
                  String MODVATs=rst2.getString(7);
                    if(MODVATs!=null){
                    details.add(MODVATs);
                    }else
                    {
                     details.add("")   ;
                    }
                    String REMARK=rst2.getString(8);
                    if(REMARK!=null){
                    details.add(REMARK);
                    }else
                    {
                     details.add("")   ;
                    }
 
                        System.out.println("details= "+details);
                    }
                }catch(Exception e)
                    {
                     System.out.println("exception"+e);
                    }
                    request.setAttribute("header",header);
                    request.setAttribute("details",details);
                    stmt2.close();
                    stmt3.close();
                    stmt4.close();
                                    }else{
                    request.setAttribute("errorcode",errorcode);
                }
            }
 

 

 
        }catch(Exception e)
        {
            e.printStackTrace();
        }
 

                request.setAttribute("Entryno",entryn);
                request.setAttribute("entryno",Eno);
         /*      request.setAttribute("unitname", unit);
                request.setAttribute("deptname", dept);
                request.setAttribute("divname", div);
                request.setAttribute("uname", uname);
                request.setAttribute("coname", coname);
                request.setAttribute("usercode", usercode);     */
 
        request.setAttribute("errorcode",errorcode);
request.setAttribute("oper",oper);
        RequestDispatcher view = request.getRequestDispatcher("/stores/Gatepassreturn.jsp");
        view.forward(request,response);
        } finally {
            out.close();
        }
    }
 
}
  

Any suggestion is highly appreciated
Thanks
Harshal

[Shailesh Chandra]

I would look at stacktrace on the first?

Can you post same ?


Shailesh

[Harshal Gurav]

Hi Shailesh,
Thanks for your reply.
Sorry for this lengthi code as it coulld help to understand complete problem

Here is the complete stack trace

 
 
java.sql.SQLException: No data found
        at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7138)
        at sun.jdbc.odbc.JdbcOdbc.SQLGetDataString(JdbcOdbc.java:3907)
        at sun.jdbc.odbc.JdbcOdbcResultSet.getDataString(JdbcOdbcResultSet.java:5698)
        at sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:354)
        at com.stores.Gatepassreturn.doPost(Gatepassreturn.java:508)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:390)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
        at java.lang.Thread.run(Thread.java:619)
 

   

Thanks again
Harshal

[Harshal Gurav]

Hi,
Can anyone help here?
Thanks
Harshal

[Harshal Gurav]

Hi,
Can anyone help here?
Thanks
Harshal

[Jeanne Boyarsky]

Harshal,
While it's good to share all the information available, that is a really long code snippet. I'm not likely to read 17 screens of code (yes I counted) to deduce what line the error is being thrown on. Maybe you could start removing code to come up with a small example that illustrates the problem and point to the offending line directly?