Return-Path: Delivered-To: apmail-jakarta-tomcat-user-archive@apache.org Received: (qmail 9868 invoked from network); 8 Apr 2002 18:56:42 -0000 Received: from unknown (HELO nagoya.betaversion.org) (192.18.49.131) by daedalus.apache.org with SMTP; 8 Apr 2002 18:56:42 -0000 Received: (qmail 18530 invoked by uid 97); 8 Apr 2002 18:56:28 -0000 Delivered-To: qmlist-jakarta-archive-tomcat-user@jakarta.apache.org Received: (qmail 18514 invoked by uid 97); 8 Apr 2002 18:56:28 -0000 Mailing-List: contact tomcat-user-help@jakarta.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Tomcat Users List" Reply-To: "Tomcat Users List" Delivered-To: mailing list tomcat-user@jakarta.apache.org Received: (qmail 18503 invoked from network); 8 Apr 2002 18:56:27 -0000 Message-ID: <71B56021D147D411A2C700508BADCA3C01E79819@DENMAIL1> From: "Philip Kazmier, CEM R&D" To: "'tomcat-user@jakarta.apache.org'" Subject: NullPointerException when using JDBC ResultSet next() method Date: Mon, 8 Apr 2002 11:55:45 -0600 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: text/plain; charset="iso-8859-1" X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N I am getting this error in a servlet compiled on Win2K, using JDK1.3.1 and Tomcat 3.3 with MySQL 3.23.47: Location: /PSSoftware/servlet/ListAllOpenBugs Internal Servlet Error: java.lang.NullPointerException at ListAllOpenBugs.doGet(ListAllOpenBugs.java:45) at javax.servlet.http.HttpServlet.service(HttpServlet.java) at javax.servlet.http.HttpServlet.service(HttpServlet.java) at org.apache.tomcat.facade.ServletHandler.doService(Unknown Source) at org.apache.tomcat.core.Handler.invoke(Unknown Source) at org.apache.tomcat.core.Handler.service(Unknown Source) at org.apache.tomcat.facade.ServletHandler.service(Unknown Source) at org.apache.tomcat.core.ContextManager.internalService(Unknown Source) at org.apache.tomcat.core.ContextManager.service(Unknown Source) at org.apache.tomcat.modules.server.Http10Interceptor.processConnection(Unknown Source) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(Unknown Source) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(Unknown Source) at java.lang.Thread.run(Thread.java:484) Here is the servlet code: public class MySQLTest extends HttpServlet { public void doGet(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException { Connection con = null; Statement stmt = null; ResultSet rs = null; res.setContentType("text/html"); PrintWriter out = res.getWriter(); try { // Load the MySQL driver Class.forName("org.gjt.mm.mysql.Driver"); //try { //Class.forName("twz1.jdbc.mysql.jdbcMysqlDriver"); //} //catch(Exception e){out.println(e);} // Get a connection to the database con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test?user=root&pass word=typhoon"); // Create a statement object stmt = con.createStatement(); // Execute and SQL query, get a result set rs = stmt.executeQuery("SELECT * from test"); // Display the result set as a list out.println("Test"); out.println(""); out.println("
    "); while(rs.next()) { out.println("
  • " + rs.getString("test")); } out.println("
"); out.println(""); } catch (ClassNotFoundException e) { out.println("Couldn't load the database driver-> " + e.getMessage()); } catch(SQLException e) { out.println("SQLException caught: " + e.getMessage()); } finally { try { if (con != null) con.close(); } catch(SQLException ignored) { } } } }; As you can see I tried this with Oracle. I get the same result when I used Oracle. Thanks. Phil Kazmier Developer, CEM NICE Systems Denver, Colorado Office (720) 264-4284 -- To unsubscribe: For additional commands: Troubles with the list: