[Resolvido]Error reading 'viaturaDetalhes' on type viatura.web.TabelasViaturaBean

1 resposta
tiago_

Pessoal, tenho essa consulta aqui:

public List<Object[]>detalhesViatura(int codigo){  
         String hql = "select  v.codigo as codigoViatura, v.nome as nomeViatura, v.placa as placaViatura, v.placaOperacional as placaOperacionalViatura, " +  
         "v.chaci as chaciViatura, v.cor as corViatura, v.ano as anoViatura, v.modelo as modeloViatura, p.nome as nomePropietarioViatura, " +  
         "sv.nome as statusViatura from Viatura v inner join v.propietario as p inner join v.statusViatura as sv where v.codigo = :v.codigo";  
         Query consulta = this.session.createQuery(hql);  
         consulta.setInteger("codigo", codigo);  
         return (List<Object[]>) consulta.uniqueResult();  
    }

O bean q chama ela:

@ManagedBean(name = "tabelasViaturaBean")  
@SessionScoped  
  
public class TabelasViaturaBean {  
  
private List<ViaturaModel>viaturaDetalhes;  
  
  
public List<ViaturaModel> getViaturaDetalhes() {  
          
        FacesContext context = FacesContext.getCurrentInstance();  
        ViaturaRN viaturaRN = new ViaturaRN();  
          
        List<ViaturaModel> viaturaDetalhes = new ArrayList<ViaturaModel>();  
          
        int codV = getCodigoViatura();  
          
        List<Object[]> objs = viaturaRN.detalhesViatura(codV);  
          
        List<String> listadeString = new ArrayList<String>();  
          
        for (Object[] array : objs) {    
            for (Object objeto : array) {    
                listadeString.add(objeto.toString());  
        }  
          
        ViaturaModel vm = new ViaturaModel();  
          
        int codigoV = Integer.parseInt(listadeString.get(0));  
        vm.setCodigoViatura(codigoV);  
          
        vm.setNomeViatura(listadeString.get(1));  
          
        vm.setPlacaViatura(listadeString.get(2));  
          
        vm.setPlacaOperacionalViatura(listadeString.get(3));  
          
        vm.setChaciViatura(listadeString.get(4));  
          
        vm.setCorViatura(listadeString.get(5));  
          
        int anoV = Integer.parseInt(listadeString.get(6));  
        vm.setAnoViatura(anoV);  
          
        vm.setModeloViatura(listadeString.get(7));  
          
        vm.setNomePropietarioViatura(listadeString.get(8));  
          
        vm.setStatusViatura(listadeString.get(9));  
          
        viaturaDetalhes.add(vm);  
          
        listadeString = new ArrayList<String>();   
          
          
        }  
            return viaturaDetalhes;  
    }

A pagina:

<?xml version="1.0" encoding="ISO-8859-1" ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"
	  xmlns:ui="http://java.sun.com/jsf/facelets"
	  xmlns:h="http://java.sun.com/jsf/html"
	  xmlns:f="http://java.sun.com/jsf/core"
	  xmlns:p="http://primefaces.org/ui">

<ui:composition template="/templates/interna.xhtml">
 <ui:define name="corpo">
		
				
   <h:panelGrid columns="1" width="100%" id="listaMotorista" >
	 <p:panel id="tam" header="Lista de Viaturas"  >	
		
		<h:form id="tm" >

		    <h:messages />
		    	<h:inputHidden value="#{viatura.codigo}"/>
		    	
		    	
			<br/>
				
			<p:dataTable id="tableVia" value="#{tabelasViaturaBean.viaturaDetalhes}" var="via" rows="1" cellpadding="5" >
			
			<f:facet name="caption">

				<br />
			</f:facet>
		
			<p:column   width="4%">
				<f:facet name="header">Código</f:facet>
			    <h:outputText value="#{via.codigoViatura}"/>
			</p:column>
			
