1 Reply Latest reply on Jul 31, 2006 3:05 PM by c_eric_ray

    Interesting problem with seam and DataModel and hibernate

      Here'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