6 Replies Latest reply on Dec 17, 2013 10:56 AM by dagj

seam 2.3 richfaces 4. Datatable with database with edit delete popup

bhaskardhone Aug 28, 2013 10:36 AM

http://www.coderanch.com/forums/posts/list/618875#2826620

I am using seam 2.3 and richfaces 4. Using that I am able to show data in datatable which is stored in database. But for edit and delete. I am trying to use example like

http://showcase.richfaces.org/richfaces/component-sample.jsf?demo=dataTable&sample=dataTableEdit&skin=blueSkyJboss richfaces

I am unable to do edit with pop up. selected row data is not coming in popup window.

Please help and suggest how to pass parameter for popup and use that to retrive data for editing .

Employee.java

view plain copy to clipboard print ?

Note: Text content in the code blocks is automatically word-wrapped

package org.domain.imonitortestseam.entity;
// Generated Aug 28, 2013 4:01:44 PM by Hibernate Tools 3.4.0.CR1
import java.math.BigDecimal;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Table;
import javax.validation.constraints.NotNull;
import javax.validation.constraints.Size;
/**
* Employee generated by hbm2java
*/
@Entity
@Table(name = "EMPLOYEE", schema = "MOBILITY_PROJ")
public class Employee implements java.io.Serializable {
private BigDecimal empid;
private String firstname;
private String lastname;
private String username;
private String password;
public Employee() {
}
public Employee(BigDecimal empid, String firstname, String lastname) {
this.empid = empid;
this.firstname = firstname;
this.lastname = lastname;
}
public Employee(BigDecimal empid, String firstname, String lastname,
String username, String password) {
this.empid = empid;
this.firstname = firstname;
this.lastname = lastname;
this.username = username;
this.password = password;
}
@Id
@Column(name = "EMPID", unique = true, nullable = false, precision = 22, scale = 0)
@NotNull
public BigDecimal getEmpid() {
return this.empid;
}
public void setEmpid(BigDecimal empid) {
this.empid = empid;
}
@Column(name = "FIRSTNAME", nullable = false, length = 100)
@NotNull
@Size(max = 100)
public String getFirstname() {
return this.firstname;
}
public void setFirstname(String firstname) {
this.firstname = firstname;
}
@Column(name = "LASTNAME", nullable = false, length = 100)
@NotNull
@Size(max = 100)
public String getLastname() {
return this.lastname;
}
public void setLastname(String lastname) {
this.lastname = lastname;
}
@Column(name = "USERNAME", length = 100)
@Size(max = 100)
public String getUsername() {
return this.username;
}
public void setUsername(String username) {
this.username = username;
}
@Column(name = "PASSWORD", length = 100)
@Size(max = 100)
public String getPassword() {
return this.password;
}
public void setPassword(String password) {
this.password = password;
}
}

EmployeeHome.java

view plain copy to clipboard print ?

Note: Text content in the code blocks is automatically word-wrapped

package org.domain.imonitortestseam.session;
import org.domain.imonitortestseam.entity.*;
import java.math.BigDecimal;
import org.jboss.seam.annotations.Name;
import org.jboss.seam.framework.EntityHome;
@Name("employeeHome")
public class EmployeeHome extends EntityHome<Employee> {
public void setEmployeeEmpid(BigDecimal id) {
setId(id);
}
public BigDecimal getEmployeeEmpid() {
return (BigDecimal) getId();
}
@Override
protected Employee createInstance() {
Employee employee = new Employee();
return employee;
}
public void load() {
if (isIdDefined()) {
wire();
}
}
public void wire() {
getInstance();
}
public boolean isWired() {
return true;
}
public Employee getDefinedInstance() {
return isIdDefined() ? getInstance() : null;
}
}

EmployeeList.java

view plain copy to clipboard print ?

Note: Text content in the code blocks is automatically word-wrapped

package org.domain.imonitortestseam.session;
import org.domain.imonitortestseam.entity.*;
import org.jboss.seam.annotations.Name;
import org.jboss.seam.framework.EntityQuery;
import java.util.Arrays;
@Name("employeeList")
public class EmployeeList extends EntityQuery<Employee> {
private static final String EJBQL = "select employee from Employee employee";
private static final String[] RESTRICTIONS = {
"lower(employee.firstname) like lower(concat(#{employeeList.employee.firstname},'%'))",
"lower(employee.lastname) like lower(concat(#{employeeList.employee.lastname},'%'))",
"lower(employee.username) like lower(concat(#{employeeList.employee.username},'%'))",
"lower(employee.password) like lower(concat(#{employeeList.employee.password},'%'))", };
private Employee employee = new Employee();
public EmployeeList() {
setEjbql(EJBQL);
setRestrictionExpressionStrings(Arrays.asList(RESTRICTIONS));
setMaxResults(25);
}
public Employee getEmployee() {
return employee;
}
}