			<p:column  style="white-space:normal !important;">
				<f:facet name="header">Nome</f:facet>
			    <h:outputText value="#{via.nomeViatura}" />
			</p:column>

			<p:column  style="white-space:normal !important;" width="26%">
				<f:facet name="header">Placa</f:facet>
		        <h:outputText value="#{via.placaViatura}" />
			</p:column>
			
			<p:column  style="white-space:normal !important;" width="26%">
				<f:facet name="header">Placa Operacional</f:facet>
		        <h:outputText value="#{via.placaOperacionalViatura}" />
			</p:column>
			
			<p:column  style="white-space:normal !important;" width="26%">
				<f:facet name="header">Chaci</f:facet>
		        <h:outputText value="#{via.chaciViatura}" />
			</p:column>
			
			<p:column  style="white-space:normal !important;" width="26%">
				<f:facet name="header">Cor</f:facet>
		        <h:outputText value="#{via.corViatura}" />
			</p:column>
			
			<p:column  style="white-space:normal !important;" width="26%">
				<f:facet name="header">Ano</f:facet>
		        <h:outputText value="#{via.anoViatura}" />
			</p:column>
			
			<p:column  style="white-space:normal !important;" width="26%">
				<f:facet name="header">Modelo</f:facet>
		        <h:outputText value="#{via.modeloViatura}" />
			</p:column>
			
			<p:column  style="white-space:normal !important;" width="26%">
				<f:facet name="header">Propietário</f:facet>
		        <h:outputText value="#{via.nomePropietarioViatura}" />
			</p:column>
			
			<p:column  style="white-space:normal !important;" width="26%">
				<f:facet name="header">Status</f:facet>
		        <h:outputText value="#{via.statusViatura}" />
			</p:column>
			
	     </p:dataTable>
	    </h:form>
	   </p:panel>
     </h:panelGrid>	
   </ui:define>
 </ui:composition>
</html>

O erro:

javax.faces.el.EvaluationException: java.lang.NullPointerException

at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:9

at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:9

at javax.faces.component.UICommand.broadcast(UICommand.java:311)

at javax.faces.component.UIData.broadcast(UIData.java:912)

at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:781)

at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1246)

at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:77)

at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:97)

at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:114)

at javax.faces.webapp.FacesServlet.service(FacesServlet.java:310)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at requisicao.web.filter.ConexaoHibernateFilter.doFilter(ConexaoHibernateFilter.java:34)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:344)

at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:110)

at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:356)

at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:9

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:356)

at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:95)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:356)

at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:79)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:356)

at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:55)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:356)

at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:36)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:356)

at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:18

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:356)

at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:106)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:356)

at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:80)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:356)

at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:150)

at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)

at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)

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:225)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:16

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:9

at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:11

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)

at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1001)

at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585)

at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)

at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:90

at java.lang.Thread.run(Thread.java:662)

Caused by: java.lang.NullPointerException

at org.hibernate.hql.ast.HqlSqlWalker.lookupProperty(HqlSqlWalker.java:547)

at org.hibernate.hql.antlr.HqlSqlBaseWalker.addrExpr(HqlSqlBaseWalker.java:468

at org.hibernate.hql.antlr.HqlSqlBaseWalker.expr(HqlSqlBaseWalker.java:1319)

at org.hibernate.hql.antlr.HqlSqlBaseWalker.exprOrSubquery(HqlSqlBaseWalker.java:4385)

at org.hibernate.hql.antlr.HqlSqlBaseWalker.comparisonExpr(HqlSqlBaseWalker.java:3861)

at org.hibernate.hql.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:1909)

at org.hibernate.hql.antlr.HqlSqlBaseWalker.whereClause(HqlSqlBaseWalker.java:824)

at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:610)

at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:294)

at org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:237)

at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:254)

at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:185)

at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136)

at org.hibernate.engine.query.HQLQueryPlan.(HQLQueryPlan.java:101)

at org.hibernate.engine.query.HQLQueryPlan.(HQLQueryPlan.java:80)

