Problem in Editing Table Data

[Maryam Nouhnejad]

I'm trying to edit some data in a table. The database result appears in the table (with a check box next to each row) but when I click on the check box this exception occurs :

  
com.sun.faces.lifecycle.ProcessValidationsPhase execute
SEVERE: Error testing property 'fullName' in bean of type null
javax.faces.el.PropertyNotFoundException: Error testing property 'fullName' in bean of type null
        at com.sun.faces.el.PropertyResolverImpl.getType(PropertyResolverImpl.java:342)
        at com.sun.rave.faces.data.ResultSetPropertyResolver.getType(ResultSetPropertyResolver.java:145)
        at com.sun.faces.el.impl.ArraySuffix.getType(ArraySuffix.java:240)
        at com.sun.faces.el.impl.ComplexValue.getType(ComplexValue.java:208)
        at com.sun.faces.el.ValueBindingImpl.getType(ValueBindingImpl.java:345)
        at com.sun.faces.renderkit.html_basic.HtmlBasicInputRenderer.getConvertedValue(HtmlBasicInputRenderer.java:111)
        at javax.faces.component.UIInput.getConvertedValue(UIInput.java:713)
        at javax.faces.component.UIInput.validate(UIInput.java:638)
        at javax.faces.component.UIInput.executeValidate(UIInput.java:849)
        at javax.faces.component.UIInput.processValidators(UIInput.java:412)
        at javax.faces.component.UIData.iterate(UIData.java:977)
        at javax.faces.component.UIData.processValidators(UIData.java:786)
        at javax.faces.component.UIForm.processValidators(UIForm.java:170)
        at javax.faces.component.UIComponentBase.processValidators(UIComponentBase.java:912)
        at javax.faces.component.UIViewRoot.processValidators(UIViewRoot.java:342)
        at com.sun.faces.lifecycle.ProcessValidationsPhase.execute(ProcessValidationsPhase.java:78)
        at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:200)
        at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:90)
        at javax.faces.webapp.FacesServlet.service(FacesServlet.java:197)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
        at org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:368)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
        at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
        at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
        at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
        at java.lang.Thread.run(Thread.java:595)  

Here are my source codes :

TableData.java :

  public class TableData { 
   
    private static int SIZE_USERS = 0;  
    
    private ArrayDataModel model2 = null;
 
    /** Creates a new instance of TableData */
    public TableData() { 
        
        UserManager obj2 = new UserManager();
        ArrayList users = obj2.listOfUsers();  
        String[] listU = new String[users.size()];
        users.toArray(listU);
        System.out.println(listU.length);
        SIZE_USERS = users.size();
        userBean = new UserBean[SIZE_USERS];
        for(int i=0,j=0; i<listU.length; i++,j++) {
            
            userBean[j] = new UserBean();
            userBean[j].setFullName(listU[i]);
            userBean[j].setEmail(listU[i+1]);
            userBean[j].setJob(listU[i+1]);
            i+=2;
        }
       
        model2 = new ArrayDataModel(userBean);
    } 
   
   public UserLogs[] getUserLogs() {
       return userLogs;   
   }
    public DataModel getNames() {
       return model2; 
   }
   
   private static UserBean[] userBean;
 
   public UserBean[] getUserBean() {
       return userBean;
   }
   
}
  

UserBean.java :

  private int id;
   private String fullName;
   private String password;
   private String date;
   private String job;
   private String email;
   private boolean editable;
 
public UserBean(String fullName, String job, String email) {
      this.fullName=fullName;
      this.job=job;
      this.email=email;
   }
 
// PROPERTY: full name
   public String getFullName() {
       return fullName; 
   }
   public void setFullName(String newValue) {
      this. fullName = newValue; 
   }  

Please tell me what I should do.

Thanks in advance,
Maryam

[Maryam Nouhnejad]