xhtmlpage

view plain copy to clipboard print ?

Note: Text content in the code blocks is automatically word-wrapped

<!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:h="http://java.sun.com/jsf/html"
xmlns:a4j="http://richfaces.org/a4j"
xmlns:rich="http://richfaces.org/rich"
xmlns:f="http://java.sun.com/jsf/core"
xmlns:ui="http://java.sun.com/jsf/facelets">
<h:head></h:head>
<body>
<rich:panel>
<f:facet name="header">
Write your own custom rich components with built-in AJAX support
</f:facet>
<a4j:status onstart="#{rich:component('statPane')}.show()"
onstop="#{rich:component('statPane')}.hide()" />
<h:form id="form">
<rich:dataTable value="#{employeeList.resultList}" var="_employee"
iterationStatusVar="it" id="employeeList" rows="15">
<rich:column>
<f:facet name="header">ID</f:facet>
<h:outputText value="#{_employee.empid}" />
</rich:column>
<rich:column>
<f:facet name="First Name">First Name</f:facet>
<h:outputText value="#{_employee.firstname}" />
</rich:column>
<rich:column>
<f:facet name="header">Last Name</f:facet>
<h:outputText value="#{_employee.lastname}" />
</rich:column>
<rich:column>
<f:facet name="header">User Name</f:facet>
<h:outputText value="#{_employee.username}" />
</rich:column>
<rich:column>
<f:facet name="header">Password</f:facet>
<h:outputText value="#{_employee.password}" />
</rich:column>
<rich:column>
<a4j:commandLink styleClass="no-decor" execute="@this"
render="@none" oncomplete="#{rich:component('confirmPane')}.show()">
<h:graphicImage value="/images/icons/delete.gif" />
<a4j:param value="#{_employee.empid}" name="employeeEmpid"
/>
</a4j:commandLink>
<a4j:commandLink render="editGrid" execute="@form">
<h:graphicImage value="/images/icons/edit.gif" />
<a4j:param value="#{_employee.empid}" name="employeeEmpid" assignTo="#{employeeHome.instance.empid}" />
<rich:componentControl target="popup" operation="show" />
</a4j:commandLink>
</rich:column>
</rich:dataTable>
<rich:popupPanel id="statPane" autosized="true">
<h:graphicImage value="/images/ai.gif" />
Please wait...
</rich:popupPanel>
<rich:popupPanel header="Edit Car Details" id="editEmployee" domElementAttachment="parent" width="400" height="170">
<f:facet name="controls">
<h:outputLink value="#" onclick="#{rich:component('editEmployee')}.hide(); return false;">
X
</h:outputLink>
</f:facet>
<h:panelGrid columns="3" id="editGrid">
<h:outputText value="ID" />
<h:outputText value="#{employeeHome.instance.empid}" />
<h:panelGroup />
<h:outputText value="first namel" />
<h:outputText value="#{employeeHome.instance.firstname}" />
<h:panelGroup />
<h:outputText value="last name" />
<h:outputText value="#{employeeHome.instance.lastname}" />
<h:panelGroup />
<h:outputText value="user name" />
<h:outputText value="#{employeeHome.instance.username}" />
<h:panelGroup />
</h:panelGrid>
<a4j:commandButton value="Store" action="#{carsBean.store}"
render="table" execute="editPane"
oncomplete="if (#{facesContext.maximumSeverity==null}) {#{rich:component('editPane')}.hide();}" />
<a4j:commandButton value="Cancel"
onclick="#{rich:component('editPane')}.hide(); return false;" />
</rich:popupPanel>
</h:form>
</rich:panel>
</body>
</html>

Thanks

1. Re: seam 2.3 richfaces 4. Datatable with database with edit delete popup

bleathem Aug 28, 2013 4:06 PM (in response to bhaskardhone)

<a4j:commandLink render="editGrid" execute="@form">

Is your render target is not displayed at the time? Dry rendering a target wrapper around your popup. Also, you'll likely want to use the domElementAttachment of the popupPanel.
Actions
2. Re: seam 2.3 richfaces 4. Datatable with database with edit delete popup

bhaskardhone Aug 29, 2013 1:41 AM (in response to bleathem)

