public void init(ServletConfig config) throws ServletException {
    super.init(config);
    m_context = config.getServletContext(); // Get the Servlet Context.
    // Initialize the Session Cache. The Session Cache keeps track of
    // all the sessions started by the user.
    m_sessionCache = new Hashtable(10);
    m_myauth = new Authorization(); // Instantiate the authorization class.
  }

  public void service (HttpServletRequest request, HttpServletResponse response)
                                          throws ServletException, IOException {
    // Initialize the servlet path setting
    if (this.s_servletPath == null) {
      String l_servletPath =  request.getRequestURI();
      StringTokenizer st = new StringTokenizer(l_servletPath,"?");
      s_servletPath = st.nextToken();
    }
    // Get the session associated with the request. 
    // If none exists, session is set to null.
    SDSession session = findValidSession (request);

    // Determine the REQUEST_TYPE i.e what is being asked for by looking
    // at the REQUEST_TYPE field first. If REQUEST_TYPE parameter is set,
    // then proper method is invoked.
    String requestType = request.getParameter ("REQUEST_TYPE");
    if (session != null && requestType == null) {
  		endSession (session);
      // Display Log Out Page
      response.setContentType("text/html");
      PrintWriter out = new PrintWriter (response.getOutputStream());
      // Setting the database connection
      Connection l_connection;
      try {
       InitialContext ic = new InitialContext();
       m_dataSource = (DataSource)ic.lookup(m_SURVEY_DATASOURCE);
       l_connection  = m_dataSource.getConnection();
       // Sets the auto-commit property for the connection to be false. 
       // By default, the connections always auto-commit.
       l_connection.setAutoCommit(false);
       out.println(m_myauth.getLoginPage(l_connection, true));
       l_connection.close();
      } catch (SQLException se) {
        System.out.println("SQL Error while connecting to the database : "+
                            se.toString());
      } catch (NamingException ne) {
        System.out.println("Naming Exception Error while connecting to the database : "+
                            ne.toString());
      } catch (Exception ne) {
        System.out.println("Other Error while connecting to the database : "+
                            ne.toString());
      }
      out.close();
    } 
    ...
    } else
      DoAction (requestType, session, request, response);
  }

 public String getJS() {
   return
   "<script language=\"JavaScript1.1\">\n"+

   "var idx = 0;\n"+
   "function swapandHighlight( offset, idx, newIdx )\n"+
   "{\n"+
   " if ( (idx == -1) || ( idx == 0 && newIdx == -1 ) ||\n"+
   " ( idx == document.forms[0].elements[offset].length-1 && newIdx    
   == document.forms[0].elements[offset].length ) )\n"+
   " {\n"+
   " return;\n"+
   "}\n"+
   " swap( offset, idx, newIdx );\n"+
   " document.forms[0].elements[offset].selectedIndex = newIdx;\n"+
   "}\n"+

   ...

    ...

    // For a response Datatype number, check response vaildity
    String l_valid = "";
    if (l_qsn.m_responseDatatype.equalsIgnoreCase("number")) {
       if (l_qsn.m_formatMask == null)
           l_valid = "checkFloat(document.forms[0]."+l_name+")";
       else if (l_qsn.m_formatMask.equalsIgnoreCase("INTEGER"))
           l_valid = "checkInt(document.forms[0]."+l_name+")";
       else if (l_qsn.m_formatMask.equalsIgnoreCase("POSINTEGER"))
           l_valid = "checkPosInt(document.forms[0]."+l_name+") ";
       else if (l_qsn.m_formatMask.equalsIgnoreCase("NEGINTEGER"))
           l_valid = "checkNegInt(document.forms[0]."+l_name+") ";

       ...


     } else if  (l_qsn.m_responseDatatype.equalsIgnoreCase("date")) {
       l_valid = "checkDate('"+l_qsn.m_formatMask+"', 
                            document.forms[0]."+l_name+") ";
     }

     if (!l_valid.equals(""))  {
        l_buffer.append(" onChange=\"javascript:"+l_valid+"\" ");
        p_submitVal.addElement(l_valid);
     }

    ...

...

