java - JSP - The server encountered an internal error that prevented it from fulfilling this request -


i error @ line 52 , have no idea what's going on. have installed mysql driver, , database connection settings in actor class ok. i'm learning jsp , unable solve on own. help.

log:

type exception report  message exception occurred processing jsp page /index.jsp @ line 52  description server encountered internal error prevented fulfilling request.  exception  org.apache.jasper.jasperexception: exception occurred processing jsp page /index.jsp @ line 52  49:         %> 50:         <%  51:             actor actor = new actor(); 52:             resultset actors = actor.getactors(); 53:             %> 54:     </body> 55: </html>   stacktrace: org.apache.jasper.servlet.jspservletwrapper.handlejspexception(jspservletwrapper.java:588) org.apache.jasper.servlet.jspservletwrapper.service(jspservletwrapper.java:481) org.apache.jasper.servlet.jspservlet.servicejspfile(jspservlet.java:385) org.apache.jasper.servlet.jspservlet.service(jspservlet.java:329) javax.servlet.http.httpservlet.service(httpservlet.java:729) org.apache.tomcat.websocket.server.wsfilter.dofilter(wsfilter.java:53) root cause  java.lang.nullpointerexception org.apache.jsp.index_jsp$actor.getactors(index_jsp.java:48) org.apache.jsp.index_jsp._jspservice(index_jsp.java:166) org.apache.jasper.runtime.httpjspbase.service(httpjspbase.java:70) javax.servlet.http.httpservlet.service(httpservlet.java:729) org.apache.jasper.servlet.jspservletwrapper.service(jspservletwrapper.java:443) org.apache.jasper.servlet.jspservlet.servicejspfile(jspservlet.java:385) org.apache.jasper.servlet.jspservlet.service(jspservlet.java:329) javax.servlet.http.httpservlet.service(httpservlet.java:729) org.apache.tomcat.websocket.server.wsfilter.dofilter(wsfilter.java:53)

code:

    <html>     <head>     <meta http-equiv="content-type" content="text/html; charset=iso-8859-1">     <title>selecting data</title>     </head>     <body>         <h1>selecting data</h1>          <%!             public class actor {         string url = "jdbc:mysql://localhost:8080/sakila";         string username = "root";         string password = "blabla";          connection connection = null;         preparedstatement selectactors = null;         resultset resultset = null;          public actor() {              try {                  connection = drivermanager.getconnection(url, username, password);                  selectactors = connection.preparestatement(                         "select actor_id, first_name, last_name actor");              } catch (sqlexception e) {                 e.printstacktrace();             }          }          public resultset getactors() {              try {                 resultset = selectactors.executequery();             } catch (sqlexception e) {                 e.printstacktrace();             }             return resultset;         }      }     %>     <%          actor actor = new actor();         resultset actors = actor.getactors();         %> </body>


Comments

Post a Comment