slipz1337
asked on
How can I fix this issue?
org.apache.jasper.JasperEx ception: An exception occurred processing JSP page /category.jsp at line 54
51: Category dbcategory=new Category();
52: ArrayList<Category> T=new ArrayList<Category>();
53: T= dbcategory.allCategories() ;
54: Iterator<Category> itr = T.iterator();
55: while(itr.hasNext())
56: {
57: dbcategory=itr.next();
Stacktrace:
org.apache.jasper.servlet. JspServlet Wrapper.ha ndleJspExc eption(Jsp ServletWra pper.java: 510)
org.apache.jasper.servlet. JspServlet Wrapper.se rvice(JspS ervletWrap per.java:4 19)
org.apache.jasper.servlet. JspServlet .serviceJs pFile(JspS ervlet.jav a:313)
org.apache.jasper.servlet. JspServlet .service(J spServlet. java:260)
javax.servlet.http.HttpSer vlet.servi ce(HttpSer vlet.java: 717)
org.netbeans.modules.web.m onitor.ser ver.Monito rFilter.do Filter(Mon itorFilter .java:393)
root cause
java.lang.NullPointerExcep tion
org.apache.jsp.category_js p._jspServ ice(catego ry_jsp.jav a:116)
org.apache.jasper.runtime. HttpJspBas e.service( HttpJspBas e.java:70)
javax.servlet.http.HttpSer vlet.servi ce(HttpSer vlet.java: 717)
org.apache.jasper.servlet. JspServlet Wrapper.se rvice(JspS ervletWrap per.java:3 77)
org.apache.jasper.servlet. JspServlet .serviceJs pFile(JspS ervlet.jav a:313)
org.apache.jasper.servlet. JspServlet .service(J spServlet. java:260)
javax.servlet.http.HttpSer vlet.servi ce(HttpSer vlet.java: 717)
org.netbeans.modules.web.m onitor.ser ver.Monito rFilter.do Filter(Mon itorFilter .java:393)
51: Category dbcategory=new Category();
52: ArrayList<Category> T=new ArrayList<Category>();
53: T= dbcategory.allCategories()
54: Iterator<Category> itr = T.iterator();
55: while(itr.hasNext())
56: {
57: dbcategory=itr.next();
Stacktrace:
org.apache.jasper.servlet.
org.apache.jasper.servlet.
org.apache.jasper.servlet.
org.apache.jasper.servlet.
javax.servlet.http.HttpSer
org.netbeans.modules.web.m
root cause
java.lang.NullPointerExcep
org.apache.jsp.category_js
org.apache.jasper.runtime.
javax.servlet.http.HttpSer
org.apache.jasper.servlet.
org.apache.jasper.servlet.
org.apache.jasper.servlet.
javax.servlet.http.HttpSer
org.netbeans.modules.web.m
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
My guess is there is more going on farther up in the stack trace. If you look in the allCategories method you will see the following lines:
I am guessing that one of those two exceptions are being thrown. Can you look farther up in your logs and see if there is another stacktrace being printed out before the null pointer. That will probably tell you which is happening.
catch (SQLException sqlException)
{
sqlException.printStackTrace();
return null;
}
catch (ClassNotFoundException classNotFound)
{
classNotFound.printStackTrace();
return null;
}
I am guessing that one of those two exceptions are being thrown. Can you look farther up in your logs and see if there is another stacktrace being printed out before the null pointer. That will probably tell you which is happening.
ASKER
This is what I get...
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperEx ception: An exception occurred processing JSP page /category.jsp at line 54
51: Category dbcategory=new Category();
52: ArrayList<Category> T=new ArrayList<Category>();
53: T= dbcategory.allCategories() ;
54: Iterator<Category> itr = T.iterator();
55: while(itr.hasNext())
56: {
57: dbcategory=itr.next();
Stacktrace:
org.apache.jasper.servlet. JspServlet Wrapper.ha ndleJspExc eption(Jsp ServletWra pper.java: 510)
org.apache.jasper.servlet. JspServlet Wrapper.se rvice(JspS ervletWrap per.java:4 19)
org.apache.jasper.servlet. JspServlet .serviceJs pFile(JspS ervlet.jav a:313)
org.apache.jasper.servlet. JspServlet .service(J spServlet. java:260)
javax.servlet.http.HttpSer vlet.servi ce(HttpSer vlet.java: 717)
org.netbeans.modules.web.m onitor.ser ver.Monito rFilter.do Filter(Mon itorFilter .java:393)
root cause
java.lang.NullPointerExcep tion
org.apache.jsp.category_js p._jspServ ice(catego ry_jsp.jav a:116)
org.apache.jasper.runtime. HttpJspBas e.service( HttpJspBas e.java:70)
javax.servlet.http.HttpSer vlet.servi ce(HttpSer vlet.java: 717)
org.apache.jasper.servlet. JspServlet Wrapper.se rvice(JspS ervletWrap per.java:3 77)
org.apache.jasper.servlet. JspServlet .serviceJs pFile(JspS ervlet.jav a:313)
org.apache.jasper.servlet. JspServlet .service(J spServlet. java:260)
javax.servlet.http.HttpSer vlet.servi ce(HttpSer vlet.java: 717)
org.netbeans.modules.web.m onitor.ser ver.Monito rFilter.do Filter(Mon itorFilter .java:393)
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.26 logs.
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperEx
51: Category dbcategory=new Category();
52: ArrayList<Category> T=new ArrayList<Category>();
53: T= dbcategory.allCategories()
54: Iterator<Category> itr = T.iterator();
55: while(itr.hasNext())
56: {
57: dbcategory=itr.next();
Stacktrace:
org.apache.jasper.servlet.
org.apache.jasper.servlet.
org.apache.jasper.servlet.
org.apache.jasper.servlet.
javax.servlet.http.HttpSer
org.netbeans.modules.web.m
root cause
java.lang.NullPointerExcep
org.apache.jsp.category_js
org.apache.jasper.runtime.
javax.servlet.http.HttpSer
org.apache.jasper.servlet.
org.apache.jasper.servlet.
org.apache.jasper.servlet.
javax.servlet.http.HttpSer
org.netbeans.modules.web.m
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.26 logs.
ASKER
sorry this one...
Apr 8, 2011 10:45:06 PM org.apache.catalina.startu p.HostConf ig deployDescriptor
INFO: Deploying configuration descriptor HoltDistributors.xml
java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
at com.mysql.jdbc.SQLError.cr eateSQLExc eption(SQL Error.java :1073)
at com.mysql.jdbc.MysqlIO.che ckErrorPac ket(MysqlI O.java:360 3)
at com.mysql.jdbc.MysqlIO.che ckErrorPac ket(MysqlI O.java:353 5)
at com.mysql.jdbc.MysqlIO.che ckErrorPac ket(MysqlI O.java:934 )
at com.mysql.jdbc.MysqlIO.sec ureAuth411 (MysqlIO.j ava:4104)
at com.mysql.jdbc.MysqlIO.doH andshake(M ysqlIO.jav a:1299)
at com.mysql.jdbc.ConnectionI mpl.coreCo nnect(Conn ectionImpl .java:2338 )
at com.mysql.jdbc.ConnectionI mpl.connec tOneTryOnl y(Connecti onImpl.jav a:2371)
at com.mysql.jdbc.ConnectionI mpl.create NewIO(Conn ectionImpl .java:2163 )
at com.mysql.jdbc.ConnectionI mpl.<init> (Connectio nImpl.java :794)
at com.mysql.jdbc.JDBC4Connec tion.<init >(JDBC4Con nection.ja va:47)
at sun.reflect.NativeConstruc torAccesso rImpl.newI nstance0(N ative Method)
at sun.reflect.NativeConstruc torAccesso rImpl.newI nstance(Na tiveConstr uctorAcces sorImpl.ja va:39)
at sun.reflect.DelegatingCons tructorAcc essorImpl. newInstanc e(Delegati ngConstruc torAccesso rImpl.java :27)
at java.lang.reflect.Construc tor.newIns tance(Cons tructor.ja va:513)
at com.mysql.jdbc.Util.handle NewInstanc e(Util.jav a:407)
at com.mysql.jdbc.ConnectionI mpl.getIns tance(Conn ectionImpl .java:378)
at com.mysql.jdbc.NonRegister ingDriver. connect(No nRegisteri ngDriver.j ava:305)
at java.sql.DriverManager.get Connection (DriverMan ager.java: 582)
at java.sql.DriverManager.get Connection (DriverMan ager.java: 185)
at inventory.Category.allCate gories(Cat egory.java :246)
at org.apache.jsp.category_js p._jspServ ice(catego ry_jsp.jav a:115)
at org.apache.jasper.runtime. HttpJspBas e.service( HttpJspBas e.java:70)
at javax.servlet.http.HttpSer vlet.servi ce(HttpSer vlet.java: 717)
at org.apache.jasper.servlet. JspServlet Wrapper.se rvice(JspS ervletWrap per.java:3 77)
at org.apache.jasper.servlet. JspServlet .serviceJs pFile(JspS ervlet.jav a:313)
at org.apache.jasper.servlet. JspServlet .service(J spServlet. java:260)
at javax.servlet.http.HttpSer vlet.servi ce(HttpSer vlet.java: 717)
at org.apache.catalina.core.A pplication FilterChai n.internal DoFilter(A pplication FilterChai n.java:290 )
at org.apache.catalina.core.A pplication FilterChai n.doFilter (Applicati onFilterCh ain.java:2 06)
at org.netbeans.modules.web.m onitor.ser ver.Monito rFilter.do Filter(Mon itorFilter .java:393)
at org.apache.catalina.core.A pplication FilterChai n.internal DoFilter(A pplication FilterChai n.java:235 )
at org.apache.catalina.core.A pplication FilterChai n.doFilter (Applicati onFilterCh ain.java:2 06)
at org.apache.catalina.core.S tandardWra pperValve. invoke(Sta ndardWrapp erValve.ja va:233)
at org.apache.catalina.core.S tandardCon textValve. invoke(Sta ndardConte xtValve.ja va:191)
at org.apache.catalina.core.S tandardHos tValve.inv oke(Standa rdHostValv e.java:127 )
at org.apache.catalina.valves .ErrorRepo rtValve.in voke(Error ReportValv e.java:102 )
at org.apache.catalina.core.S tandardEng ineValve.i nvoke(Stan dardEngine Valve.java :109)
at org.apache.catalina.connec tor.Coyote Adapter.se rvice(Coyo teAdapter. java:298)
at org.apache.coyote.http11.H ttp11AprPr ocessor.pr ocess(Http 11AprProce ssor.java: 859)
at org.apache.coyote.http11.H ttp11AprPr otocol$Htt p11Connect ionHandler .process(H ttp11AprPr otocol.jav a:579)
at org.apache.tomcat.util.net .AprEndpoi nt$Worker. run(AprEnd point.java :1555)
at java.lang.Thread.run(Threa d.java:662 )
java.lang.NullPointerExcep tion
at inventory.Category.allCate gories(Cat egory.java :279)
at org.apache.jsp.category_js p._jspServ ice(catego ry_jsp.jav a:115)
at org.apache.jasper.runtime. HttpJspBas e.service( HttpJspBas e.java:70)
at javax.servlet.http.HttpSer vlet.servi ce(HttpSer vlet.java: 717)
at org.apache.jasper.servlet. JspServlet Wrapper.se rvice(JspS ervletWrap per.java:3 77)
at org.apache.jasper.servlet. JspServlet .serviceJs pFile(JspS ervlet.jav a:313)
at org.apache.jasper.servlet. JspServlet .service(J spServlet. java:260)
at javax.servlet.http.HttpSer vlet.servi ce(HttpSer vlet.java: 717)
at org.apache.catalina.core.A pplication FilterChai n.internal DoFilter(A pplication FilterChai n.java:290 )
at org.apache.catalina.core.A pplication FilterChai n.doFilter (Applicati onFilterCh ain.java:2 06)
at org.netbeans.modules.web.m onitor.ser ver.Monito rFilter.do Filter(Mon itorFilter .java:393)
at org.apache.catalina.core.A pplication FilterChai n.internal DoFilter(A pplication FilterChai n.java:235 )
at org.apache.catalina.core.A pplication FilterChai n.doFilter (Applicati onFilterCh ain.java:2 06)
at org.apache.catalina.core.S tandardWra pperValve. invoke(Sta ndardWrapp erValve.ja va:233)
at org.apache.catalina.core.S tandardCon textValve. invoke(Sta ndardConte xtValve.ja va:191)
at org.apache.catalina.core.S tandardHos tValve.inv oke(Standa rdHostValv e.java:127 )
at org.apache.catalina.valves .ErrorRepo rtValve.in voke(Error ReportValv e.java:102 )
at org.apache.catalina.core.S tandardEng ineValve.i nvoke(Stan dardEngine Valve.java :109)
at org.apache.catalina.connec tor.Coyote Adapter.se rvice(Coyo teAdapter. java:298)
at org.apache.coyote.http11.H ttp11AprPr ocessor.pr ocess(Http 11AprProce ssor.java: 859)
at org.apache.coyote.http11.H ttp11AprPr otocol$Htt p11Connect ionHandler .process(H ttp11AprPr otocol.jav a:579)
at org.apache.tomcat.util.net .AprEndpoi nt$Worker. run(AprEnd point.java :1555)
at java.lang.Thread.run(Threa d.java:662 )
Apr 8, 2011 10:45:06 PM org.apache.catalina.startu
INFO: Deploying configuration descriptor HoltDistributors.xml
java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
at com.mysql.jdbc.SQLError.cr
at com.mysql.jdbc.MysqlIO.che
at com.mysql.jdbc.MysqlIO.che
at com.mysql.jdbc.MysqlIO.che
at com.mysql.jdbc.MysqlIO.sec
at com.mysql.jdbc.MysqlIO.doH
at com.mysql.jdbc.ConnectionI
at com.mysql.jdbc.ConnectionI
at com.mysql.jdbc.ConnectionI
at com.mysql.jdbc.ConnectionI
at com.mysql.jdbc.JDBC4Connec
at sun.reflect.NativeConstruc
at sun.reflect.NativeConstruc
at sun.reflect.DelegatingCons
at java.lang.reflect.Construc
at com.mysql.jdbc.Util.handle
at com.mysql.jdbc.ConnectionI
at com.mysql.jdbc.NonRegister
at java.sql.DriverManager.get
at java.sql.DriverManager.get
at inventory.Category.allCate
at org.apache.jsp.category_js
at org.apache.jasper.runtime.
at javax.servlet.http.HttpSer
at org.apache.jasper.servlet.
at org.apache.jasper.servlet.
at org.apache.jasper.servlet.
at javax.servlet.http.HttpSer
at org.apache.catalina.core.A
at org.apache.catalina.core.A
at org.netbeans.modules.web.m
at org.apache.catalina.core.A
at org.apache.catalina.core.A
at org.apache.catalina.core.S
at org.apache.catalina.core.S
at org.apache.catalina.core.S
at org.apache.catalina.valves
at org.apache.catalina.core.S
at org.apache.catalina.connec
at org.apache.coyote.http11.H
at org.apache.coyote.http11.H
at org.apache.tomcat.util.net
at java.lang.Thread.run(Threa
java.lang.NullPointerExcep
at inventory.Category.allCate
at org.apache.jsp.category_js
at org.apache.jasper.runtime.
at javax.servlet.http.HttpSer
at org.apache.jasper.servlet.
at org.apache.jasper.servlet.
at org.apache.jasper.servlet.
at javax.servlet.http.HttpSer
at org.apache.catalina.core.A
at org.apache.catalina.core.A
at org.netbeans.modules.web.m
at org.apache.catalina.core.A
at org.apache.catalina.core.A
at org.apache.catalina.core.S
at org.apache.catalina.core.S
at org.apache.catalina.core.S
at org.apache.catalina.valves
at org.apache.catalina.core.S
at org.apache.catalina.connec
at org.apache.coyote.http11.H
at org.apache.coyote.http11.H
at org.apache.tomcat.util.net
at java.lang.Thread.run(Threa
So looking at that it definitly looks like you are having some database connection issues. Access denied for user 'root'@'localhost' (using password: YES). Is that the right password for your database. I would start looking at that. There are many passwords in that code you sent, I would guess that the password is not right or something on those lines.
ASKER
My password is right. Is there anything i need to put in the CLASSPATH?
It really just seems like you can't connect to your database from webserver. There could be several possibilities. Take a look at this article. I think it could help you .
http://dev.mysql.com/doc/refman/5.1/en/access-denied.html
http://dev.mysql.com/doc/refman/5.1/en/access-denied.html
ASKER
Category.java