at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:9

at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:156)

at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:135)

at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1760)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at org.hibernate.context.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke(ThreadLocalSessionContext.java:344)

at $Proxy22.createQuery(Unknown Source)

at viatura.vviatura.ViaturaDAOHibernate.detalhesViatura(ViaturaDAOHibernate.java:92)

at viatura.vviatura.ViaturaRN.detalhesViatura(ViaturaRN.java:5

at viatura.web.TabelasViaturaBean.getViaturaDetalhes(TabelasViaturaBean.java:71)

at viatura.web.TabelasViaturaBean.verDetalhes(TabelasViaturaBean.java:55)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at com.sun.el.parser.AstValue.invoke(AstValue.java:234)

at com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:297)

at com.sun.faces.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:102)

at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:84)

 53 more

[b]
Eu ja fiz isso antes mais de uma vez e nunca tive problema… A consulta ta funcionando pq eu testei ela no HQL EDITOR. O q pode esta acontecendo ?

[]'s[/b]

Erro q apareceu no console:

44948 [http-bio-8080-exec-9] ERROR org.hibernate.hql.PARSER - :1:396: unexpected AST node: :

19/08/2013 11:04:31 com.sun.faces.application.view.FaceletViewHandlingStrategy handleRenderException

GRAVE: Error Rendering View[/pages/vip_cv/viatura_detalhe.xhtml]

javax.el.ELException: /pages/vip_cv/viatura_detalhe.xhtml @24,117 value="#{tabelasViaturaBean.viaturaDetalhes}": Error reading viaturaDetalhes on type viatura.web.TabelasViaturaBean

at com.sun.faces.facelets.el.TagValueExpression.getValue(TagValueExpression.java:111)

at javax.faces.component.ComponentStateHelper.eval(ComponentStateHelper.java:190)

at javax.faces.component.ComponentStateHelper.eval(ComponentStateHelper.java:178)

at javax.faces.component.UIData.getValue(UIData.java:554)

at org.primefaces.component.datatable.DataTable.getValue(DataTable.java:867)

at org.primefaces.component.api.UIData.getDataModel(UIData.java:579)

at javax.faces.component.UIData.getRowCount(UIData.java:339)

at org.primefaces.component.datatable.DataTableRenderer.encodeTbody(DataTableRenderer.java:629)

at org.primefaces.component.datatable.DataTableRenderer.encodeRegularTable(DataTableRenderer.java:234)

at org.primefaces.component.datatable.DataTableRenderer.encodeMarkup(DataTableRenderer.java:196)

at org.primefaces.component.datatable.DataTableRenderer.encodeEnd(DataTableRenderer.java:82)

at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:879)

at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1650)

at javax.faces.render.Renderer.encodeChildren(Renderer.java:164)

at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:849)

at org.primefaces.renderkit.CoreRenderer.renderChild(CoreRenderer.java:59)

at org.primefaces.renderkit.CoreRenderer.renderChildren(CoreRenderer.java:47)

at org.primefaces.component.panel.PanelRenderer.encodeContent(PanelRenderer.java:202)

at org.primefaces.component.panel.PanelRenderer.encodeMarkup(PanelRenderer.java:119)

at org.primefaces.component.panel.PanelRenderer.encodeEnd(PanelRenderer.java:56)

at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:879)

at com.sun.faces.renderkit.html_basic.HtmlBasicRenderer.encodeRecursive(HtmlBasicRenderer.java:308)

at com.sun.faces.renderkit.html_basic.GridRenderer.renderRow(GridRenderer.java:181)

at com.sun.faces.renderkit.html_basic.GridRenderer.encodeChildren(GridRenderer.java:125)

at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:849)

at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1643)

at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1646)

at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1646)

at com.sun.faces.application.view.FaceletViewHandlingStrategy.renderView(FaceletViewHandlingStrategy.java:389)

at com.sun.faces.application.view.MultiViewHandler.renderView(MultiViewHandler.java:127)