Hi ,
Actually I am just trying to impliment live demo sample available for richfaces4 .http://showcase.richfaces.org/richfaces/component-sample.jsf?demo=dataTable&sample=dataTableEdit&skin=blueSkyJboss richfaces Data table editing sample , with seam and oracle database.
my render target will displayed once after data is render in editgride.with domElementAttachment of the popupPanel.
Actions
3. Re: seam 2.3 richfaces 4. Datatable with database with edit delete popup

bleathem Aug 29, 2013 2:05 AM (in response to bhaskardhone)

Bhaskar Dhone wrote:

Actually I am just trying to impliment live demo sample available for richfaces4 .http://showcase.richfaces.org/richfaces/component-sample.jsf?demo=dataTable&sample=dataTableEdit&skin=blueSkyJboss richfaces Data table editing sample , with seam and oracle database.

my render target will displayed once after data is render in editgride.with domElementAttachment of the popupPanel.

Sorry, missed that.

Do you get any server errors, or any errors in your browser console?
Actions
4. Re: seam 2.3 richfaces 4. Datatable with database with edit delete popup

bhaskardhone Aug 29, 2013 2:41 AM (in response to bleathem)

no such error browser or console Able to see data in datatable from database but nothing happening on click to edit link.
Actions
5. Re: seam 2.3 richfaces 4. Datatable with database with edit delete popup

bleathem Aug 29, 2013 4:00 PM (in response to bhaskardhone)

Well, given that the showcase example works, I'd start with that. Slowly introduce changes to align the working showcase with your use case, and see if you can isolate the change that causes it to break.
Actions
6. Re: seam 2.3 richfaces 4. Datatable with database with edit delete popup

dagj Dec 17, 2013 10:56 AM (in response to bleathem)

hi, i've the same trouble using oracle database, richface 4.3 and seam 2.3, if someone know the solution or if Bhaskar Dhone could resolve this trouble plase let it here....

