how to bring variable from previous session to next session

[Megha Singhal]

my jsp form is like that there is table having edit and delete option in each row
so when i click on edit button
through following it take me to the servlet with the help of P_id variable which is unique in my database and it should redirect me to the jsp page

function editRecord(P_ID){

window.location.href="../edit/UserServlet?"+P_ID;
}

following is my servlet code

import java.io.*;   
import java.sql.*;   
import javax.servlet.*;   
import javax.servlet.http.*;   
import java.util.*;   
import java.lang.String;   
import java.sql.Connection;
import javax.servlet.RequestDispatcher;  
import java.sql.Statement;   
import java.sql.ResultSet;   
import javax.naming.*;   
import javax.naming.directory.*;   
import oracle.jdbc.pool.OracleDataSource;  


public class UserServlet extends HttpServlet{ 

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");
			PrintWriter out = response.getWriter();
			String str = request.getQueryString();

			int P_ID = Integer.parseInt(str);

			Connection con = null;   
    			Statement st1 = null;   
    		
    			ResultSet rs = null;   
     			
   		 try {   
       
     			 Context initContext = new InitialContext();                     
      			 Context envContext = (Context) initContext.lookup("java:/comp/env");                     
      			OracleDataSource ds = (OracleDataSource) envContext.lookup("jdbc/abc");                      
     			 if (envContext == null)throw new Exception("Error: No Context");                   
      			if (ds == null) throw new Exception("Error: No DataSource");                    
      			if (ds != null)                           
     			 con = ds.getConnection();   
      
      			st1 = con.createStatement();  
				
				ArrayList userList=null;
				String query = "select * from LTCINFO.PERSONS where P_ID="+P_ID;
				
				st1 = con.createStatement();
				  rs = st1.executeQuery(query);

				while(rs.next())
				{
				  
				  userList =new ArrayList();
				  userList.add(rs.getInt(1));
				  userList.add(rs.getString(2));
				  userList.add(rs.getString(3));

				  userList.add(rs.getString(4));
				  userList.add(rs.getString(5));
				  
				}


				request.setAttribute("userList",userList);
				
                String nextJSP ="../editUser.jsp";

				RequestDispatcher dispatcher = request.getRequestDispatcher(nextJSP);
				dispatcher.forward(request,response);
				 rs.close();   
                    st1.close(); 
				 con.close();   
  
        } catch (SQLException se) {   
            out.println("An Error Had occurred while accessing the database");   
            out.println("<HR>");   
  
            out.println(se.getMessage());   
        }   
           
        catch (Exception e) {   
            e.printStackTrace();   
            
        } finally {   
            try {   
                if (rs != null)   
                    rs.close();   
                if (st1 != null)   
                    st1.close();  
 
                if (con != null)   
                    con.close();   
            } catch (Exception e) {   
                out.println(e);   
            }   
        }   
   


			
  }
}                                                                                                                                                                                                                                                                                                                                                                                                                                                                              

but it is not redirecting to the jsp page i tried to check the code but putting out.println on various places then i find that due that session it is not working because if i am passing any particular value of P_ID then it is working
here i am using following

String str = request.getQueryString();
int P_ID = Integer.parseInt(str);

as in session string can be passed but P_ID is integer type so i have to do typecasting but i think it is not taking that but this session is working in my delete code so i used in this also. i am not getting why this is not working in my edit code.

[Maneesh Godbole]

Please do not post, essentially the same question, multiple times.
Let us continue the discussion in your original topic here http://www.coderanch.com/t/571694/Servlets/java/exception-while-running-code