title: issue requesting db result set after sometimes, i do make a request to sql but i don,t receive any error in logs only loader is visible
body: <p>My DaoImpl works for some hours, then I don't know why when I make a request to it. It does not respond. Loading process in browser is waiting for response even it makes request to db procedure,
  after every 2 minutes the same request is again raise in the logs without requesting by clicking button and it keeps happening to hit db proc continuously every 2 second but not getting result set, the control gets stuck after firing executemethod()  to get dbresultset and its only happening in this daoimpl rest all procedures work fine.</p>
  <p>No thread concept has been implemented manually, the issue is only taking place in prod environment</p>
  <p>Controller</p>
  <pre><code>@RequestMapping(value={&quot;/roomListing&quot;}, method={RequestMethod.GET,RequestMethod.POST})
  public ModelAndView roomInvoiceLisitng(@ModelAttribute final RoomInvoiceForm vRoomInvoiceForm, HttpServletRequest request,HttpServletResponse response){
      LOGGER.info(&quot;inside RoominvoiceController :: roomInvoiceLisitng()::chreq::&quot;+vRoomInvoiceForm.getChreq());
      LOGGER.info(&quot;inside RoominvoiceController :: roomInvoiceLisitng()::chreq::&quot;+request.getParameter(&quot;chreq&quot;));
      LOGGER.info(&quot;inside RoominvoiceController :: roomInvoiceLisitng()::propId::&quot;+request.getParameter(&quot;propId&quot;));
  
      
  
      
      ModelAndView model=null;
      String vPropId;
      String ChannelProp_id;
      String vCard_details_privliedge = null;
      String vINCDflag = null;
      String chreq=&quot;&quot;;
      
      
      String path = request.getContextPath();
      String sessionId;
      String uniqueID=null;
      ArrayList&lt;RoomInvoiceDto&gt; vProductServiceInfo = new ArrayList&lt;RoomInvoiceDto&gt;();
      HttpSession session = request.getSession(true);
      try{
          //HttpSession session=request.getSession();
          LOGGER.info(&quot;sessionid:&quot;+session.getId());
          chreq=ResUtil.checkNull(request.getParameter(&quot;chreq&quot;)).equals(&quot;&quot;)?vRoomInvoiceForm.getChreq():ResUtil.checkNull(request.getParameter(&quot;chreq&quot;));
          
          
      
          if(ResUtil.checkNull(chreq).equalsIgnoreCase(&quot;Y&quot;)){
              //sessionId=(String)session.getAttribute(&quot;sessionId&quot;);
              //ChannelProp_id=(String)session.getAttribute(&quot;ChannelProp_id&quot;);
              vPropId=ResUtil.checkNull(request.getParameter(&quot;propId&quot;)).equalsIgnoreCase(&quot;&quot;)?vRoomInvoiceForm.getPropId():ResUtil.checkNull(request.getParameter(&quot;propId&quot;));
          }else{
              vPropId=(String) session.getAttribute(&quot;Prop_id&quot;);
              //sessionId=session.getId();
          }       
          
          /*if(!ResUtil.checkNull(vRoomInvoiceForm.getSessionId()).equalsIgnoreCase(&quot;&quot;)){
              uniqueID=vRoomInvoiceForm.getSessionId();
          }else{
               uniqueID = UUID.randomUUID().toString();
          }*/
          LOGGER.info(&quot;sessionId:&quot;+uniqueID);
          LOGGER.info(&quot;session:&quot;+session);
          LOGGER.info(&quot;propId:&quot;+vPropId);
          User_Refund=(String) session.getAttribute(&quot;User_Refund&quot;);
          LOGGER.info(&quot;inside RoominvoiceController :: refund flag&quot;+User_Refund);
          
          RoomInvoiceForm pRoomInvoiceForm=vRoomInvoiceService.roomInvoiceList(vRoomInvoiceForm, vPropId,request, response);
          
      model= new ModelAndView(&quot;room-invoice/roominvoice_listing&quot;,&quot;vRoomList&quot;,pRoomInvoiceForm.getvRoomInvoiceList());
      model.addObject(&quot;RoomInvoiceForm&quot;, pRoomInvoiceForm);
      
      model.addObject(&quot;errorMsg&quot;, request.getAttribute(&quot;errorMsg&quot;));
      }catch(Exception e){
          LOGGER.info(&quot;roomInvoiceListing:&quot;+e);
      }   
      return model;
      
  }
  </code></pre>
  <p>DAO Implementation</p>
  <pre><code>@Override
      public RoomInvoiceForm roomInvoiceList(RoomInvoiceForm vRoomInvoiceForm,String vProp_Id, HttpServletRequest request,
              HttpServletResponse response) {
          LOGGER.info(&quot;----------------- Start of RomInvoiceDaoImpl :: getroomInvoiceList() -------------&quot;);
          String vIsError=null;
          String vErrorDesc=null;
          Integer pageCount=0;
          Integer totalPage=0;
          RowSet dbResultSet = null;
          //HttpSession vSession = request.getSession(false);
          Procedure vProcedure = ProcedureFactory.getProcedure();
          ProcedureMetaData vProcedureMeta;
          ArrayList&lt;RoomInvoiceDto&gt; vRoomList = new ArrayList&lt;RoomInvoiceDto&gt;();```
  
          //String vPattern = &quot;dd-MM-yyyy&quot;;
          //String dateInString =new SimpleDateFormat(vPattern).format(new Date());
  
          try {
              LOGGER.info(&quot;----------------- Start try block RomInvoiceDaoImpl :: getroomInvoiceList() -------------&quot;);
              vProcedureMeta = new ProcedureMetaData(&quot;pr$roominvoice_search_newmars_temp&quot;);
              vProcedureMeta.addParameter(ResUtil.checkNull(vProp_Id),java.sql.Types.VARCHAR,false);                                                                      //1 propId
              vProcedureMeta.addParameter(vRoomInvoiceForm.getSearchPaymentStatus()==null?&quot;&quot;:vRoomInvoiceForm.getSearchPaymentStatus(),java.sql.Types.VARCHAR,false);     //2 mod_status
              vProcedureMeta.addParameter(vRoomInvoiceForm.getSearchInvoice()==null?&quot;&quot;:vRoomInvoiceForm.getSearchInvoice(),java.sql.Types.VARCHAR,false);                 //3 mod invoiceno   
              vProcedureMeta.addParameter(vRoomInvoiceForm.getSearchEmail()==null?&quot;&quot;:vRoomInvoiceForm.getSearchEmail(),java.sql.Types.VARCHAR,false);                     //4 mod_cust_mail
              vProcedureMeta.addParameter(vRoomInvoiceForm.getSearchLastName()==null?&quot;&quot;:vRoomInvoiceForm.getSearchLastName(),java.sql.Types.VARCHAR,false);               //5 lastname
              vProcedureMeta.addParameter(vRoomInvoiceForm.getSearchAmount()==null?0.00:Double.parseDouble(vRoomInvoiceForm.getSearchAmount()),java.sql.Types.DOUBLE,false);//6 amt
              vProcedureMeta.addParameter(vRoomInvoiceForm.getSearchRefenceNo()==null?&quot;&quot;:vRoomInvoiceForm.getSearchRefenceNo(),java.sql.Types.VARCHAR,false);             //7 search by ref
              vProcedureMeta.addParameter(vRoomInvoiceForm.getSearchDateType()==null?&quot;&quot;:vRoomInvoiceForm.getSearchDateType(),java.sql.Types.VARCHAR,false);               //8 search by
              vProcedureMeta.addParameter(vRoomInvoiceForm.getSearchFromDate()==null?&quot;&quot;:vRoomInvoiceForm.getSearchFromDate(),java.sql.Types.VARCHAR,false);               //9 from Date
              vProcedureMeta.addParameter(vRoomInvoiceForm.getSearchToDate()==null?&quot;&quot;:vRoomInvoiceForm.getSearchToDate(),java.sql.Types.VARCHAR,false);                   //10 To Date
              vProcedureMeta.addParameter(&quot;&quot;, java.sql.Types.VARCHAR, false);                                        //11 export flag
              vProcedureMeta.addParameter(&quot;&quot;,java.sql.Types.VARCHAR,false);                                                                                             //12 room type
              vProcedureMeta.addParameter(vRoomInvoiceForm.getPageNumber(),java.sql.Types.INTEGER,false);                                                             //13 pageNumber
              vProcedureMeta.addParameter(vRoomInvoiceForm.getPageSize(),java.sql.Types.INTEGER,false);                                                               //14 pageSize
              vProcedureMeta.addParameter(0,java.sql.Types.INTEGER,true);         //15  pageSize
              vProcedureMeta.addParameter(0,java.sql.Types.INTEGER,true);         //16  page Number   
              vProcedureMeta.addParameter(null,java.sql.Types.VARCHAR,true);      //17 error
              vProcedureMeta.addParameter(null,java.sql.Types.VARCHAR,true);      //18 error_desc 
              vProcedureMeta.addParameter(null,ProcedureMetaData.TYPE_CURSOR,true);//19 cursor
              if(vProcedureMeta != null){ 
                  LOGGER.info(&quot;roomInvoiceList :: vProcedureMeta&quot;);
                  ProcedureMetaData procedureMetaOut = vProcedure.execute(vProcedureMeta);
                  LOGGER.info(&quot;roomInvoiceList :: vProcedureMeta:&quot;+procedureMetaOut.getDbConnectionType());
                  pageCount = (Integer)(procedureMetaOut.getParameterByindex(15)).getOutputValue();
                  totalPage = (Integer)(procedureMetaOut.getParameterByindex(16)).getOutputValue();
                  vIsError = (String)(procedureMetaOut.getParameterByindex(17)).getOutputValue();
                  vErrorDesc = (String)(procedureMetaOut.getParameterByindex(18)).getOutputValue();
                  dbResultSet = (RowSet)(procedureMetaOut.getParameterByindex(19).getOutputValue());
                  vRoomInvoiceForm.setPageCount(pageCount);
                  vRoomInvoiceForm.setTotalPage(totalPage);
                  vRoomInvoiceForm.setPageNumber(vRoomInvoiceForm.getPageNumber());
                  vRoomInvoiceForm.setPageSize(vRoomInvoiceForm.getPageSize());
                  vRoomInvoiceForm.setTotalCount(totalPage);
                  
                  LOGGER.info(&quot;vIsError:&quot;+vIsError+&quot;\t&quot;+&quot;vIsError Desc&quot;+vErrorDesc+&quot;\t&quot;+&quot;totalPage:&quot;+totalPage+&quot;\t&quot;+&quot;pageCount:&quot;+pageCount);
                  if(dbResultSet!=null){
                      while(dbResultSet.next() ){
                          RoomInvoiceDto vRoomInvoiceDto= new RoomInvoiceDto();
                          
                          
                          vRoomInvoiceDto.setINV_CRT_DATE(dbResultSet.getString(&quot;INV_CRT_DATE&quot;));
                          vRoomInvoiceDto.setMod_status(dbResultSet.getString(&quot;mod_status&quot;));
                          vRoomInvoiceDto.setMod_mer_orderno(dbResultSet.getString(&quot;mod_mer_orderno&quot;));
                          vRoomInvoiceDto.setMode_Arrival(dbResultSet.getString(&quot;Mode_Arrival&quot;));
                          vRoomInvoiceDto.setMode_Departure(dbResultSet.getString(&quot;Mode_Departure&quot;));
                          vRoomInvoiceDto.setInv_exe_date(dbResultSet.getString(&quot;Inv_exe_date&quot;));
                          vRoomInvoiceDto.setMod_amt(dbResultSet.getString(&quot;mod_amt&quot;));
                          vRoomInvoiceDto.setMobile_num(dbResultSet.getString(&quot;mobile_num&quot;));
                          vRoomInvoiceDto.setMod_cust_mail(dbResultSet.getString(&quot;mod_cust_mail&quot;));
                          vRoomInvoiceDto.setInvoice_send_by(dbResultSet.getString(&quot;invoice_send_by&quot;));
                          vRoomInvoiceDto.setRb_id(dbResultSet.getString(&quot;rb_id&quot;));
                          vRoomInvoiceDto.setRb_order_no(dbResultSet.getString(&quot;rb_order_no&quot;));
                          vRoomInvoiceDto.setCurr_id(dbResultSet.getString(&quot;curr_id&quot;));
                          vRoomInvoiceDto.setRbd_total_amt(dbResultSet.getString(&quot;rbd_total_amt&quot;));
                          vRoomInvoiceDto.setRbd_original_amt(dbResultSet.getString(&quot;rbd_original_amt&quot;));
                          vRoomInvoiceDto.setMod_checksum(dbResultSet.getString(&quot;mod_checksum&quot;));
                          vRoomInvoiceDto.setTracking_id(dbResultSet.getString(&quot;tracking_id&quot;));
                          vRoomInvoiceDto.setPatial_amt_per(dbResultSet.getString(&quot;patial_amt_per&quot;));
                          vRoomInvoiceDto.setPatial_amt_flat(dbResultSet.getString(&quot;patial_amt_flat&quot;));
                          vRoomInvoiceDto.setMod_id(dbResultSet.getString(&quot;mod_id&quot;));
                          //vRoomInvoiceDto.setMod_refno(dbResultSet.getString(&quot;mod_refno&quot;));
                          vRoomInvoiceDto.setMod_cust_first_name(dbResultSet.getString(&quot;mod_cust_first_name&quot;));
                          vRoomInvoiceDto.setMod_cust_last_name(dbResultSet.getString(&quot;mod_cust_last_name&quot;));
                          vRoomInvoiceDto.setInv_created_by(dbResultSet.getString(&quot;inv_created_by&quot;));
                          vRoomInvoiceDto.setSettele_date(dbResultSet.getString(&quot;settele_date&quot;));
                          vRoomInvoiceDto.setMod_refund_date(dbResultSet.getString(&quot;mod_refund_date&quot;));
                          vRoomInvoiceDto.setMod_refund_amt(dbResultSet.getString(&quot;mod_refund_amt&quot;));
                          vRoomInvoiceDto.setTrans_log_id(dbResultSet.getString(&quot;trans_log_id&quot;));
                          vRoomInvoiceDto.setGtw_id(dbResultSet.getString(&quot;gtw_id&quot;));
                          vRoomInvoiceDto.setRefund_flag(dbResultSet.getString(&quot;refund_flag&quot;));
                          vRoomInvoiceDto.setActivity(dbResultSet.getString(&quot;Activity&quot;));
                          //vRoomInvoiceDto.setAgent(dbResultSet.getString(&quot;agent&quot;));
                          vRoomList.add(vRoomInvoiceDto);
                      }
                  }               
                  vRoomInvoiceForm.setvRoomInvoiceList(vRoomList);
                  //LOGGER.info(&quot;-----------------Size Of  RoomInvoiceDaoImpl :: getroomInvoiceList() -------------&quot;+e);
              }
          }catch (Exception e) {
              e.printStackTrace();
              LOGGER.info(&quot;----------------- Exception in  RoomInvoiceDaoImpl :: getroomInvoiceList() -------------&quot;+e);
  
              }
          finally{
              try{
                  if(dbResultSet != null) {
                      LOGGER.info(&quot;----------------- Finally in  RoomInvoiceDaoImpl :: getroomInvoiceList() -------------&quot;);
                      dbResultSet.close();
                      }
                  vProcedure.closeResources();                    
              }
              catch(Exception exception){
                  exception.printStackTrace();
              }
          }
          LOGGER.info(&quot;----------------- End of RoomInvoiceDaoImpl :: getroomInvoiceList() -------------&quot;);
          return vRoomInvoiceForm;
  
      }
  </code></pre>