Method public java.util.Vector ro.ups.magazin.cache.Filters2.getAllProducts(int,int,int) threw an exception when invoked on 5:91339=(Folia/0) 6:pr_producator=(Der Color/0) select pr_id from (select distinct p.* from produse p join produsecateg pc on p.pr_id = pc.pr_id join categoriiparinte cp on cp.cat_id = pc.cat_id join detalii d0 on p.pr_id = d0.pr_id where p.pr_enabled = 1 and p.pr_tipprodus >= 10000 and ( (d0.spec_id = 91339 and d0.spec_text = 'Folia') ) and ( p.pr_producator='Der Color') and cp.cat_par_id = 44064) as x order by pr_importanta desc, pr_id desc
The problematic instruction:
----------
==> assignment: allProds=filtr.getAllProducts(pgn,(page-1)*pgn,3600)?default([]) [on line 8, column 1 in categorieCentru.ftl]
----------
Java backtrace for programmers:
----------
freemarker.template.TemplateModelException: Method public java.util.Vector ro.ups.magazin.cache.Filters2.getAllProducts(int,int,int) threw an exception when invoked on 5:91339=(Folia/0) 6:pr_producator=(Der Color/0) select pr_id from (select distinct p.* from produse p join produsecateg pc on p.pr_id = pc.pr_id join categoriiparinte cp on cp.cat_id = pc.cat_id join detalii d0 on p.pr_id = d0.pr_id where p.pr_enabled = 1 and p.pr_tipprodus >= 10000 and ( (d0.spec_id = 91339 and d0.spec_text = 'Folia') ) and ( p.pr_producator='Der Color') and cp.cat_par_id = 44064) as x order by pr_importanta desc, pr_id desc
at freemarker.ext.beans.OverloadedMethodModel.exec(OverloadedMethodModel.java:134)
at freemarker.core.MethodCall._getAsTemplateModel(MethodCall.java:93)
at freemarker.core.Expression.getAsTemplateModel(Expression.java:89)
at freemarker.core.BuiltIn$defaultBI._getAsTemplateModel(BuiltIn.java:832)
at freemarker.core.Expression.getAsTemplateModel(Expression.java:89)
at freemarker.core.MethodCall._getAsTemplateModel(MethodCall.java:86)
at freemarker.core.Expression.getAsTemplateModel(Expression.java:89)
at freemarker.core.Assignment.accept(Assignment.java:90)
at freemarker.core.Environment.visit(Environment.java:196)
at freemarker.core.MixedContent.accept(MixedContent.java:92)
at freemarker.core.Environment.visit(Environment.java:196)
at freemarker.core.Environment.process(Environment.java:176)
at freemarker.template.Template.process(Template.java:231)
at ro.ups.magazin.mall.MallMagazin.processWriter(MallMagazin.java:2294)
at ro.ups.magazin.mall.MallMagazin.processWriter(MallMagazin.java:2260)
at ro.ups.magazin.mall.MallMagazin.process(MallMagazin.java:2224)
at ro.ups.pages.CategorieCentru_jsp._jspService(CategorieCentru_jsp.java:266)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:427)
at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:475)
at org.mortbay.jetty.servlet.Dispatcher.dispatch(Dispatcher.java:275)
at org.mortbay.jetty.servlet.Dispatcher.include(Dispatcher.java:161)
at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:966)
at ro.ups.pages.ProduseCategorii_jsp._jspService(ProduseCategorii_jsp.java:596)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:427)
at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:475)
at org.mortbay.jetty.servlet.Dispatcher.dispatch(Dispatcher.java:275)
at org.mortbay.jetty.servlet.Dispatcher.forward(Dispatcher.java:169)
at ro.ups.magazin.filter.SEOFilter4.doSEOFilter(SEOFilter4.java:338)
at ro.ups.magazin.filter.SEOFilter.doFilter(SEOFilter.java:215)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:823)
at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:473)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:567)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1565)
at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:635)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1517)
at org.mortbay.http.HttpServer.service(HttpServer.java:954)
at org.mortbay.http.HttpConnection.service(HttpConnection.java:814)
at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:981)
at org.mortbay.http.HttpConnection.handle(HttpConnection.java:831)
at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244)
at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357)
at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)
Caused by: java.lang.NullPointerException
at ro.ups.magazin.cache.Filters2.getAllProducts(Filters2.java:159)
at sun.reflect.GeneratedMethodAccessor143.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at freemarker.ext.beans.BeansWrapper.invokeMethod(BeansWrapper.java:583)
at freemarker.ext.beans.OverloadedMethodModel.exec(OverloadedMethodModel.java:111)
... 45 more
[EXCEPTIE:Method public java.util.Vector ro.ups.magazin.cache.Filters2.getAllProducts(int,int,int) threw an exception when invoked on 5:91339=(Folia/0) 6:pr_producator=(Der Color/0) select pr_id from (select distinct p.* from produse p join produsecateg pc on p.pr_id = pc.pr_id join categoriiparinte cp on cp.cat_id = pc.cat_id join detalii d0 on p.pr_id = d0.pr_id where p.pr_enabled = 1 and p.pr_tipprodus >= 10000 and ( (d0.spec_id = 91339 and d0.spec_text = 'Folia') ) and ( p.pr_producator='Der Color') and cp.cat_par_id = 44064) as x order by pr_importanta desc, pr_id desc]