if (action.equals("PREVIEW_SURVEY")) {
     Survey s = (Survey) session.popElement();
     try {
       session.getConnection().setAutoCommit(false);
       s.wizardFinish(session, request, response,true);
       SRSessionServlet.generateSurveyForm(session.getConnection(),
                           Long.parseLong(s.m_surveyID),response);
       session.getConnection().rollback();
       session.getConnection().setAutoCommit(true);
     } catch (SQLException ex) {
       response.setContentType("text/ascii");
       response.getOutputStream().println("Error: "+ex.toString());
     }
}

...

  public static void generateSurveyForm(Connection p_conn, long p_surveyID, 
                                        HttpServletResponse response)
                                        throws ServletException, IOException {

    PrintWriter out = new PrintWriter (response.getOutputStream());
    Survey l_survey = null;
    try {
      // Create a Survey object to hold the survey definition
      l_survey = new Survey(p_surveyID);
   l_survey.retrieveFromDB(p_conn); // Retrieve Survey contents from the db
   printSurveyForm(out, l_survey, true, false); // Print out HTML form
   } catch (SQLException ex) {
   out.println(" <P><B>Error generating Survey Form</B><p>\n");

   }
   l_survey = null;
   System.gc();
   out.close();
 }

...

// Create a new session.
session = new SDSession (userId, dbConnection);

// Create a client Cookie. Cookies are a mechanism that a servlet can use
// to have clients hold a small amount of state-information associated with
// the user.
Cookie c = new Cookie("SDSessionServlet", String.valueOf (session.getUserId()));

// Put the Session into the Session Cache
m_sessionCache.put (c.getValue(), session);
c.setPath ("/");
response.addCookie(c); // Add the cookie to the response


...

