Interesting problem with seam and DataModel and hibernate
c_eric_ray Jul 31, 2006 1:55 PMHere's the session bean snippet...
@Out(scope=ScopeType.SESSION) private DataModel openPackages = new ListDataModel(); private String opQuery = "from PackageEntity p, OfficeEntity o where p.office.id = o.id and p.code = 'OPN' and o.id = 1"; @Create @Factory("openPackages") public void init() { openPackages.setWrappedData(em.createQuery(opQuery).getResultList()); openPackages.addDataModelListener(this); openPackages.setRowIndex(0); }
the jsf snippet
<h:dataTable value="#{openPackages}" var="pkgEntity" rendered="#{openPackages.rowCount > 0}" rows="#{rowSize}" first="#{openIndex}" rowClasses="evenRow,oddRow" cellspacing="0" onmouseover="highlightRow(event);" onmouseout="unhighlightRow(event);"> <h:column> <f:facet name="header"> <h:outputText value="#{pkgHeaders.id}" /> </f:facet> <h:commandLink value="#{pkgEntity.id}" action="#{remittance.selectedRemittance}" /> </h:column> <h:column> .... more columns ... </h:dataTable>
the exception i receive...
java.lang.NumberFormatException: For input string: "id" 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 com.sun.facelets.el.LegacyELContext$LegacyELResolver.getValue(LegacyELContext.java:138) at com.sun.el.parser.AstValue.getValue(AstValue.java:96) at com.sun.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:183) at com.sun.facelets.el.TagValueExpression.getValue(TagValueExpression.java:71) at com.sun.facelets.el.LegacyValueBinding.getValue(LegacyValueBinding.java:56) at javax.faces.component.UICommand.getValue(UICommand.java:170) at org.apache.myfaces.renderkit.html.HtmlLinkRendererBase.encodeBegin(HtmlLinkRendererBase.java:87) at javax.faces.component.UIComponentBase.encodeBegin(UIComponentBase.java:307) at org.apache.myfaces.renderkit.RendererUtils.renderChild(RendererUtils.java:441) at org.apache.myfaces.renderkit.RendererUtils.renderChildren(RendererUtils.java:427) at org.apache.myfaces.renderkit.RendererUtils.renderChild(RendererUtils.java:448) at org.apache.myfaces.renderkit.html.HtmlTableRendererBase.renderColumnBody(HtmlTableRendererBase.java:195) at org.apache.myfaces.renderkit.html.HtmlTableRendererBase.encodeColumnChild(HtmlTableRendererBase.java:168) at org.apache.myfaces.renderkit.html.HtmlTableRendererBase.encodeInnerHtml(HtmlTableRendererBase.java:154) at org.apache.myfaces.renderkit.html.HtmlTableRendererBase.encodeChildren(HtmlTableRendererBase.java:94) at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:319) at com.sun.facelets.FaceletViewHandler.encodeRecursive(FaceletViewHandler.java:557) at com.sun.facelets.FaceletViewHandler.encodeRecursive(FaceletViewHandler.java:562) at com.sun.facelets.FaceletViewHandler.renderView(FaceletViewHandler.java:457) at org.apache.myfaces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:352) at javax.faces.webapp.FacesServlet.service(FacesServlet.java:107) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112) at java.lang.Thread.run(Thread.java:595)
I believe I know what's wrong but I'm not sure why or how to fix it. So, if you guys will bear with me and read along I'll explain as best I can.
I think the problem lies in the query which does a join and the resultant List actually consists of both entity (PackageEntity and OfficeEntity) objects retreive from the database (using hibernate). The reason I say this is because I had everything working just fine with the simple query like so
from PacakgeEntity p where p.code = 'OPN'
This simple query returned a list of PackageEntity objects and all was good. The new query returns a list alright, but it's not a PackageEntity list. It's an Object list. Each element in the object list then contains a list of PackageEnity and OfficeEntity objects that were created from the join (so I think).
So, it's seems that I have some sort of referencing problem and I don't really now how to resolve it. Please ask if you need more information. This is hard to explain.
Thanks.
Eric Ray