From jira-events at lists.jboss.org Sat May 19 16:43:18 2012 Content-Type: multipart/mixed; boundary="===============7527587859594374713==" 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:43:17 -0400 Message-ID: <1693613823.92698.1337460197955.JavaMail.tomcat@jira02.app.mwc.hst.phx2.redhat.com> In-Reply-To: 1175498790.92695.1337460077981.JavaMail.tomcat@jira02.app.mwc.hst.phx2.redhat.com --===============7527587859594374713== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable [ https://issues.jboss.org/browse/RF-12274?page=3Dcom.atlassian.jira.p= lugin.system.issuetabpanels:all-tabpanel ] Sagi Kovaliov updated RF-12274: ------------------------------- Description: = 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 was: 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 = > 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 popul= ated 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 compon= ent. = > 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 isUnif= iedELAvailable = > 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: = > = > "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> = > xmlns:f=3D"http://java.sun.com/jsf/core" = > xmlns:h=3D"http://java.sun.com/jsf/html" = > xmlns:rich=3D"http://richfaces.org/rich" > xmlns:ui=3D"http://java.sun.com/jsf/facelets"> = > = > = > = > = > #{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 --===============7527587859594374713==--