Method public java.util.Vector ro.ups.magazin.cache.Filters2.getAllProducts(int,int,int) threw an exception when invoked on 0:pr_lei=(null/0) 5:90862=(Tompa Gabor/0) 6:pr_disponibilitate=(In stoc/0) 6:pr_producator=(Cartea Romaneasca/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 d1 on p.pr_id = d1.pr_id where p.pr_enabled = 1 and p.pr_tipprodus >= 10000 and ( p.pr_lei>=30 and p.pr_lei<=50) and ( (d1.spec_id = 90862 and d1.spec_text = 'Tompa Gabor') ) and ( p.pr_disponibilitate='In stoc') and ( p.pr_producator='Cartea Romaneasca') and cp.cat_par_id = 41300) as x order by data_creere 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 0:pr_lei=(null/0) 5:90862=(Tompa Gabor/0) 6:pr_disponibilitate=(In stoc/0) 6:pr_producator=(Cartea Romaneasca/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 d1 on p.pr_id = d1.pr_id where p.pr_enabled = 1 and p.pr_tipprodus >= 10000 and ( p.pr_lei>=30 and p.pr_lei<=50) and ( (d1.spec_id = 90862 and d1.spec_text = 'Tompa Gabor') ) and ( p.pr_disponibilitate='In stoc') and ( p.pr_producator='Cartea Romaneasca') and cp.cat_par_id = 41300) as x order by data_creere 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(Unknown Source)
at ro.ups.magazin.mall.MallMagazin.processWriter(Unknown Source)
at ro.ups.magazin.mall.MallMagazin.process(Unknown Source)
at ro.ups.pages.CategorieCentru_jsp._jspService(Unknown Source)
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(Unknown Source)
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(Unknown Source)
at ro.ups.magazin.filter.SEOFilter.doFilter(Unknown Source)
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(Unknown Source)
at sun.reflect.GeneratedMethodAccessor137.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 0:pr_lei=(null/0) 5:90862=(Tompa Gabor/0) 6:pr_disponibilitate=(In stoc/0) 6:pr_producator=(Cartea Romaneasca/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 d1 on p.pr_id = d1.pr_id where p.pr_enabled = 1 and p.pr_tipprodus >= 10000 and ( p.pr_lei>=30 and p.pr_lei<=50) and ( (d1.spec_id = 90862 and d1.spec_text = 'Tompa Gabor') ) and ( p.pr_disponibilitate='In stoc') and ( p.pr_producator='Cartea Romaneasca') and cp.cat_par_id = 41300) as x order by data_creere desc]
