aspose file tools*
The moose likes JDBC and the fly likes Problem inputing to MySQL table Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Reply locked New topic
Author

Problem inputing to MySQL table

Niall Moynihan
Greenhorn

Joined: Apr 22, 2005
Posts: 15
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>
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 30752
    
156

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.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 61413
    
  67

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 ]

[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Problem inputing to MySQL table