Entity Query and left outer joins...

[mkabir]

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
     

[fernando_jmt]

Can you show us your xhtml where you're using the entity query?

[mkabir]

Sorry the query is

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

the xhtml is

<ui:repeat value="#{myCats.resultList}" var="cats">
    <h:outputText value="#{cats.catId}"/>
    <h:outputText value="#{cats.catName}"/>
</ui:repeat>

I just found out that this will not work as counts are going to be inaccurate.

What I actually need is a way to select cats and iterate over the kittens for each cat and see if a litten has a particular name.

[fernando_jmt]

I think you can find the answer here.