3:43 p.m.
[
https://issues.jboss.org/browse/RF-12274?page=com.atlassian.jira.plugin.s...
]
Sagi Kovaliov 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:
*******************************************************************
*** 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 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
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:
..........
*******************************************************************
*** 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 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:
*******************************************************************
*** 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 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
--
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