Bom dia!
Estou tentando fazer uma busca por HQL que agrupa e soma.
DAO:
[code]
public List listaPendencias(){
Query q = getSession().createQuery("SELECT T.diretoria, Sum(T.levantamentos), Sum(T.vlrLevantamentos), Sum(T.efetivacoes), Sum(T.vlrEfetivacoes), " +
" Sum(T.solicitLevantamentos), Sum(T.vlrSolicitLevantamentos), Sum(T.solicitEfetivacoes), Sum(T.vlrSolicitEfetivacoes), " +
" FROM TodasPendenciasPdj T " +
" GROUP BY T.diretoria ");
return q.list();
}[/code]
bean:
TodasPendenciasDAO tdpDao = new TodasPendenciasDAO ();
listaTodasPendencias = tdpDao .listaPendencias();[/code]
classe:
[code]
@Id
@GeneratedValue(strategy=GenerationType.AUTO)
@Column (name="ID")
private Long id;
@Column (name="LEVANTAMENTOS")
private Long levantamentos;
@Column (name="VLR_LEVANTAMENTOS")
private BigDecimal vlrLevantamentos;
@Column (name="EFETIVACOES")
private Long efetivacoes;
@Column (name="VLR_EFETIVACOES")
private BigDecimal vlrEfetivacoes;
@Column (name="SOLICIT_LEVANTAMENTOS")
private Long solicitLevantamentos;
@Column (name="VLR_SOLICIT_LEVANTAMENTOS")
private BigDecimal vlrSolicitLevantamentos;
@Column (name="SOLICIT_EFETIVACOES")
private Long solicitEfetivacoes;
@Column (name="VLR_SOLICIT_EFETIVACOES")
private BigDecimal vlrSolicitEfetivacoes;
@Column (name="DEPENDENCIA")
private Integer dependencia;
@Column (name="NOME", nullable=true, length=25)
private String nome;
@Column (name="PREF_SUPER_RESPONSAVEL")
private Integer prefSuperResponsavel;
@Column (name="NOME_SUPER_RESPONSAVEL", nullable=true, length=25)
private String nomeSuperResponsavel;
@Column (name="DIRETORIA")
private Integer diretoria;
@Column(name="DATA", nullable=true)
@Temporal(TemporalType.TIMESTAMP)
private Date data;
[/code]
xhtml:
[code]
<p:dataTable var="relatorio" value="#{acompanhamentosBean.listaTodasPendencias}" paginator="true" rows="50"
emptyMessage="Nenhuma pendência encontrada." id="tbl">
<p:column headerText="Diretoria" style="padding: 2px">
<h:outputText value="#{relatorio.diretoria}" />
</p:column>
</p:dataTable>
[/code]
erro:
[code]Grave: Error Rendering View[/totalPendenciasPdj.xhtml]
java.lang.NumberFormatException: For input string: "diretoria"
at java.lang.NumberFormatException.forInputString(Unknown Source)
at java.lang.Integer.parseInt(Unknown Source)
at java.lang.Integer.parseInt(Unknown Source)
at javax.el.ArrayELResolver.coerce(ArrayELResolver.java:166)
at javax.el.ArrayELResolver.getValue(ArrayELResolver.java:46)
at com.sun.faces.el.DemuxCompositeELResolver._getValue(DemuxCompositeELResolver.java:176)
at com.sun.faces.el.DemuxCompositeELResolver.getValue(DemuxCompositeELResolver.java:203)
at org.apache.el.parser.AstValue.getValue(AstValue.java:169)
at org.apache.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:189)
at com.sun.faces.facelets.el.TagValueExpression.getValue(TagValueExpression.java:109)
at javax.faces.component.ComponentStateHelper.eval(ComponentStateHelper.java:193)
at javax.faces.component.ComponentStateHelper.eval(ComponentStateHelper.java:181)
at javax.faces.component.UIOutput.getValue(UIOutput.java:169)
at com.sun.faces.renderkit.html_basic.HtmlBasicInputRenderer.getValue(HtmlBasicInputRenderer.java:205)
at com.sun.faces.renderkit.html_basic.HtmlBasicRenderer.getCurrentValue(HtmlBasicRenderer.java:355)
at com.sun.faces.renderkit.html_basic.HtmlBasicRenderer.encodeEnd(HtmlBasicRenderer.java:164)
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:883)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1659)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1655)
at org.primefaces.component.datatable.DataTableRenderer.encodeRegularCell(DataTableRenderer.java:571)
at org.primefaces.component.datatable.DataTableRenderer.encodeRow(DataTableRenderer.java:531)
at org.primefaces.component.datatable.DataTableRenderer.encodeTbody(DataTableRenderer.java:472)
at org.primefaces.component.datatable.DataTableRenderer.encodeRegularTable(DataTableRenderer.java:201)
at org.primefaces.component.datatable.DataTableRenderer.encodeMarkup(DataTableRenderer.java:180)
at org.primefaces.component.datatable.DataTableRenderer.encodeEnd(DataTableRenderer.java:85)
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:883)
at org.primefaces.renderkit.CoreRenderer.renderChild(CoreRenderer.java:59)
at org.primefaces.renderkit.CoreRenderer.renderChildren(CoreRenderer.java:43)
at org.primefaces.component.panel.PanelRenderer.encodeContent(PanelRenderer.java:229)
at org.primefaces.component.panel.PanelRenderer.encodeMarkup(PanelRenderer.java:152)
at org.primefaces.component.panel.PanelRenderer.encodeEnd(PanelRenderer.java:75)
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:883)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1659)
at javax.faces.render.Renderer.encodeChildren(Renderer.java:168)
at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:853)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1652)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1655)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1655)
at com.sun.faces.application.view.FaceletViewHandlingStrategy.renderView(FaceletViewHandlingStrategy.java:399)
at com.sun.faces.application.view.MultiViewHandler.renderView(MultiViewHandler.java:131)
at com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:121)
at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)
at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:139)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:313)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.primefaces.webapp.filter.FileUploadFilter.doFilter(FileUploadFilter.java:79)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at br.com.bb.gefin.filtro.HibernateSessionRequestFilter.doFilter(HibernateSessionRequestFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:928)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:987)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:539)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:298)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)