editUsers.jsp :

  <f:view>
      <head>
         <title>
            <f:loadBundle basename="i18n.ApplicationResource" var="msgs"/>
            <h:outputText value="#{msgs.editUsers}"/>
         </title>  
      </head>
      <body>
           
           <h:form>
            <h:dataTable value="#{tableData.userBean}" var="userBean">
               <h:column>
                  <f:facet name="header">
                     <h:outputText value="#{msgs.edit}"   
                        style="font-weight: bold"/>
                  </f:facet>
                    <h:selectBooleanCheckbox value="#{userBean.editable}" 
                     on click="submit()"/>
               </h:column>
               <h:column></h:column><h:column></h:column>
               <h:column>
                  <f:facet name="header">
                     <h:outputText value="#{msgs.fullName}" 
                        style="font-weight: bold"/>
                  </f:facet>
                  <h:inputText value="#{userBean.fullName}" rendered="#{userBean.editable}" 
                     size="10"/>
                  <h:outputText value="#{userBean.fullName}" 
                     rendered="#{not userBean.editable}"/>
               </h:column>
               
               <h:column>
                  <f:facet name="header">
                     <h:outputText value="#{msgs.email}" 
                        style="font-weight: bold"/>
                  </f:facet>
                  <h:inputText value="#{userBean.email}" 
                     rendered="#{userBean.editable}" size="10"/>
                  <h:outputText value="#{userBean.email}" 
                     rendered="#{not userBean.editable}"/>
               </h:column>
               
               <h:column>
                  <f:facet name="header">
                     <h:outputText value="#{msgs.job}" 
                        style="font-weight: bold"/>
                  </f:facet>
                  <h:inputText value="#{userBean.job}" 
                     rendered="#{userBean.editable}" size="10"/>  
                  <h:outputText value="#{userBean.job}"   
                     rendered="#{not userBean.editable}"/>
               </h:column>
               
            </h:dataTable>
         </h:form>
         
        
      </body>
   </f:view>  

[ June 12, 2007: Message edited by: Maryam Nouhnejad ]

[Maryam Nouhnejad]

Please somebody help me!

[Gabriel Claramunt]

Look at the exception:
SEVERE: Error testing property 'fullName' in bean of type null

Somehow, when you are iterating over the collection, you have a null userBean.
Probably you need to do some debugging...
[ June 12, 2007: Message edited by: Gabriel Claramunt ]

[Maryam Nouhnejad]

I could solve my problm. Actually the number of rows in database was 26 but when I counted the number of rows printed in the web page I saw that it's 78 (26*3)...it was related to my array data; when I corrected the SIZE_USERS to :

        SIZE_USERS = users.size();
        SIZE_USERS /= 3;     

and added them to my code (TableData.java) under

  users.toArray(listU);  

It worked and there were no more exceptions.



Now, I can edit the user information in the web page but how can I add the changes to the database? ... I mean if I have a submit edit button for all rows, how can I check which rows were changed?


Please guide me!

Thank you,
Maryam

[Maryam Nouhnejad]

Please help me for the last question!

Thank you!

[a]

Hi,
bind the dataTable to a HtmlDataTable attribute to get the selected row. Here a link how you can solve this problem: BalusC-Link

[Maryam Nouhnejad]

Thank you for the link!

I read it and added the code to my project.

Now I have a column like this & I want to save the changes (after editing) to database :

  <h:column>
                       <f:facet name="header">
                           <h:outputText value="#{msgs.fullName}" 
                                         style="font-weight: bold"/>
                       </f:facet>
                       <h:inputText value="#{userBean.fullName}" rendered="#{userBean.editable}" 
                                    size="10"/>
                                    <h:commandButton action="tableData.saveEditedRow" value="save">
                                        <h:outputText value="#{userBean.fullName}" 
                                                      rendered="#{not userBean.editable}"/>
                                    </h:commandButton>  
                </h:column>  

but first I want to be sure the saveEditedRow can be called.


These are the methods I added to my TableData.java :

  public String saveEditedRow() {  
     
      user = (UserBean) getMyDataTable().getRowData();
      System.out.println("user info : " + user.getEmail() 
        + user.getJob() + user.getFullName());
 
      return "success";
   }  
   
   // Getters ----------------------------------------------------------
 
    public HtmlDataTable getMyDataTable() {
        return myDataTable;
    }
 
    public UserBean getMyDataItem() {
        return user;
    }
 
    // Setters ----------------------------------------------------------
 
    public void setMyDataTable(HtmlDataTable myDataTable) {
        this.myDataTable = myDataTable;
    }
 
    public void setMyDataItem(UserBean user) {
        this.user = user;
    }
  

... but nothing happens. There is no exception and nothing is printed in my console. Do you know why?

[Maryam Nouhnejad]

Any idea is appreciated!

[Maryam Nouhnejad]

Please help me!!

[Maryam Nouhnejad]

I could solve my problem.
The problem was that I should write

  <h:commandButton action="#{tableData.saveEditedRow}" value="save">  

instead of

  <h:commandButton action="tableData.saveEditedRow" value="save">  

Maryam