1 Reply Latest reply on Nov 21, 2007 10:58 AM by Edwin van der Elst

    outer joins with seam

    Jaime Martin Apprentice

      I wonder if there is a special syntax for defining queries with outer joins in seam.
      I am trying this query defined in my components.xml file

       <framework:entity-query name="innerJoinQueryList"
       ejbql="select instruFund, instru, cash
       FROM InstrumentFund instruFund
       left outer JOIN Instrument instru
       ON instruFund.id.idAsset = instru.internalOptionNumber
       left outer JOIN Cash cash
       ON instruFund.id.idAsset = cash.idCash">

      I am using this query from a xhtml file (called RstReportInstruValuList.xhtml ) this way

      <rich:dataTable id="innerJoinQueryList"
       value="#{innerJoinQueryList.resultList}" >
       <f:facet name="header">
       <s:link styleClass="columnHeader"
       <f:facet name="header">
       <s:link styleClass="columnHeader"

      I have this error:

      An Error Occurred:
      /RstReportInstruValuList.xhtml @157,13 value="#{innerJoinQueryList.resultList}": org.jboss.seam.framework.EntityQuery_$$_javassist_1721

      Is there a special syntax for defining queries with joins?
      thanks in advance!