From jira-events at lists.jboss.org Sat May 19 16:41:18 2012 Content-Type: multipart/mixed; boundary="===============3268010472839364006==" MIME-Version: 1.0 From: Sagi Kovaliov (JIRA) To: richfaces-issues at lists.jboss.org Subject: [richfaces-issues] [JBoss JIRA] (RF-12274) Datatable (rich:dataTable) is not populated with data Date: Sat, 19 May 2012 16:41:17 -0400 Message-ID: <1175498790.92695.1337460077981.JavaMail.tomcat@jira02.app.mwc.hst.phx2.redhat.com> --===============3268010472839364006== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Sagi Kovaliov created RF-12274: ---------------------------------- Summary: 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 Hello, When I use the following BeanClass and XHTML page, Datatable is not populat= ed with data, despite the method getAll() returns ResultSet that contains c= ustomer names. = To demonstrate this, I've added a line System.out.println(crs.getString("Na= me")) that iterates through the ResultSet and prints customer names from cu= stomer table before the ResultSet is being returned to t:dataTable componen= t. = It's important to mention, that once I change to , I do get the populated rows in the table. This is Tomcat log that ilustrates that the resultset contains data: .......... = ******************************************************************* = *** WARNING: Apache MyFaces-2 is running in DEVELOPMENT mode. *** = *** ^^^^^^^^^^^ *** = *** Do NOT deploy to your live server(s) without changing this. *** = *** See Application#getProjectStage() for more information. *** = ******************************************************************* = 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 isUnifie= dELAvailable = 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=3D"jdbc/Sufa") private DataSource ds; = public ResultSet getAll() throws SQLException { = = Connection conn =3D ds.getConnection(); = try { = = Statement stmt =3D conn.createStatement(); = ResultSet result =3D stmt.executeQuery("SELECT * FROM customers"); = CachedRowSet crs =3D 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: = = = = = = = = #{msgs.nameHeader} = #{customer.Name} = = = = = = Thanks a lot = Sagi -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrato= rs: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira =20 --===============3268010472839364006==--