0 Replies Latest reply on Jun 17, 2009 7:39 PM by David Jitendranath

    Problems displaying Database view with the view list

    David Jitendranath Novice

      Hi,
      I've used the JBoss tools for eclipse to generate Seam entities and templates.  The database has some tables and views.  Some of those tables have special characters for column names (pound and dollar sign) I refactored code to get them to work.  It works for all the tables now but the views have a problem displaying.
      I added the richfaces code to my eclipse workspace and put a debug point at the model level.  The query against the view seems to get fired fine and it even runs fine on TOAD and returns rows.  When I inspect the model the list has element data that have null values in them.
      Can you please give me some ideas on how I can troubleshoot this?


      Here's the generated JSF template (xhtml)




      <rich:dataTable id="zzzauditSessionViewList"
                      var="_zzzauditSessionView"
                    value="#{zzzauditSessionViewList.resultList}"
                 rendered="#{not empty zzzauditSessionViewList.resultList}">
              <h:column>
                  <f:facet name="header">
                      <ui:include src="layout/sort.xhtml">
                          <ui:param name="entityList" value="#{zzzauditSessionViewList}"/>
                          <ui:param name="propertyLabel" value="Dbid"/>
                          <ui:param name="propertyPath" value="zzzauditSessionView.id.dbid"/>
                      </ui:include>
                  </f:facet>
                  <h:outputText value="#{_zzzauditSessionView.id.dbid}">
                      <f:convertNumber/>
                  </h:outputText>
              </h:column>






      Thanks,
      Davestar