From jira-events at lists.jboss.org Sat May 19 16:41:18 2012 Content-Type: multipart/mixed; boundary="===============2672362382205800682==" 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> --===============2672362382205800682== 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 --===============2672362382205800682==-- From jira-events at lists.jboss.org Sat May 19 16:43:18 2012 Content-Type: multipart/mixed; boundary="===============8012555420145987785==" 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:18 -0400 Message-ID: <1900369241.92700.1337460198041.JavaMail.tomcat@jira02.app.mwc.hst.phx2.redhat.com> In-Reply-To: 1175498790.92695.1337460077981.JavaMail.tomcat@jira02.app.mwc.hst.phx2.redhat.com --===============8012555420145987785== 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: = 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: = > 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 --===============8012555420145987785==-- From jira-events at lists.jboss.org Sat May 19 16:43:18 2012 Content-Type: multipart/mixed; boundary="===============2807101232665141945==" 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 --===============2807101232665141945== 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 --===============2807101232665141945==-- From jira-events at lists.jboss.org Tue May 22 19:00:17 2012 Content-Type: multipart/mixed; boundary="===============2552408650397514187==" MIME-Version: 1.0 From: Brian Leathem (JIRA) To: richfaces-issues at lists.jboss.org Subject: [richfaces-issues] [JBoss JIRA] (RF-12274) Datatable (rich:dataTable) is not populated with data Date: Tue, 22 May 2012 19:00:17 -0400 Message-ID: <1812000587.100620.1337727617886.JavaMail.tomcat@jira02.app.mwc.hst.phx2.redhat.com> In-Reply-To: 1175498790.92695.1337460077981.JavaMail.tomcat@jira02.app.mwc.hst.phx2.redhat.com --===============2552408650397514187== 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 ] Brian Leathem 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: = {code:title=3D"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 isUnifie= dELAvailable = INFO: MyFaces Unified EL support enabled = Start of Debug = William Dupont = William Dupont = End of Debug = {code} This is the ManagedBean: = {code:title=3D"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(); = } = } = } = {code} This is xhtml page: = {code:title=3D"Facelet page"} = = = = = = = #{msgs.nameHeader} = #{customer.Name} = = = = = = {code} 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: = 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: = > {code:title=3D"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 isUnif= iedELAvailable = > INFO: MyFaces Unified EL support enabled = > Start of Debug = > William Dupont = > William Dupont = > End of Debug = > {code} > This is the ManagedBean: = > {code:title=3D"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(); = > } = > } = > } = > {code} > This is xhtml page: = > {code:title=3D"Facelet 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} = > = > = > = > = > = > {code} > 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 --===============2552408650397514187==-- From jira-events at lists.jboss.org Tue May 22 21:47:18 2012 Content-Type: multipart/mixed; boundary="===============5626781229703921286==" MIME-Version: 1.0 From: Brian Leathem (JIRA) To: richfaces-issues at lists.jboss.org Subject: [richfaces-issues] [JBoss JIRA] (RF-12274) Datatable (rich:dataTable) is not populated with data Date: Tue, 22 May 2012 21:47:17 -0400 Message-ID: <743262884.100706.1337737637988.JavaMail.tomcat@jira02.app.mwc.hst.phx2.redhat.com> In-Reply-To: 1175498790.92695.1337460077981.JavaMail.tomcat@jira02.app.mwc.hst.phx2.redhat.com --===============5626781229703921286== 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 ] Brian Leathem resolved RF-12274. -------------------------------- Assignee: Brian Leathem Resolution: Rejected You are returning a _ResultSet_ from your _getAll()_ method. Data table re= quires a _Collection_. Please do not file jira issues for usage assistance, try the [RichFaces for= ums|https://community.jboss.org/en/richfaces?view=3Ddiscussions], or an ext= ernal 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 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: = > {code:title=3D"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 isUnif= iedELAvailable = > INFO: MyFaces Unified EL support enabled = > Start of Debug = > William Dupont = > William Dupont = > End of Debug = > {code} > This is the ManagedBean: = > {code:title=3D"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(); = > } = > } = > } = > {code} > This is xhtml page: = > {code:title=3D"Facelet 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} = > = > = > = > = > = > {code} > 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 --===============5626781229703921286==-- From jira-events at lists.jboss.org Wed May 23 02:21:18 2012 Content-Type: multipart/mixed; boundary="===============4932405107877803344==" 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: Wed, 23 May 2012 02:21:18 -0400 Message-ID: <151267252.100844.1337754078826.JavaMail.tomcat@jira02.app.mwc.hst.phx2.redhat.com> In-Reply-To: 1175498790.92695.1337460077981.JavaMail.tomcat@jira02.app.mwc.hst.phx2.redhat.com --===============4932405107877803344== 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.pl= ugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=3D12694933#com= ment-12694933 ] = Sagi Kovaliov commented on RF-12274: ------------------------------------ I didn't find what types the "value" attribute requires in the API ducument= ation / Developer guide / Component Refference. If rich:datatable extends h= :datatable in JSF 2.0, then it should except resultset as well ! Please upd= ate 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 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: = > {code:title=3D"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 isUnif= iedELAvailable = > INFO: MyFaces Unified EL support enabled = > Start of Debug = > William Dupont = > William Dupont = > End of Debug = > {code} > This is the ManagedBean: = > {code:title=3D"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(); = > } = > } = > } = > {code} > This is xhtml page: = > {code:title=3D"Facelet 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} = > = > = > = > = > = > {code} > 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 --===============4932405107877803344==--