[richfaces-issues] [JBoss JIRA] (RF-12274) Datatable (rich:dataTable) is not populated with data

Wed May 23 02:21:18 EDT 2012

    [ https://issues.jboss.org/browse/RF-12274?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12694933#comment-12694933 ] 

Sagi Kovaliov commented on RF-12274:
------------------------------------

I didn't find what types the "value" attribute requires in the API ducumentation / Developer guide / Component Refference. If rich:datatable extends h:datatable in JSF 2.0, then it should except resultset as well ! Please update the documentation. This is an essential !

> Datatable (rich:dataTable) is not populated with data
> -----------------------------------------------------
>
>                 Key: RF-12274
>                 URL: https://issues.jboss.org/browse/RF-12274
>             Project: RichFaces
>          Issue Type: Bug
>      Security Level: Public(Everyone can see) 
>          Components: component-tables
>    Affects Versions: 4.2.1.Final
>         Environment: Windows 7 64bit 
> Tomcat 7.0.26 
> myfaces-core-2.0.13 
> richfaces 4.2.1
> JRE 6 
> MySQL Server 5.5 
> mysql-connector-java-5.1.18
>            Reporter: Sagi Kovaliov
>            Assignee: Brian Leathem
>              Labels: datatable, resultset, richfaces
>
> Hello,
> When I use the following BeanClass and XHTML page, Datatable is not populated with data, despite the method getAll() returns ResultSet that contains customer names. 
> To demonstrate this, I've added a line System.out.println(crs.getString("Name")) that iterates through the ResultSet and prints customer names from customer table before the ResultSet is being returned to t:dataTable component. 
> It's important to mention, that once I change <rich:datatable> to <h:datatable>, I do get the populated rows in the table.
> This is Tomcat log that ilustrates that the resultset contains data: 
> {code:title="Tomcat Log"}
> 29/03/2012 22:19:57 org.apache.coyote.AbstractProtocol start 
> INFO: Starting ProtocolHandler ["http-bio-8080"] 
> 29/03/2012 22:19:57 org.apache.coyote.AbstractProtocol start 
> INFO: Starting ProtocolHandler ["ajp-bio-8009"] 
> 29/03/2012 22:19:57 org.apache.catalina.startup.Catalina start 
> INFO: Server startup in 4706 ms 
> 29/03/2012 22:19:58 org.apache.myfaces.util.ExternalSpecifications isUnifiedELAvailable 
> INFO: MyFaces Unified EL support enabled 
> Start of Debug 
> William Dupont 
> William Dupont 
> End of Debug 
> {code}
> This is the ManagedBean: 
> {code:title="ManagedBean"}
> package com.corejsf; 
> import java.sql.Connection; 
> import java.sql.ResultSet; 
> import java.sql.SQLException; 
> import java.sql.Statement; 
> import javax.annotation.Resource; 
> import javax.faces.bean.*; 
> import javax.sql.DataSource; 
> import javax.sql.rowset.CachedRowSet; 
> @ManagedBean 
> @RequestScoped 
> public class CustomerBean { 
> @Resource(name="jdbc/Sufa") private DataSource ds; 
>     public ResultSet getAll() throws SQLException { 
>         
>       Connection conn = ds.getConnection(); 
> try { 
>           
>         Statement stmt = conn.createStatement(); 
>         ResultSet result = stmt.executeQuery("SELECT * FROM customers"); 
>         CachedRowSet crs = new com.sun.rowset.CachedRowSetImpl(); 
>         crs.populate(result); 
>           
>         System.out.println("Start of Debug"); 
>           
>         while(crs.next()) { 
>           System.out.println(crs.getString("Name")); 
> } 
>           
>         System.out.println("End of Debug"); 
>         return crs; 
>           
>       } finally { 
> conn.close(); 
>       } 
>     } 
> } 
> {code}
> This is xhtml page: 
> {code:title="Facelet page"}
> <?xml version="1.0" encoding="UTF-8"?> 
> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" 
> "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> 
> <html xmlns="http://www.w3.org/1999/xhtml" 
> xmlns:f="http://java.sun.com/jsf/core" 
> xmlns:h="http://java.sun.com/jsf/html" 
> xmlns:rich="http://richfaces.org/rich"
> xmlns:ui="http://java.sun.com/jsf/facelets"> 
> <h:body> 
> <h:form> 
> <rich:dataTable value="#{customerBean.all}" var="customer"> 
>   <rich:column> 
>     <f:facet name="header">#{msgs.nameHeader}</f:facet> 
>       #{customer.Name} 
>   </rich:column> 
> </rich:dataTable> 
> </h:form> 
> </h:body> 
> </html> 
> {code}
> Thanks a lot 
> Sagi

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira