Olá!
Temos uma página que faz uma consulta num banco DB2, através de parametros
estado, cidade, bairro, segmento, subsegmento, categoria e um like para
nome e endereço, essa página nos retorna os anunciantes cadastrados em
determinado período, algo bem simples.
Mas se fizer a mesma consulta apenas mudando o like de "ABCD" para "ABC"
ocorre um erro aparentemente de compilação(não tenho experïência em JSP),
fiz a mesma consulta no client do banco e tudo ocorre normalmente para as
duas consultas, a ABCD não retorna nada(não dá erro) e a ABC retorna um
linha(dá erro), outros tipos de filtro retornam n linhas e não dão erro.
Fiz um teste atribuindo uma consulta completamente "nada a ver" ao
statement antes de executar a query, e nesse caso o erro que ocorre é
capturado, pois é um erro em tempo de execução. Estou confuso com isso.
Segue abaixo o erro de compilação ( O que posso fazer?):
Error 500
Ocorreu um erro ao processar o pedido:
Mensagem: Server caught unhandled exception from servlet [Processador de
JSP 1.0]: Server caught unhandled exception from JSP [Consulta.jsp]
Servlet de Destino: Processador de JSP 1.0
Rastreio da Pilha:
---------------------------------------------------------------------------
-----
Erro na Raiz-1: null
java.lang.NullPointerException
at
opt.IBMWebAS.hosts.d_00025fault_0005fhost.shoptour.web.v_00032p._v2p_2F_Con
sulta_2E_jsp_jsp_48._jspService(_v2p_2F_Consulta_2E_jsp_jsp_48.java:226)
at
com.sun.jsp.runtime.HttpJspBase.service(HttpJspBase.java(Compiled Code))
at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled
Code))
at
com.sun.jsp.runtime.JspServlet$JspServletWrapper.service(JspServlet.java(Co
mpiled Code))
at
com.sun.jsp.runtime.JspServlet.serviceJspFile(JspServlet.java(Compiled
Code))
at com.sun.jsp.runtime.JspServlet.service(JspServlet.java(Compiled
Code))
at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled
Code))
at
com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletManage
r.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLifecyc
leServlet.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.IdleServletState.service(StrictLifecycleServl
et.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifecycl
eServlet.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.java(C
ompiled Code))
at
com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(ServletMa
nager.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletMana
ger.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch(
WebAppRequestDispatcher.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppReques
tDispatcher.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequest
Dispatcher.java(Compiled Code))
at
com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker
.java(Compiled Code))
at
com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(CachedI
nvocation.java(Compiled Code))
at
com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletReq
uestProcessor.java(Compiled Code))
at
com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletReq
uestProcessor.java(Compiled Code))
at
com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEListene
r.java(Compiled Code))
at
com.ibm.servlet.engine.oselistener.SQEventListenerImp$ServiceRunnable.run(S
QEventListenerImp.java(Compiled Code))
at
com.ibm.servlet.engine.oselistener.SQEventListenerImp.notifySQEvent(SQEvent
ListenerImp.java(Compiled Code))
at
com.ibm.servlet.engine.oselistener.serverqueue.SQEventSource.notifyEvent(SQ
EventSource.java(Compiled Code))
at
com.ibm.servlet.engine.oselistener.serverqueue.SQWrapperEventSource$SelectR
unnable.notifyService(SQWrapperEventSource.java(Compiled Code))
at
com.ibm.servlet.engine.oselistener.serverqueue.SQWrapperEventSource$SelectR
unnable.run(SQWrapperEventSource.java:220)
at
com.ibm.servlet.engine.oselistener.outofproc.OutOfProcThread$CtlRunnable.ru
n(OutOfProcThread.java:248)
at java.lang.Thread.run(Thread.java:481)
---------------------------------------------------------------------------
-----
Erro de Empacotamento-2: Server caught unhandled exception from JSP
[Consulta.jsp]
com.sun.jsp.JspWithNoErrorPageException: Server caught unhandled exception
from JSP [Consulta.jsp]
at javax.servlet.ServletException.<init>(ServletException.java:132)
at
com.ibm.websphere.servlet.error.ServletErrorReport.<init>(ServletErrorRepor
t.java:43)
at
com.ibm.servlet.engine.webapp.WebAppErrorReport.<init>(WebAppErrorReport.ja
va:32)
at
com.sun.jsp.JspWithNoErrorPageException.<init>(JspWithNoErrorPageException.
java:26)
at
opt.IBMWebAS.hosts.d_00025fault_0005fhost.shoptour.web.v_00032p._v2p_2F_Con
sulta_2E_jsp_jsp_48._jspService(_v2p_2F_Consulta_2E_jsp_jsp_48.java:275)
at
com.sun.jsp.runtime.HttpJspBase.service(HttpJspBase.java(Compiled Code))
at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled
Code))
at
com.sun.jsp.runtime.JspServlet$JspServletWrapper.service(JspServlet.java(Co
mpiled Code))
at
com.sun.jsp.runtime.JspServlet.serviceJspFile(JspServlet.java(Compiled
Code))
at com.sun.jsp.runtime.JspServlet.service(JspServlet.java(Compiled
Code))
at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled
Code))
at
com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletManage
r.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLifecyc
leServlet.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.IdleServletState.service(StrictLifecycleServl
et.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifecycl
eServlet.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.java(C
ompiled Code))
at
com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(ServletMa
nager.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletMana
ger.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch(
WebAppRequestDispatcher.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppReques
tDispatcher.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequest
Dispatcher.java(Compiled Code))
at
com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker
.java(Compiled Code))
at
com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(CachedI
nvocation.java(Compiled Code))
at
com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletReq
uestProcessor.java(Compiled Code))
at
com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletReq
uestProcessor.java(Compiled Code))
at
com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEListene
r.java(Compiled Code))
at
com.ibm.servlet.engine.oselistener.SQEventListenerImp$ServiceRunnable.run(S
QEventListenerImp.java(Compiled Code))
at
com.ibm.servlet.engine.oselistener.SQEventListenerImp.notifySQEvent(SQEvent
ListenerImp.java(Compiled Code))
at
com.ibm.servlet.engine.oselistener.serverqueue.SQEventSource.notifyEvent(SQ
EventSource.java(Compiled Code))
at
com.ibm.servlet.engine.oselistener.serverqueue.SQWrapperEventSource$SelectR
unnable.notifyService(SQWrapperEventSource.java(Compiled Code))
at
com.ibm.servlet.engine.oselistener.serverqueue.SQWrapperEventSource$SelectR
unnable.run(SQWrapperEventSource.java:220)
at
com.ibm.servlet.engine.oselistener.outofproc.OutOfProcThread$CtlRunnable.ru
n(OutOfProcThread.java:248)
at java.lang.Thread.run(Thread.java:481)
---------------------------------------------------------------------------
-----
Erro de Empacotamento-3: Server caught unhandled exception from servlet
[Processador de JSP 1.0]: Server caught unhandled exception from JSP
[Consulta.jsp]
com.ibm.servlet.engine.webapp.UncaughtServletException: Server caught
unhandled exception from servlet [Processador de JSP 1.0]: Server caught
unhandled exception from JSP [Consulta.jsp]
at javax.servlet.ServletException.<init>(ServletException.java:132)
at
com.ibm.websphere.servlet.error.ServletErrorReport.<init>(ServletErrorRepor
t.java:43)
at
com.ibm.servlet.engine.webapp.WebAppErrorReport.<init>(WebAppErrorReport.ja
va:32)
at
com.ibm.servlet.engine.webapp.UncaughtServletException.<init>(UncaughtServl
etException.java:11)
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch(
WebAppRequestDispatcher.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppReques
tDispatcher.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequest
Dispatcher.java(Compiled Code))
at
com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker
.java(Compiled Code))
at
com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(CachedI
nvocation.java(Compiled Code))
at
com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletReq
uestProcessor.java(Compiled Code))
at
com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletReq
uestProcessor.java(Compiled Code))
at
com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEListene
r.java(Compiled Code))
at
com.ibm.servlet.engine.oselistener.SQEventListenerImp$ServiceRunnable.run(S
QEventListenerImp.java(Compiled Code))
at
com.ibm.servlet.engine.oselistener.SQEventListenerImp.notifySQEvent(SQEvent
ListenerImp.java(Compiled Code))
at
com.ibm.servlet.engine.oselistener.serverqueue.SQEventSource.notifyEvent(SQ
EventSource.java(Compiled Code))
at
com.ibm.servlet.engine.oselistener.serverqueue.SQWrapperEventSource$SelectR
unnable.notifyService(SQWrapperEventSource.java(Compiled Code))
at
com.ibm.servlet.engine.oselistener.serverqueue.SQWrapperEventSource$SelectR
unnable.run(SQWrapperEventSource.java:220)
at
com.ibm.servlet.engine.oselistener.outofproc.OutOfProcThread$CtlRunnable.ru
n(OutOfProcThread.java:248)
at java.lang.Thread.run(Thread.java:481)
Abraços
--
Jean Fábio Barros
www.compsis.com.br
Fone (44) 227-7202
ICQ 6497287
10Mb na sua caixa de email gratuita no mail.pt
http://www.mail.pt
------------------------------ LISTA SOUJAVA ----------------------------
http://www.soujava.org.br - Sociedade de Usuários Java da Sucesu-SP
dúvidas mais comuns: http://www.soujava.org.br/faq.htm
regras da lista: http://www.soujava.org.br/regras.htm
historico: http://www.mail-archive.com/java-list%40soujava.org.br
para sair da lista: envie email para [EMAIL PROTECTED]
-------------------------------------------------------------------------