at com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:117)

at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:97)

at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:135)

at javax.faces.webapp.FacesServlet.service(FacesServlet.java:311)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at requisicao.web.filter.ConexaoHibernateFilter.doFilter(ConexaoHibernateFilter.java:34)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:344)

at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:110)

at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:356)

at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:98)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:356)

at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:95)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:356)

at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:79)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:356)

at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:55)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:356)

at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:36)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:356)

at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:188)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:356)

at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:106)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:356)

at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:80)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:356)

at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:150)

at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)

at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)

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:225)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)

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:927)

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:1001)

at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585)

at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)

at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)

at java.lang.Thread.run(Thread.java:662)

Caused by: java.lang.NullPointerException

at org.hibernate.hql.ast.HqlSqlWalker.lookupProperty(HqlSqlWalker.java:547)

at org.hibernate.hql.antlr.HqlSqlBaseWalker.addrExpr(HqlSqlBaseWalker.java:4688)

at org.hibernate.hql.antlr.HqlSqlBaseWalker.expr(HqlSqlBaseWalker.java:1319)

at org.hibernate.hql.antlr.HqlSqlBaseWalker.exprOrSubquery(HqlSqlBaseWalker.java:4385)

at org.hibernate.hql.antlr.HqlSqlBaseWalker.comparisonExpr(HqlSqlBaseWalker.java:3861)

at org.hibernate.hql.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:1909)

at org.hibernate.hql.antlr.HqlSqlBaseWalker.whereClause(HqlSqlBaseWalker.java:824)

at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:610)

at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:294)

at org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:237)

at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:254)

at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:185)

at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136)

at org.hibernate.engine.query.HQLQueryPlan.(HQLQueryPlan.java:101)

at org.hibernate.engine.query.HQLQueryPlan.(HQLQueryPlan.java:80)

at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:98)

at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:156)

at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:135)

at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1760)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at org.hibernate.context.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke(ThreadLocalSessionContext.java:344)

at $Proxy22.createQuery(Unknown Source)

at viatura.vviatura.ViaturaDAOHibernate.detalhesViatura(ViaturaDAOHibernate.java:93)

at viatura.vviatura.ViaturaRN.detalhesViatura(ViaturaRN.java:58)

at viatura.web.TabelasViaturaBean.getViaturaDetalhes(TabelasViaturaBean.java:67)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at javax.el.BeanELResolver.getValue(BeanELResolver.java:87)

at javax.el.CompositeELResolver.getValue(CompositeELResolver.java:67)

at com.sun.faces.el.FacesCompositeELResolver.getValue(FacesCompositeELResolver.java:71)

at com.sun.el.parser.AstValue.getValue(AstValue.java:116)

at com.sun.el.parser.AstValue.getValue(AstValue.java:163)

at com.sun.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:219)

at com.sun.faces.facelets.el.TagValueExpression.getValue(TagValueExpression.java:106)

 77 more

44978 [http-bio-8080-exec-9] ERROR org.hibernate.hql.PARSER - :1:396: unexpected AST node: :

1 Resposta

tiago_

Resolvido:

@SuppressWarnings("unchecked")
	public List<Object[]>detalhesViatura(int codigo){
		 String hql = "select  v.codigo as codigoViatura, v.nome as nomeViatura, v.placa as placaViatura, v.placaOperacional as placaOperacionalViatura, " +
		 "v.chaci as chaciViatura, v.cor as corViatura, v.ano as anoViatura, v.modelo as modeloViatura, p.nome as nomePropietarioViatura, " +
		 "sv.nome as statusViatura from Viatura v inner join v.propietario as p inner join v.statusViatura as sv where v.codigo = :codigo";
	     Query consulta = this.session.createQuery(hql);
	     consulta.setInteger("codigo", codigo);
	     return consulta.list(); 
	}
Criado 16 de agosto de 2013
Ultima resposta 19 de ago. de 2013
Respostas 1
Participantes 1