[jboss-user] [JBoss Seam] - Interesting problem with seam and DataModel and hibernate

[c_eric_ray]

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

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3961964#3961964

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3961964