getServletContext null pointer exception

[labrensz]

Hi,

I have been unable to get at the servletcontext param values.  I keep
getting the null pointer exception.
I have looked thru all the archives and quite a few sites trying all the
recommendations, but to no avail.
Must be doing something really stupid, or I've missed a basic concept
somewhere.
I am running tomcat 3.2.1

Any hints would be gratefully appreciated.
Thanks in advance.
Chuck


Here's my web.xml and the code trying to get at it.

<web-app>
    <display-name>jdbctut</display-name>
    <description>This is version X.X of an application to
perform</description>
    <context-param>
      <param-name>dbuser</param-name>
      <param-value>fabdev</param-value>
      <description>User name to logon to the Db.</description>
    </context-param>
    <servlet>
      <servlet-name>DataBaseSelect</servlet-name>
      <description> This servlet </description>
      <servlet-class>DataBaseSelect</servlet-class>
      <!-- Load this servlet at server startup time -->
      <load-on-startup>5</load-on-startup>
    </servlet>
    <servlet-mapping>
      <servlet-name>DataBaseSelect</servlet-name>
      <url-pattern>jdbctut</url-pattern>
    </servlet-mapping>
    <session-config>
      <session-timeout>30</session-timeout>    <!-- 30 minutes -->
    </session-config>
</web-app>

import java.sql.*;
import java.util.Vector;
import javax.servlet.http.*;
import javax.servlet.*;
import java.io.*;
public class DataBaseSelect extends HttpServlet {
   
   private Vector result;
   private String url =
"jdbc:informix-sqli://poldev:2005/fabdev:INFORMIXSERVER=poldev_713_tcp";

  public void init( ServletConfig config ) throws
javax.servlet.ServletException{
     super.init( config ) ; // Essential!!
  }
     
   public DataBaseSelect() {
      result = new Vector();
   } // constructor DataBaseSelect
   
   public String connect() {
      try {
         Class.forName("com.informix.jdbc.IfxDriver").newInstance();
         return "Driver Loaded!";
      } catch (Exception E) {
         return "Unable to load driver.";
      }
   }
   
   public String select() {
//      String value = getServletContext().getInitParameter("dbuser");
//
System.out.println(getServletConfig().getServletContext().getInitParameter("
dbuser"));
        ServletConfig sc = getServletConfig(); 
            ServletContext sctx = sc.getServletContext();
        System.out.println(sctx.getInitParameter("dbuser"));

      try {
         Connection C = DriverManager.getConnection(url, "fabdev",
"fabdev$");
         Statement Stmt = C.createStatement();
         ResultSet myResult = Stmt.executeQuery("SELECT lst_nm from
person_profile ORDER BY lst_nm");
         
         while (myResult.next()) {
            result.addElement(myResult.getString(1));
         }
         
         // Clean up
         myResult.close();
         Stmt.close();
         C.close();
         return "Connection Success!";
      } catch (SQLException E) {
                return "SQLException: " + E.getMessage();
      }
   }
      
   /**
    * Accessor for result
    **/
   public Vector getResult() {
      return result;
   }
   
   /**
    * Mutator for result
    **/
   public void setResult(Vector avector) {
     result = avector;
   }  
   
} // class DataBaseSelect










Sure there's apathy in the world.
But who cares.



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]