strange.. !! plz help me..

Well, i'm into something kinda new problem..
here it goes..
Actually, I have a servlet, which works fine when you submit the log-in page..
But you know,.. I have a MENU at the top of the page.. and when you click on it..( linking it to the same servlet ).. it gives a problem..
It's a NULL pointer Exception.. but why..??
here is the problem.. :
Will not all the Queries RUN again..???

servlet runs fine, when form is submitted.. thats the first time servlet runs in the session..
When you click on the MENU item.. i am making it run again..
BUT the results of all the Queries are showing NULL.. why is this happening..???
Am I going somewhere Wrong ..???
Please let me know.. it would be Great !!
Thanks a lot for your help guy(s)/gal(s)

Are you re-executing your Statement and getting a new ResultSet?
Once you've exhausted the ResultSet, result.next() is going to continue to return false.

Thx for your reply..
Yeah I am re-executing my Statement to get a new ResultSet.. Is this Wrong..??
Because before anybody clicks on the MENU-item.. there is a possibility that the Home page ( which i'm linking servlet to, changes )..
So re-executing, Am i doing something wrong..??
plz let me know,... it would be GREAT.. !!

You need to show us more of your code.

Thanks a lot..
ok i'm enclosing my code.. (most part .. )
just concentrate on the performTask method...

/**
 *  @author: Prashant
 *  servlet to handle Time-Entry page
 */
package timesheet;
import javax.servlet.*;
import javax.servlet.http.*;
import com.ibm.as400.access.*;
import java.sql.*;
import javax.sql.*;
import java.util.*;
import java.text.*;
import javax.naming.*; 
public class TimeClock extends javax.servlet.http.HttpServlet {

private static DataSource ds=null;

/**
 * Process incoming HTTP GET requests 
 * 
 * @param request Object that encapsulates the request to the servlet 
 * @param response Object that encapsulates the response from the servlet
 */
public void doGet(javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response) throws javax.servlet.ServletException, java.io.IOException {
performTask(request, response);
}
/**
 * Process incoming HTTP POST requests 
 * 
 * @param request Object that encapsulates the request to the servlet 
 * @param response Object that encapsulates the response from the servlet
 */
public void doPost(javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response) throws javax.servlet.ServletException, java.io.IOException {
performTask(request, response);
}
// init() method
public void init(ServletConfig config) throws javax.servlet.ServletException
 {
super.init(config); 
  
    try{
// Retrieve the data source

Hashtable parms = new Hashtable();
parms.put(Context.INITIAL_CONTEXT_FACTORY, com.ibm.ejs.ns.jndi.CNInitialContextFactory.class.getName());

// access naming system
Context context = new InitialContext(parms);
// get DataSource factory object from naming system
ds = (DataSource)context.lookup("jdbc/jdbc**********");

}catch(Exception e)
{   System.out.println("Problem in extracting the Data Source ") ;
    e.printStackTrace(System.out);
}
}
 
// Converting Military to AM/PM format
public String MilitarytoAmPm(String conv)
{
   int in=conv.indexOf(":");
   String p1=conv.substring(0,in);
   String p2=conv.substring(in+1);
   String r=null;
   int int1=Integer.parseInt(p1);
 
      if(int1<12){
 if (int1 ==0) {
r=String.valueOf(int1+12)+":"+p2+" AM";
} else {
  r=String.valueOf(int1)+":"+p2+" AM";
}
}else{
if(int1 !=12){
 r=String.valueOf(int1-12)+":"+p2+" PM";
    }else{
 r=String.valueOf(int1)+":"+p2+" PM";    
    }
}
//System.out.println(r);
 return r;  
}
/**
 * Process incoming requests for information
 * 
 * @param request Object that encapsulates the request to the servlet 
 * @param response Object that encapsulates the response from the servlet
 */
public void performTask(javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response) 
   throws javax.servlet.ServletException, java.io.IOException{

Connection conn=null;
Statement createTable=null;
ResultSet result=null;

HttpSession session=request.getSession(true);
try

{   String theUserId,pwd ;
    theUserId = request.getParameter("name").toUpperCase() ;
    pwd = request.getParameter("passwd");
  
    session.setAttribute("userId",theUserId);
    
  
    AS400 theAS400=new AS400("serverName");
  
    boolean connected =theAS400.validateSignon(theUserId,pwd);
   
   conn=ds.getConnection("name","passwd");

createTable = conn.createStatement (ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);

// Get User Data from EMPDATA database table

result= createTable.executeQuery("SELECT TMSDATA.EMPDATA.SSN , TMSDATA.EMPDATA.FIRSTNAME ,"+
   "TMSDATA.EMPDATA.LASTNAME ,TMSDATA.EMPDATA.MIDDLENAME ,TMSDATA.EMPDATA.WORKLOCATION ,"+
   "TMSDATA.EMPDATA.CLASSIFICATION  FROM TMSDATA.EMPDATA WHERE  ( ( TMSDATA.EMPDATA.USERID ="+"'"+request.getParameter("name")+"'"+" ) )");
     String ssn=null,fname=null,lname=null,mname=null,wloc=null,classification=null;
     while(result.next())
     { 
      ssn=result.getString(1);
      fname=result.getString(2);
      lname=result.getString(3);
      mname=result.getString(4);
      wloc=result.getString(5);
      classification=result.getString(6);
        
     }     
    
String full_name=fname+" "+mname+" "+lname;
session.setAttribute("fullname",full_name);
session.setAttribute("ssn",ssn);

result= createTable.executeQuery("SELECT TMSDATA.DAYSOFF.STARTTIME , TMSDATA.DAYSOFF.ENDTIME ,"+
   "TMSDATA.DAYSOFF.DAYSOFF  FROM TMSDATA.DAYSOFF WHERE  ( ( TMSDATA.DAYSOFF.SSN ="+"'"+ssn+"'"+" ) )");
String startTime=null,endTime=null,daysOff=null;
     while(result.next())
     { 
      startTime=result.getString(1);
      endTime=result.getString(2);
      daysOff=result.getString(3);
     }

startTime=MilitarytoAmPm(startTime);
endTime=MilitarytoAmPm(endTime);

session.setAttribute("startTime",startTime);
session.setAttribute("endTime",endTime);
session.setAttribute("daysOff",daysOff);

// and the code goes on.... i just cut it...
   
        getServletContext().getRequestDispatcher("/TimeClocker.jsp").forward(request, response) ;

}
catch(Exception theException)
{       
theException.printStackTrace();
response.sendRedirect("/employee_invalid.html");
}
   finally{
   // close ResultSet
   try {
   if (result != null)
   result.close ();
   }
catch (SQLException e) {}
   // close Statement
try {
if (createTable != null)
createTable.close ();
           }
catch (SQLException e) {}
  // close Connection
try {
if (conn != null)
conn.close ();
           }
catch (SQLException e) {}

} // end of finally

}
}

one more thing..
Dont worry about request.getParameter(" ** ");
Not a problem there..