exception

javax.servlet.ServletException: #{queryHelper.listSearchResults}: javax.faces.el.EvaluationException: org.hibernate.exception.SQLGrammarException: could not execute query
   javax.faces.webapp.FacesServlet.service(FacesServlet.java:209)

root cause

javax.faces.FacesException: #{queryHelper.listSearchResults}: javax.faces.el.EvaluationException: org.hibernate.exception.SQLGrammarException: could not execute query
   com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:78)
   javax.faces.component.UICommand.broadcast(UICommand.java:312)
   javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:267)
   javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:381)
   com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:75)
   com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:200)
   com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:90)
   javax.faces.webapp.FacesServlet.service(FacesServlet.java:197)

String sql ="Select e.PA_ID as {e.paId} from ET_EDI_Partner {e}";
         
         Query q = session.createSQLQuery(sql)
         .addEntity("e",EtEdiPartner.class);
         querylist=q.list();

String sql ="Select {e.*}  from ET_EDI_Partner {e}";
         
         Query q = session.createSQLQuery(sql)
         .addEntity("e",EtEdiPartner.class);
         querylist=q.list();

Select e.s_id, c.company, e.location, b.edisector, e.actisname, g.gw_name, g.ssid, g.sfid, a.method from et_edi_partner e
Inner Join et_company c on e.CO_ID = C.CO_ID
Inner Join et_edisector b on e.EDI_ID=b.EDI_ID
Inner Join et_gateway g on e.GW_ID = g.gw_id
Inner Join et_access_method a on g.a_id = a.a_id

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping schema="EDITOOLS" package="com.magnasteyr.editool.hibernate">
  <class name="EtEdiPartner" dynamic-update="true" dynamic-insert="true" lazy="false" table="ET_EDI_PARTNER">
    <id name="paId" type="long" unsaved-value="null">
      <column name="PA_ID" not-null="true" sql-type="NUMBER"/>
      <generator class="sequence"/>
    </id>
.....
....
  </class>
</hibernate-mapping>

String sql = "Select e.PA_ID as paId from ET_EDI_Partner e";
SQLQuery q = session.createSQLQuery(sql).addScalar("paId", Hibernate.LONG);
querylist = q.list();

select etedipartn0_.PA_ID as col_0_0_, etcompany1_.COMPANY as col_1_0_, etedipartn0_.LOCATION as col_2_0_, etedisecto2_.EDISECTOR as col_3_0_, etedipartn0_.ACTISNAME as col_4_0_, etgateway3_.GW_NAME as col_5_0_, etgateway3_.SSID as col_6_0_, etaccessme6_.METHOD as col_7_0_ from EDITOOLS.ET_EDI_PARTNER etedipartn0_, EDITOOLS.ET_COMPANY etcompany1_, EDITOOLS.ET_EDISECTOR etedisecto2_, EDITOOLS.ET_GATEWAY etgateway3_, EDITOOLS.ET_ACCESS_METHOD etaccessme6_ where etgateway3_.A_ID=etaccessme6_.A_ID and etedipartn0_.GW_ID=etgateway3_.GW_ID and etedipartn0_.EDI_ID=etedisecto2_.EDI_ID and etedipartn0_.CO_ID=etcompany1_.CO_ID

<h:dataTable value="#{queryHelper.queryresult}" var="result"
styleClass="smalltable_grey" width="100%" headerClass="kopf"
rowClasses="ungerade, gerade">

<h:column>
<f:facet name="header">
<h:outputText value="#{msg.tablestatus}" />
</f:facet>
<h:outputText value="#{result.[b]WHATTOWRITEHERE[/b]}" />
</h:column>
</h:dataTable>