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

Tue May 22 19:00:17 EDT 2012

     [ https://issues.jboss.org/browse/RF-12274?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Brian Leathem updated RF-12274:
-------------------------------

    Description: 
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

  was:
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: 

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 

This is the 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(); 
      } 
    } 
} 

This is xhtml 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> 

Thanks a lot 

Sagi

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