3 Replies Latest reply on Mar 16, 2008 10:35 PM by Fernando Montaño

    Entity Query and left outer joins...

    Mike Kabir Newbie

      I have an entity query


      select c, k from Cat as c left join c.catKittenAssoc as cka



      The result sql query hs two catId's (one from Cat and one from CatKittenAssoc) as there are multiple kittes for a cat.


      The query works fine.


      However, when I use catId in my xhtml, I get the following error


      java.lang.NumberFormatException: For input string: "catId"
           at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
           at java.lang.Integer.parseInt(Integer.java:447)
           at java.lang.Integer.parseInt(Integer.java:497)
           at javax.el.ArrayELResolver.coerce(ArrayELResolver.java:153)
           at javax.el.ArrayELResolver.getValue(ArrayELResolver.java:45)
           at javax.el.CompositeELResolver.getValue(CompositeELResolver.java:53)
           at com.sun.faces.el.FacesCompositeELResolver.getValue(FacesCompositeELResolver.java:64)
           at org.jboss.el.parser.AstPropertySuffix.getValue(AstPropertySuffix.java:53)
           at org.jboss.el.parser.AstValue.getValue(AstValue.java:67)
           at org.jboss.el.parser.AstDeferredExpression.getValue(AstDeferredExpression.java:26)
           at org.jboss.el.parser.AstCompositeExpression.getValue(AstCompositeExpression.java:31)
           at org.jboss.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:186)
           at com.sun.facelets.el.TagValueExpression.getValue(TagValueExpression.java:71)
           at javax.faces.component.UIOutput.getValue(UIOutput.java:173)
           at com.sun.faces.renderkit.html_basic.OutputLinkRenderer.getValue(OutputLinkRenderer.java:223)
           at com.sun.faces.renderkit.html_basic.HtmlBasicRenderer.getCurrentValue(HtmlBasicRenderer.java:320)
           at com.sun.faces.renderkit.html_basic.OutputLinkRenderer.renderAsActive(OutputLinkRenderer.java:232)
           at com.sun.faces.renderkit.html_basic.OutputLinkRenderer.encodeBegin(OutputLinkRenderer.java:112)
           at javax.faces.component.UIComponentBase.encodeBegin(UIComponentBase.java:788)
           at org.ajax4jsf.renderkit.RendererBase.renderChild(RendererBase.java:280)
           at org.ajax4jsf.renderkit.RendererBase.renderChildren(RendererBase.java:262)
           at org.ajax4jsf.renderkit.html.AjaxOutputPanelRenderer.encodeChildren(AjaxOutputPanelRenderer.java:79)
      



      Anybody seen this before ? Any help is greatly appreciated.


      - Kabir