Erro em listagem c/ Hibernate e DisplayTag

Assuntos Gerais
#1

bom dia a todos…

  • usando hql do hibernate para uma pesquisa entre 2 datas e vizualizando esta num displayTag - uso tbem vraptor- sem especificar quais campos da tabela, ou melhor, visualizando tudo nao gera erro…
  • agora, quando especifico no hql - pesquisa - os campos q quero q mostre no displayTag gera este erro:
java.lang.NumberFormatException: For input string: "id"
	java.lang.NumberFormatException.forInputString(Unknown Source)
	java.lang.Integer.parseInt(Unknown Source)
	java.lang.Integer.parseInt(Unknown Source)
	javax.el.ArrayELResolver.coerce(ArrayELResolver.java:153)
	javax.el.ArrayELResolver.getValue(ArrayELResolver.java:45)
	javax.el.CompositeELResolver.getValue(CompositeELResolver.java:53)
	org.apache.el.parser.AstValue.getValue(AstValue.java:97)
	org.apache.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:186)
	org.apache.jasper.runtime.PageContextImpl.proprietaryEvaluate(PageContextImpl.java:923)
	org.apache.jsp.documento.listaPesquisa_ok_jsp._jspx_meth_display_005fcolumn_005f2(listaPesquisa_ok_jsp.java:231)
	org.apache.jsp.documento.listaPesquisa_ok_jsp._jspService(listaPesquisa_ok_jsp.java:131)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
	org.vraptor.view.RegexViewManager.directForward(RegexViewManager.java:70)
	org.vraptor.view.RegexViewManager.forward(RegexViewManager.java:64)
	org.vraptor.view.OverridableViewManager.forward(OverridableViewManager.java:66)
	org.vraptor.view.RemoteViewManager.forward(RemoteViewManager.java:74)
	org.vraptor.interceptor.ViewInterceptor.intercept(ViewInterceptor.java:36)
	org.vraptor.core.InterceptorsLogicFlow.execute(InterceptorsLogicFlow.java:72)
	org.vraptor.interceptor.OutjectionInterceptor.intercept(OutjectionInterceptor.java:36)
	org.vraptor.core.InterceptorsLogicFlow.execute(InterceptorsLogicFlow.java:72)
	org.vraptor.interceptor.ExecuteLogicInterceptor.intercept(ExecuteLogicInterceptor.java:43)
	org.vraptor.core.InterceptorsLogicFlow.execute(InterceptorsLogicFlow.java:72)
	org.vraptor.interceptor.SettingAndValidationInterceptor.intercept(SettingAndValidationInterceptor.java:131)
	org.vraptor.core.InterceptorsLogicFlow.execute(InterceptorsLogicFlow.java:72)
	org.vraptor.interceptor.InjectionInterceptor.intercept(InjectionInterceptor.java:41)
	org.vraptor.core.InterceptorsLogicFlow.execute(InterceptorsLogicFlow.java:72)
	org.vraptor.interceptor.ComponentLookupInterceptor.intercept(ComponentLookupInterceptor.java:58)
	org.vraptor.core.InterceptorsLogicFlow.execute(InterceptorsLogicFlow.java:72)
	br.com.ricardo.lojavirtual.logic.DaoInterceptor.intercept(DaoInterceptor.java:24)
	org.vraptor.core.InterceptorsLogicFlow.execute(InterceptorsLogicFlow.java:72)
	org.vraptor.interceptor.RegisterAttributesInteceptor.intercept(RegisterAttributesInteceptor.java:38)
	org.vraptor.core.InterceptorsLogicFlow.execute(InterceptorsLogicFlow.java:72)
	org.vraptor.core.VRaptorExecution.execute(VRaptorExecution.java:88)
	org.vraptor.core.DefaultController.execute(DefaultController.java:42)
	org.vraptor.VRaptorServlet.service(VRaptorServlet.java:70)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
	org.vraptor.view.RegexViewManager.directForward(RegexViewManager.java:70)
	org.vraptor.view.OverridableViewManager.forward(OverridableViewManager.java:63)
	org.vraptor.view.RemoteViewManager.forward(RemoteViewManager.java:74)
	org.vraptor.interceptor.ViewInterceptor.intercept(ViewInterceptor.java:36)
	org.vraptor.core.InterceptorsLogicFlow.execute(InterceptorsLogicFlow.java:72)
	org.vraptor.interceptor.OutjectionInterceptor.intercept(OutjectionInterceptor.java:36)
	org.vraptor.core.InterceptorsLogicFlow.execute(InterceptorsLogicFlow.java:72)
	org.vraptor.interceptor.ExecuteLogicInterceptor.intercept(ExecuteLogicInterceptor.java:43)
	org.vraptor.core.InterceptorsLogicFlow.execute(InterceptorsLogicFlow.java:72)
	org.vraptor.interceptor.SettingAndValidationInterceptor.intercept(SettingAndValidationInterceptor.java:131)
	org.vraptor.core.InterceptorsLogicFlow.execute(InterceptorsLogicFlow.java:72)
	org.vraptor.interceptor.InjectionInterceptor.intercept(InjectionInterceptor.java:41)
	org.vraptor.core.InterceptorsLogicFlow.execute(InterceptorsLogicFlow.java:72)
	org.vraptor.interceptor.ComponentLookupInterceptor.intercept(ComponentLookupInterceptor.java:58)
	org.vraptor.core.InterceptorsLogicFlow.execute(InterceptorsLogicFlow.java:72)
	br.com.ricardo.lojavirtual.logic.DaoInterceptor.intercept(DaoInterceptor.java:24)
	org.vraptor.core.InterceptorsLogicFlow.execute(InterceptorsLogicFlow.java:72)
	org.vraptor.interceptor.RegisterAttributesInteceptor.intercept(RegisterAttributesInteceptor.java:38)
	org.vraptor.core.InterceptorsLogicFlow.execute(InterceptorsLogicFlow.java:72)
	org.vraptor.core.VRaptorExecution.execute(VRaptorExecution.java:88)
	org.vraptor.core.DefaultController.execute(DefaultController.java:42)
	org.vraptor.VRaptorServlet.service(VRaptorServlet.java:70)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
  • nao sei se o meu hql q ta errado ou na vizualização com o displayTag…
  • to selecionado 2 campos apenas…o da data de pesquisa e o ano do docto
    HQL:

hql = "select doc.ano_docto, doc.data_ent " + "from Documento as doc where doc.data_ent between :dataInicial and :dataFinal";

  • visualização com display:
 ..........                   
<h1><center>Documentos</center></h1>
<display:table id="documento" name="${docDatas}" requestURI="documento.listaData.logic">

<display:column property="ano_docto" sortable="true" />
<display:column property="data_ent" sortable="true" />

<display:column>
<a >editar</a>
&lt;/display:column&gt;
..........

valeu

#2