Win a copy of Five Lines of Code this week in the OO, Patterns, UML and Refactoring forum!
    Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Bear Bibeault
  • Ron McLeod
  • Jeanne Boyarsky
  • Paul Clapham
Sheriffs:
  • Tim Cooke
  • Liutauras Vilda
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • fred rosenberger
  • salvin francis
Bartenders:
  • Piet Souris
  • Frits Walraven
  • Carey Brown

Problem inputing to MySQL table

 
Greenhorn
Posts: 15
  • Mark post as helpful
  • send pies
  • Report post to moderator
Hello, I am trying to input data into a mySQL database using a JSP but when I run it through localhost I am getting an error saying- root cause java.lang.NullPointerException.
Dose anyone know what the problem is. I have put my code that is causing the problem below. Its taking in the information from another page alright. It just wont write it to the table. Any feedback would be much appreciated.

<%@ page import="javax.servlet.*" %>
<%@ page import="javax.servlet.http.*" %>
<%@ page import="java.sql.*" %>
<%
Class.forName("org.gjt.mm.mysql.Driver");
String strUrl = "jdbc:mysql://localhost/niall";
Connection conn=DriverManager.getConnection (strUrl, "root", "password");
Statement stmt=conn.createStatement();
Connection con = null;
%>
<% // Fetch the form data
String into = request.getParameter("name");


// save info into the user's session
session.setAttribute("name", into);

//out.println(into); //It prints out here alright so it has takin in the information

String template = "INSERT INTO test (name) VALUE(?)";
PreparedStatement pstmt = con.prepareStatement(template);

pstmt.setString(1, into);
pstmt.executeUpdate();



if (pstmt!=null) pstmt.close();
if (con!=null) con.close();
%>

</li>
 
author & internet detective
Posts: 40035
809
Eclipse IDE VI Editor Java
  • Mark post as helpful
  • send pies
  • Report post to moderator
Niall,
There are two objects: "conn" and "con" that you are using interchangeably. "Conn" has the value, so when you refer to "con" it is null.
 
Marshal
Posts: 67415
173
Mac Mac OS X IntelliJ IDE jQuery Java
  • Mark post as helpful
  • send pies
  • Report post to moderator
Niall, please do not cross-post the same question in more than one forum. It wastes people's time when multiple redundant conversations take place.
[ May 04, 2005: Message edited by: Bear Bibeault ]
 
    Bookmark Topic Watch Topic
  • New Topic