CODEWITHSUNDEEP
javaservletsjpa
techrhl
techrhl

Reputation: 454

NullPointerException on Apache Server Servlet using JPA

Im trying to display contents of table (test_dept) which is in SQLSERVER I have created a connection profile also. I have written a Servlet like below... But Im getting this error.

enter image description here

import java.io.IOException;
import java.io.PrintWriter;

import javax.persistence.EntityManagerFactory;
import javax.persistence.PersistenceUnit;
import javax.servlet.ServletException;
//import javax.servlet.ServletOutputStream;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

@SuppressWarnings("serial")
@WebServlet(urlPatterns = "/ServletClient")
public class ServletClient extends HttpServlet
{
  @PersistenceUnit
  EntityManagerFactory factory;

  @SuppressWarnings("rawtypes")
  protected void doGet(HttpServletRequest req, HttpServletResponse resp)
          throws ServletException, IOException
  {
//ServletOutputStream out = resp.getOutputStream();
    PrintWriter pw = resp.getWriter();

    java.util.List list = factory.createEntityManager().createQuery("select f from test_dept f;").getResultList();
    pw.println("<html><body bgcolor=silver text=green><table>");
    for (Object tdp : list)
    {
      pw.println("In The Loop");
      pw.println("<tr><td>" + ((TestDept) tdp).getDptnam() + "</td></tr>");
    }
    pw.println("</table>");
    pw.println("<font size=35><b>List created AdapChain</b></font>");
    pw.println("</body></html>");
  }
}

Upvotes: 0

Views: 71

Answers (1)

Steve C
Steve C

Reputation: 19445

I don't think any version of Apache Tomcat supports injection of EntityManager or EntityManagerFactory objects out of the box.

You need to choose a server platform that supports more of the JavaEE specification.

Upvotes: 1

Related Questions