Databases
StackOverflow2013
Postsdbo
PONullPointerException in JSP with Tomcat
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PONullPointerException in JSP with Tomcat
    primarykey
    data
    text
    <p>That's my code in jsp when i run it a get an error as below. I am using tomcat . I really want to know what may be the cause of this problem?</p> <p>test.jsp</p> <pre><code>&lt;%@page import="java.sql.Connection"%&gt; &lt;%@page import="java.sql.ResultSet"%&gt; &lt;%@page import="admin.User"%&gt; &lt;%@page import="admin.ConnectionManager"%&gt; &lt;%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%&gt; &lt;!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"&gt; &lt;html&gt; &lt;head&gt; &lt;meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"&gt; &lt;title&gt; test &lt;/title&gt; &lt;/head&gt; &lt;body&gt; &lt;div&gt; &lt;table&gt; &lt;% ResultSet rs = User.loadAll(); while (rs.next()) { %&gt; &lt;tr&gt; &lt;TH&gt;ID&lt;/TH&gt; &lt;TH&gt;Name&lt;/TH&gt; &lt;TH&gt;Surname&lt;/TH&gt; &lt;TH&gt;Email&lt;/TH&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt; &lt;%= rs.getInt(1) %&gt; &lt;/td&gt; &lt;td&gt; &lt;%= rs.getString(2) %&gt; &lt;/td&gt; &lt;td&gt; &lt;%= rs.getString(3) %&gt; &lt;/td&gt; &lt;td&gt; &lt;%= rs.getString(4) %&gt; &lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/div&gt; &lt;% } %&gt; &lt;/body&gt; &lt;/html&gt; </code></pre> <p>HTTP Status 500 - java.lang.NullPointerException</p> <hr> <pre><code>type Exception report message java.lang.NullPointerException description The server encountered an internal error that prevented it from fulfilling this request. exception org.apache.jasper.JasperException: java.lang.NullPointerException org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:502) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:430) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) root cause java.lang.NullPointerException org.apache.jsp.test_jsp._jspService(test_jsp.java:75) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:388) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) note The full stack trace of the root cause is available in the Apache Tomcat/6.0.36 logs. </code></pre> <hr> <p>Apache Tomcat/6.0.36</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USataylor
    1. USarual
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COTry wrapping your while loop in a null check, to see if you're actually getting a result back from your user load: `if (rs != null) {...`
      singulars
      1. PONullPointerException in JSP with Tomcat
      1. USNathaniel Ford
    2. COWhat exactly is null? Trace your exception.
      singulars
      1. PONullPointerException in JSP with Tomcat
      1. USskuntsel
    3. COCheck the test_jsp.java file that is located under Tomcat/work directory. It is your JSP file translated to java and on the line 75 you will recognize your own java code you inserted into the JSP page.
      singulars
      1. PONullPointerException in JSP with Tomcat
      1. USBalazs Zsoldos
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload