Null pointer exception when accessing database

Hi Folks,
Ive been trying to create a mini crud sample using JSP's ,however Im getting a null pointer exception upon trying to insert into the database . Upon checking I found that the request object does contain the passed data, however the same leads to a NPE when inserting to the DB , ive placed the code below. Any help would be great.
Thanks a lot!

<HTML>
 <HEAD> <TITLE>Domain database.</TITLE> </HEAD>
 <BODY>
<%@ page import="java.util.*" %>
<%@ page import="java.sql.*" %>
 <P> Update Database Content
 <FORM ACTION="addData.jsp" METHOD="POST">
   <TR>
  <TD> Code   <INPUT TYPE=TEXT NAME=code> <BR></TD>
  
  <TD>Description <INPUT TYPE=TEXT NAME=description><BR></TD>
  </TR>
  
 
  <INPUT TYPE=Submit VALUE="Add to Database">
 </FORM>
 <HR>
 <P> Content of the database:
 <TABLE BORDER=1 CELLPADDING=0 CELLSPACING=0>
 <TR> <TD> Code  </TD>
      <TD> Description</TD>
     
 </TR>
 <%!PreparedStatement stmt = null;
 	Connection con = null;%>
 <%
 	Class.forName("org.postgresql.Driver");
	 java.sql.Connection connection  = java.sql.DriverManager.getConnection("jdbc:postgresql://localhost:5432/WSS1","postgres","postgres");
 	java.sql.Statement statement = connection.createStatement();
   Enumeration parameters = request.getParameterNames();
   if(parameters.hasMoreElements()) {
    //if((request.getParameter("code")!=null)&& (request.getParameter("description")!=null)){ NO CHANGE DESPITE USING THIS LINE..
	  String code  = request.getParameter("code");
    
    String description = request.getParameter("description");
   
    String query= "INSERT INTO DOMAIN (CODE,DESCRIPTION) VALUES (?,?)" ;
	System.out.println("The code is"+code);      // both lines here print well.
	 System.out.println("The code is"+description);
    stmt = con.prepareStatement(query);
	stmt.setString(1, code);
	stmt.setString(2, description);// Throws NPE. No idea why .
	System.out.println("The code is"+code);
	 System.out.println("The code is"+description);
	
		stmt.executeUpdate();
   }
		java.sql.ResultSet columns = statement.executeQuery(
             "SELECT CODE,DESCRIPTION FROM DOMAIN");
   while(columns.next()) {
     String code  = columns.getString("CODE");
     String description = columns.getString("DESCRIPTION");
        %>
       <TR>  <TD> <%= code  %> </TD>
             <TD> <%= description %> </TD>
             
       </TR>
 <% } %>
 </TABLE>
 </BODY>
 </HTML>

Thanks for helping out!

Moved to the JDBC forum.

Thought it was relevant to JSP forums as it was a JSP page . Anyways , help would be much appreciated as its very very urgent .

.Thanks .

Vic Hood wrote:Hi Folks,
Ive been trying to create a mini crud sample using JSP's

Thanks for helping out!

I know you are just doing a sample, but it is wrong approach to do this inside of a JSP. You are aware this connection stuff should be done in Servlet, right?

You create a Connection variable "con" and assign null to it.

Later you try to use it to create a PreparedStatement. It's still null so you get that exception.

Paul Clapham wrote:You create a Connection variable "con" and assign null to it.

Later you try to use it to create a PreparedStatement. It's still null so you get that exception.

Hi Paul ,
Thanks. For replying . I do understand your point . But can't seem to figure out how to solve it , :( . Could you please suggest a work around, to avoid the NPE ? Thanks a lot .

Vic Hood wrote: Could you please suggest a work around, to avoid the NPE ? Thanks a lot .

why not get rid of con entirely and just use connection?

Thanks a ton Tim ! That solved the problem