title: Servlet Code error: http 500 Internal Server Error
body: <p>I'm trying to run the following code but It always results in a "http 500 Internal Server Error"</p>
  
  <p>Could someone help me debug this error</p>
  
  <p>I just started learning Servlets and JSP..So please excuse me if I miss any details in the question. Looking in the MYSQL database error logs, I found the following entries: </p>
  
  <blockquote>
    <p>Aborted connection 44 to db: 'sakila' user: 'root' host: 'localhost' (Got an error reading communication packets)</p>
  </blockquote>
  
  <pre><code>protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
      // TODO Auto-generated method stub
      response.setContentType("text/html");
      PrintWriter out=response.getWriter();
      final String DB_URL="jdbc:mysql://localhost:3306/sakila";
      final String user="root";
      final String password="pass1234";
      Statement stmt=null;
      try {
          Class.forName("com.mysql.jdbc.Driver");
      } catch (ClassNotFoundException e) {
          // TODO Auto-generated catch block
          out.println("Cannot load driver");
      }
      Connection conn=null;
  
      try {
          conn=DriverManager.getConnection(DB_URL,user,password);
      } catch (SQLException e) {
          // TODO Auto-generated catch block
          out.println("Cannot Connect to Database");
      }
  
      //out.print("Connected to Database");
      out.println("&lt;html&gt;");
      out.println("&lt;body&gt;");
      String str= "SELECT actor_id, first_name last_name FROM temp where actor_id='1';";
  
      try {
          ResultSet rs=stmt.executeQuery(str);
          while(rs.next()){
              out.println(rs.getString("actor_id"));
  
          }
  
      } catch (SQLException e1) {
          // TODO Auto-generated catch block
          e1.printStackTrace();
      }       
      /*
      try {
          ResultSet rs;
          rs = stmt.executeQuery(str);
          while(rs.next()){
              int i=rs.getInt("actor_id");
              String fn= rs.getString("first_name");
              String ln=rs.getString("last_name");
  
              out.print(i+"::");
              out.print(fn+"::");
              out.print(ln+"::");
          }
      } catch (SQLException e1) {
          // TODO Auto-generated catch block
          e1.printStackTrace();
      }
  
      */
      out.print("hkshfdkhfakfshdkha");
  
  
  
  
      try {
          conn.close();
      } catch (SQLException e) {
          // TODO Auto-generated catch block
          e.printStackTrace();
      }
  
      out.println("&lt;/body&gt;");
      out.println("&lt;/html&gt;");
  
  
  }
  </code></pre>