samar hasan

Thank you David

but why did this problem appeared when the number of users increased???

sorry if it sounds stupid. but i didn't understand what does that mean !!

I do indent my code!!!

So what's the problem??

import java.io.IOException; import java.text.DecimalFormat; import java.util.Vector; import javax.servlet.*; import javax.servlet.*; public class QryController extends HttpServlet { private HttpServletRequest request = null; private HttpServletResponse response = null; private HttpSession session = null; public void performTask() { String from = request.getRequestURI(); from = from.substring(from.lastIndexOf("/")); try { response.setHeader("Cache-Control", "no-cache"); response.setHeader("Pragma", "no-cache"); response.setDateHeader("Expires", 0); response.setHeader("Expires", "0"); if (from.endsWith("ListEmpVac")) { ListEmpVac(); } else if (from.endsWith("ListVacDetails")) { ListVacDetails(); } } catch (Exception e) { e.printStackTrace(); } } /*******************************************************************************/ public void ListEmpVac() { ListVacDao VacCredit = new ListVacDao(); String empno = (String) session.getAttribute("empno"); EmpBean VacList = VacCredit.getVacList(empno); request.setAttribute("VacList", VacList); try { forward("/vacation.jsp"); return; } catch (Exception e) { e.printStackTrace(); } finally { VacCredit.EndConnection(); } } /*******************************************************************************/ public void ListVacDetails() { VacDetailsDao VacDetails = new VacDetailsDao(); String empno = (String) session.getAttribute("empno"); Vector VDetails = VacDetails.getVacDetails(empno); session.setAttribute("VDetails", VDetails); request.setAttribute("VDetails", null); try { forward("/vac_detail.jsp"); return; } catch (Exception e) { e.printStackTrace(); } finally { VacDetails.EndConnection(); } } /*******************************************************************************/ public void doGet(HttpServletRequest request, HttpServletResponse response) { doPost(request, response); } public void doPost(HttpServletRequest request, HttpServletResponse response) { this.request = request; this.response = response; session = request.getSession(false); performTask(); } /*******************************************************************************/ protected void forward(String url) throws ServletException, IOException, Exception { RequestDispatcher forJsp = getServletContext() .getRequestDispatcher(url); if (forJsp != null) { forJsp.forward(request, response); } else { throw new Exception("RequestDispatcher is null"); } } }

here is a sample of my code

i have a web application running on oracle 9i database and tomcat 5 with jdk 1.4. everything was doing fine until the # of users using the application increased (about 300 users) sessions started mixing. so i used single thread model in my servlets . sessions sttopped mixing but the application (at the peak hour) is very slow. could someone please tell me what to do? i want to get rid of the single threadmodel and keep my sessions away from mixing. does changing to another application server help? JBOSS or tomcat 6??? is there is something wrong with my code??? F1 help help