[javax.enterprise.resource.webcontainer.jsf.lifecycle] (http-localhost-127.0.0.1-8080-5) #{ListSelectBean.elimina}: java.lang.NullPointerException: javax.faces.FacesException: #{ListSelectBean.elimina}: java.lang.NullPointerException
at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:118) [jsf-impl-2.1.7-jbossorg-2.jar:]
at javax.faces.component.UICommand.broadcast(UICommand.java:315) [jboss-jsf-api_2.1_spec-2.0.1.Final.jar:2.0.1.Final]
at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:794) [jboss-jsf-api_2.1_spec-2.0.1.Final.jar:2.0.1.Final]
at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1259) [jboss-jsf-api_2.1_spec-2.0.1.Final.jar:2.0.1.Final]
at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:81) [jsf-impl-2.1.7-jbossorg-2.jar:]
at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101) [jsf-impl-2.1.7-jbossorg-2.jar:]
at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118) [jsf-impl-2.1.7-jbossorg-2.jar:]
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:593) [jboss-jsf-api_2.1_spec-2.0.1.Final.jar:2.0.1.Final]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329) [jbossweb-7.0.13.Final.jar:]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.13.Final.jar:]
at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:83) [jboss-seam.jar:2.3.0.Final]
at org.jboss.seam.web.LoggingFilter.doFilter(LoggingFilter.java:60) [jboss-seam.jar:2.3.0.Final]
at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69) [jboss-seam.jar:2.3.0.Final]
at org.jboss.seam.web.IdentityFilter.doFilter(IdentityFilter.java:40) [jboss-seam.jar:2.3.0.Final]
at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69) [jboss-seam.jar:2.3.0.Final]
at org.jboss.seam.web.MultipartFilter.doFilter(MultipartFilter.java:90) [jboss-seam.jar:2.3.0.Final]
at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69) [jboss-seam.jar:2.3.0.Final]
at org.jboss.seam.web.ExceptionFilter.doFilter(ExceptionFilter.java:64) [jboss-seam.jar:2.3.0.Final]
at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69) [jboss-seam.jar:2.3.0.Final]
at org.jboss.seam.web.RedirectFilter.doFilter(RedirectFilter.java:45) [jboss-seam.jar:2.3.0.Final]
at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69) [jboss-seam.jar:2.3.0.Final]
at org.jboss.seam.web.HotDeployFilter.doFilter(HotDeployFilter.java:53) [jboss-seam.jar:2.3.0.Final]
at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69) [jboss-seam.jar:2.3.0.Final]
at org.jboss.seam.servlet.SeamFilter.doFilter(SeamFilter.java:158) [jboss-seam.jar:2.3.0.Final]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) [jbossweb-7.0.13.Final.jar:]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.13.Final.jar:]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) [jbossweb-7.0.13.Final.jar:]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161) [jbossweb-7.0.13.Final.jar:]
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:397) [jbossweb-7.0.13.Final.jar:]
at org.jboss.as.jpa.interceptor.WebNonTxEmCloserValve.invoke(WebNonTxEmCloserValve.java:50) [jboss-as-jpa-7.1.1.Final.jar:7.1.1.Final]
at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153) [jboss-as-web-7.1.1.Final.jar:7.1.1.Final]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155) [jbossweb-7.0.13.Final.jar:]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [jbossweb-7.0.13.Final.jar:]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [jbossweb-7.0.13.Final.jar:]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368) [jbossweb-7.0.13.Final.jar:]
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) [jbossweb-7.0.13.Final.jar:]
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671) [jbossweb-7.0.13.Final.jar:]
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930) [jbossweb-7.0.13.Final.jar:]
at java.lang.Thread.run(Unknown Source) [rt.jar:1.7.0_45]
Caused by: javax.faces.el.EvaluationException: java.lang.NullPointerException
at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:102) [jboss-jsf-api_2.1_spec-2.0.1.Final.jar:2.0.1.Final]
at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102) [jsf-impl-2.1.7-jbossorg-2.jar:]
... 38 more
Caused by: java.lang.NullPointerException
at org.domain.fraudtrack2.session.ListSelectBean.elimina(ListSelectBean.java:51)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_45]
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) [rt.jar:1.7.0_45]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) [rt.jar:1.7.0_45]
at java.lang.reflect.Method.invoke(Unknown Source) [rt.jar:1.7.0_45]
at org.jboss.seam.util.Reflections.invoke(Reflections.java:22) [jboss-seam.jar:2.3.0.Final]
at org.jboss.seam.intercept.RootInvocationContext.proceed(RootInvocationContext.java:32) [jboss-seam.jar:2.3.0.Final]
at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:56) [jboss-seam.jar:2.3.0.Final]
at org.jboss.seam.transaction.RollbackInterceptor.aroundInvoke(RollbackInterceptor.java:28) [jboss-seam.jar:2.3.0.Final]
at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68) [jboss-seam.jar:2.3.0.Final]
at org.jboss.seam.transaction.TransactionInterceptor$1.work(TransactionInterceptor.java:97) [jboss-seam.jar:2.3.0.Final]
at org.jboss.seam.util.Work.workInTransaction(Work.java:61) [jboss-seam.jar:2.3.0.Final]
at org.jboss.seam.transaction.TransactionInterceptor.aroundInvoke(TransactionInterceptor.java:91) [jboss-seam.jar:2.3.0.Final]
at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68) [jboss-seam.jar:2.3.0.Final]
at org.jboss.seam.core.MethodContextInterceptor.aroundInvoke(MethodContextInterceptor.java:44) [jboss-seam.jar:2.3.0.Final]
at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68) [jboss-seam.jar:2.3.0.Final]
at org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:107) [jboss-seam.jar:2.3.0.Final]
at org.jboss.seam.intercept.JavaBeanInterceptor.interceptInvocation(JavaBeanInterceptor.java:186) [jboss-seam.jar:2.3.0.Final]
at org.jboss.seam.intercept.JavaBeanInterceptor.invoke(JavaBeanInterceptor.java:104) [jboss-seam.jar:2.3.0.Final]
at org.domain.fraudtrack2.session.ListSelectBean_$$_javassist_seam_3.elimina(ListSelectBean_$$_javassist_seam_3.java)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_45]
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) [rt.jar:1.7.0_45]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) [rt.jar:1.7.0_45]
at java.lang.reflect.Method.invoke(Unknown Source) [rt.jar:1.7.0_45]
at org.jboss.el.util.ReflectionUtil.invokeMethod(ReflectionUtil.java:335) [jboss-el.jar:1.0_02.CR6]
at org.jboss.el.util.ReflectionUtil.invokeMethod(ReflectionUtil.java:348) [jboss-el.jar:1.0_02.CR6]
at org.jboss.el.parser.AstPropertySuffix.invoke(AstPropertySuffix.java:58) [jboss-el.jar:1.0_02.CR6]
at org.jboss.el.parser.AstValue.invoke(AstValue.java:96) [jboss-el.jar:1.0_02.CR6]
at org.jboss.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:276) [jboss-el.jar:1.0_02.CR6]
at com.sun.faces.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:105) [jsf-impl-2.1.7-jbossorg-2.jar:]
at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88) [jboss-jsf-api_2.1_spec-2.0.1.Final.jar:2.0.1.Final]
... 39 more

That's the error i see when i try to delete, "ListSelectBean" is my bean and "elimina" my remove function.
Actions

Go to original post