[richfaces-issues] [JBoss JIRA] (RF-12274) Datatable (rich:dataTable) is not populated with data
Brian Leathem (JIRA)
jira-events at lists.jboss.org
Tue May 22 21:47:17 EDT 2012
[ https://issues.jboss.org/browse/RF-12274?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Brian Leathem resolved RF-12274.
--------------------------------
Assignee: Brian Leathem
Resolution: Rejected
You are returning a _ResultSet_ from your _getAll()_ method. Data table requires a _Collection_.
Please do not file jira issues for usage assistance, try the [RichFaces forums|https://community.jboss.org/en/richfaces?view=discussions], or an external site like [stackoverflow.com|http://stackoverflow.com/].
> 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
More information about the richfaces-issues
mailing list