public void service (HttpServletRequest request, HttpServletResponse response)

   throws ServletException, IOException {

 if (this.s_servletPath == null)
   s_servletPath = request.getRequestURI();
   // Get the session associated with the request. If none exists, set session to null.
   SDSession session = findValidSession (request);

...

private SDSession findValidSession (HttpServletRequest request) {

   // Get the Cookies associated with the request
   Cookie c[] = request.getCookies();
   SDSession session = null;

   for (int i=0;(c!= null) && (i<c.length);i++) {
      if (c[i].getName().equals("SDSessionServlet")) {
         String userID = String.valueOf (c[i].getValue());
         session = (SDSession) m_sessionCache.get(userID);
         break;
      }
   }
   return session;
}

public boolean processResponse(SRSession p_session, 
                               HttpServletRequest request, 
                               HttpServletResponse response)
                    throws ServletException, IOException 
{

...

      // Retrieve contents of the survey.
      Survey l_survey = p_session.getSurvey();
      Vector l_contents = l_survey.m_surveyContents;

      // Loop through all the questions in the survey and retrieve
      // the responses to the question from the httpRequest object.
      boolean l_error = false;
      for (int i=0; i<l_contents.size();i++) {
        SurveyElement l_elem = (SurveyElement)l_contents.elementAt(i);

...

public void generateHTML(SDSession p_session, HttpServletRequest p_request,

                             HttpServletResponse p_response) throws Exception {
     String l_chgrpJS = "";
     // Create a ServletOutputStream to write the output
     ServletOutputStream l_out = p_response.getOutputStream();
     // Sets the content type of the response
     p_response.setContentType("text/html");
     if(m_questionId == -1)   { // To create a Question
        if (!this.m_qsnForSurvey)
          // Print the HTML header of the page
          l_out.println(SurveyHTMLUtil.getPageHeader(p_session.getUserId(),
          "Create a new Question","QUESTION",false,p_session.getUserFlag()));
        else
          l_out.println("<HTML><HEAD><TITLE>Create Question for Survey</TITLE>" +

                        "</HEAD><BODY bgcolor=\"#c0c0c0\">");
        String l_errors = new String(this.m_error);
        if (!l_errors.equals(""))
          l_out.println("<FONT SIZE=+2>ERRORS: </FONT><BR>"+l_errors);

        // Display the guide lines to create a Question in HTML page
        l_out.println("<BR><CENTER><TABLE bgcolor=#c0c0c0 border=1 WIDTH=475>");
        l_out.println("<TR><TD><FONT FACE=\"Arial,Helvetica\" size=2>");
        l_out.println(" Using this form you can create a new Question. ");
        l_out.print(" To create a new Question:&nbsp;<BR>");
        l_out.println("&nbsp;. Enter the Question Name, Text and choose a ");
        l_out.print("Question Format<BR>");
        l_out.println("&nbsp;. Choose the type of question  and enter the ");
        l_out.print("properties<BR>");
        l_out.println("&nbsp;. Save the Question by pressing the Create button");
        l_out.println("</TR></TD></FONT></TABLE></CENTER><BR>");

...

      ...

      // Select the CLOB column to write the HTML data
      l_pstmt = l_connection.prepareStatement(
         "select survey_generated from survey_pregen p where survey_id = ? for update");
      l_pstmt.setInt(1,l_surID);
      l_rst = l_pstmt.executeQuery();

      if (l_rst.next()) { // CLOB column found
        CLOB l_clob = ((OracleResultSet)l_rst).getCLOB(1); // Retrieve CLOB column
        // Open stream to write character data
        Writer l_surveyStream = l_clob.getCharacterOutputStream();
        // Generate the HTML for the survey
        StringBuffer l_buffer = SRSessionServlet.getSurveyHTML(l_connection, l_surID);

      ...

 public void generateSurveyForm(SRSession p_session, HttpServletResponse response)
                      throws ServletException, IOException {
    // Obtain survey response output stream
    PrintWriter out = new PrintWriter (response.getOutputStream());
    response.setContentType("text/html");
    Connection l_conn = p_session.getConnection(); // Obtain the database connection
    try {
      long l_surID = p_session.getSurveyID(); // Survey ID
      Survey l_survey = null; // Object holds the survey definition
      StringBuffer l_buffer = null; // Object holds survey HTML
      // Check if the survey is present in the cache
      boolean found = false;
      for (int i=0;i<3;i++) {
        if (m_surveyCache[i] != null && m_surveyCache[i].m_surveyID == l_surID
            &&  !m_surveyCache[i].isExpired()) {    // Valid survey found
          m_surveyCache[i].setUsed(); // Set the last used time for the survey
          l_survey = m_surveyCache[i].m_survey; // Obtain the survey definition from cache

          l_buffer = m_surveyCache[i].m_htmlBuffer; // Obtain the survey HTML from cache
          found = true; // Set the found flag
          break;
        }
      }

      if (!found) { // Survey not found in cache
        // Retrieve Survey definition from the database
        l_survey = new Survey(p_session.getSurveyID());
        l_survey.retrieveFromDB(l_conn);

        // Query to retrieve pregenerated survey from the CLOB column,
        // survey_generated from the table survey_pregen

        PreparedStatement l_pstmt = l_conn.prepareStatement(
          "select use_pregen_ind , survey_generated from survey_pregen where survey_id = ?");
        l_pstmt.setLong(1, p_session.getSurveyID());
        ResultSet l_rst = l_pstmt.executeQuery();

        // If pregenerated survey found, and the use_pregen_ind flag is set to true,
        // Read survey HTML from the CLOB
        if (l_rst.next() && l_rst.getString(1).equals("Y")) {
          // Retrieve CLOB column to read survey HTML
          oracle.sql.CLOB l_clob = ((oracle.jdbc.driver.OracleResultSet)l_rst).getCLOB(2);
          // Open a character stream
          Reader l_surveyStream = l_clob.getCharacterStream();
          l_buffer = new StringBuffer(); // Holds the survey HTML
          char[] l_buff = new char[1000]; // Temporary buffer
          int l_nread = 0;

          // Read from the clob read stream, and read the survey HTML into the
          // StringBuffer, l_buffer.
          while ((l_nread=l_surveyStream.read(l_buff)) != -1) // Until done
            l_buffer.append(l_buff,0,l_nread);
          l_surveyStream.close(); // Close stream.

        } else { // Survey needs to be generated dynamically

       ...