Win a copy of Kotlin in Action this week in the Kotlin forum!
    Bookmark Topic Watch Topic
  • New Topic

Problem inputing to MySQL table  RSS feed

Niall Moynihan
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.*" %>
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);

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

Jeanne Boyarsky
author & internet detective
Posts: 37242
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Report post to moderator
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.
Bear Bibeault
Author and ninkuma
Posts: 66207
IntelliJ IDE Java jQuery Mac Mac OS X
  • 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
Boost this thread!