Do Not Seem to be pulling the Most Current Data from Database (JSF, Hibernate)

[Phoenix Kilimba]

Dear Sirs et Madames,
I have an application which renders a tabled list of system users (using Visual Web JSF). However when I delete a user/s even though the database will show the changes (users gone, non existent), when I rerun the application, it seems to render the table with the users still there, even though it should be pulling the data from the database. What could I be doing wrong? here is the bean code:

  package codered;

import com.sun.rave.web.ui.appbase.AbstractPageBean;
import com.sun.webui.jsf.component.Button;
import com.sun.webui.jsf.component.StaticText;
import java.util.ArrayList;
import java.util.List;
import javax.faces.FacesException;
import org.jhpiego.businesslogic.UserBusinessLogic;
import org.jhpiego.vo.UserVO;

/**
 * <p>Page bean that corresponds to a similarly named JSP page.  This
 * class contains component definitions (and initialization code) for
 * all components that you have defined on this page, as well as
 * lifecycle methods and event handlers where you may add behavior
 * to respond to incoming events.</p>
 *
 * @version JhpiegoTemplate.java
 * @version Created on Apr 26, 2009, 2:58:44 PM
 * @author Administrator
 */
public class ViewOrEditUser extends AbstractPageBean {
    // <editor-fold defaultstate="collapsed" desc="Managed Component Definition">

    /**
     * <p>Automatically managed component initialization.  <strong>WARNING:</strong>
     * This method is automatically generated, so any user-specified code inserted
     * here is subject to being replaced.</p>
     */
    private void _init() throws Exception {
    }
    // </editor-fold>
    private List<UserVO> userVOList;
    private UserVO[] userVOArray;
    private List<UserVO> selectedForDeletionList;

    public UserVO[] getUserVOArray() {
        return userVOArray;
    }

    public void setUserVOArray(UserVO[] userVOArray) {
        this.userVOArray = userVOArray;
    }

    public List<UserVO> getUserVOList() {
        return userVOList;
    }

    public void setUserVOList(List<UserVO> userVOList) {
        this.userVOList = userVOList;
    }
    private Button editButton = new Button();

    public Button getEditButton() {
        return editButton;
    }

    public void setEditButton(Button b) {
        this.editButton = b;
    }
    private Button deleteButton = new Button();

    public Button getDeleteButton() {
        return deleteButton;
    }

    public void setDeleteButton(Button b) {
        this.deleteButton = b;
    }
    private StaticText errorMessage = new StaticText();

    public StaticText getErrorMessage() {
        return errorMessage;
    }

    public void setErrorMessage(StaticText st) {
        this.errorMessage = st;
    }

    /**
     * <p>Construct a new Page bean instance.</p>
     */
    public ViewOrEditUser() {
    }

    private String getUsersSelectedForDeletion() {
        getSessionBean1().setUsersToBeDeleted(null);
        selectedForDeletionList = new ArrayList();
        for (UserVO user : userVOList) {

            //If user is selected for deletion (checkbox) and is not the currently
            //logged in user (preventing deletion of self):
            if (user.isToBeDeleted()) {
                //message.setText("user found " + user.isSelectedForDeletion());
                if (//!user.getUserId().equals(getSessionBean1().getLoggedInUser().
                        //getUserId())
                        1 > 0) {
                    selectedForDeletionList.add(user);
                    user.setToBeDeleted(false);

                } else {
                    System.out.println("######### HEEEY! WATCH IT BUDDY! " +
                            "YOU ALMOST DELETED YOURSELF!!! ###### ");
                    errorMessage.setText("You cannot delete yourself am afraid...");
                    return null;
                //message2.setText("Gotcha - your own name");
                }
            }
        // message3.setText("Now checking user " + user.getFirstName());
        }
        getSessionBean1().setUsersToBeDeleted(selectedForDeletionList);
        return "deleteUser";
    }

    private void getUserSelectedForEditing() {
        for (UserVO user : userVOList) {
            if (user.isToBeEdited()) {
                getSessionBean1().setUserToBeEdited(user);
            }
        }
    }

    private void buildUserTable() {
        
        userVOList = new UserBusinessLogic().getUsersAsVOs();
        userVOArray = new UserVO[userVOList.size()];

        int i = 0;
        for (UserVO user : userVOList) {
            userVOArray[i] = user;
            i++;

            setUserVOArray(userVOArray);
        }
    }

    /**
     * <p>Callback method that is called whenever a page is navigated to,
     * either directly via a URL, or indirectly via page navigation.
     * Customize this method to acquire resources that will be needed
     * for event handlers and lifecycle methods, whether or not this
     * page is performing post back processing.</p>
     *
     * <p>Note that, if the current request is a postback, the property
     * values of the components do <strong>not</strong> represent any
     * values submitted with this request.  Instead, they represent the
     * property values that were saved for this view when it was rendered.</p>
     */
    @Override
    public void init() {
        // Perform initializations inherited from our superclass
        super.init();
        // Perform application initialization that must complete
        // *before* managed components are initialized
        // TODO - add your own initialiation code here
        buildUserTable();
        // <editor-fold defaultstate="collapsed" desc="Managed Component Initialization">
        // Initialize automatically managed components
        // *Note* - this logic should NOT be modified
        try {
            _init();
        } catch (Exception e) {
            log("JhpiegoTemplate Initialization Failure", e);
            throw e instanceof FacesException ? (FacesException) e : new FacesException(e);
        }

    // </editor-fold>
    // Perform application initialization that must complete
    // *after* managed components are initialized
    // TODO - add your own initialization code here
    }

    /**
     * <p>Callback method that is called after the component tree has been
     * restored, but before any event processing takes place.  This method
     * will <strong>only</strong> be called on a postback request that
     * is processing a form submit.  Customize this method to allocate
     * resources that will be required in your event handlers.</p>
     */
    @Override
    public void preprocess() {
    }

    /**
     * <p>Callback method that is called just before rendering takes place.
     * This method will <strong>only</strong> be called for the page that
     * will actually be rendered (and not, for example, on a page that
     * handled a postback and then navigated to a different page).  Customize
     * this method to allocate resources that will be required for rendering
     * this page.</p>
     */
    @Override
    public void prerender() {
    }

    /**
     * <p>Callback method that is called after rendering is completed for
     * this request, if <code>init()</code> was called (regardless of whether
     * or not this was the page that was actually rendered).  Customize this
     * method to release resources acquired in the <code>init()</code>,
     * <code>preprocess()</code>, or <code>prerender()</code> methods (or
     * acquired during execution of an event handler).</p>
     */
    @Override
    public void destroy() {
    }

    /**
     * <p>Return a reference to the scoped data bean.</p>
     *
     * @return reference to the scoped data bean
     */
    protected RequestBean1 getRequestBean1() {
        return (RequestBean1) getBean("RequestBean1");
    }

    /**
     * <p>Return a reference to the scoped data bean.</p>
     *
     * @return reference to the scoped data bean
     */
    protected ApplicationBean1 getApplicationBean1() {
        return (ApplicationBean1) getBean("ApplicationBean1");
    }

    /**
     * <p>Return a reference to the scoped data bean.</p>
     *
     * @return reference to the scoped data bean
     */
    protected SessionBean1 getSessionBean1() {
        return (SessionBean1) getBean("SessionBean1");
    }

    public String editButton_action() {
        getUserSelectedForEditing();
        return "edit";
    }

    public String deleteButton_action() {
        getUsersSelectedForDeletion();
        return "delete";
    }
}

  

The JSF code

<?xml version="1.0" encoding="UTF-8"?>
<!--
    Document   : JhpiegoTemplate
    Created on : Apr 26, 2009, 2:58:43 PM
    Author     : Administrator
-->
<jsp:root version="2.1" xmlns:f="http://java.sun.com/jsf/core" xmlns:h="http://java.sun.com/jsf/html" xmlns:jsp="http://java.sun.com/JSP/Page" xmlns:webuijsf="http://www.sun.com/webui/webuijsf">
    <jsp:directive.page contentType="text/html;charset=UTF-8" pageEncoding="UTF-8"/>
    <f:view>
        <webuijsf:page id="page1">
            <webuijsf:html id="html1">
                <webuijsf:head id="head1">
                    <webuijsf:link id="link1" url="/resources/stylesheet.css"/>
                </webuijsf:head>
                <webuijsf:body id="body1" style="background-color: rgb(51, 51, 51); -rave-layout: grid">
                    <webuijsf:form id="form1">
                        <div style="left: 264px; top: 0px; position: absolute">
                            <jsp:directive.include file="Header.jspf"/>
                        </div>
                        <div style="left: 264px; top: 144px; position: absolute">
                            <jsp:directive.include file="Navigator.jspf"/>
                        </div>
                        <webuijsf:table augmentTitle="false" id="table1" paginateButton="true" paginationControls="true"
                            style="left: 456px; top: 144px; position: absolute" width="576">
                            <webuijsf:tableRowGroup id="tableRowGroup1" rows="10" sourceData="#{ViewOrEditUser.userVOArray}" sourceVar="currentRow">
                                <webuijsf:tableColumn headerText="Title" id="tableColumn1" sort="title">
                                    <webuijsf:staticText id="staticText1" text="#{currentRow.value['title']}"/>
                                </webuijsf:tableColumn>
                                <webuijsf:tableColumn headerText="First Name" id="tableColumn2" sort="firstName">
                                    <webuijsf:staticText id="staticText2" text="#{currentRow.value['firstName']}"/>
                                </webuijsf:tableColumn>
                                <webuijsf:tableColumn headerText="Last Name" id="tableColumn3" sort="lastName">
                                    <webuijsf:staticText id="staticText3" text="#{currentRow.value['lastName']}"/>
                                </webuijsf:tableColumn>
                                <webuijsf:tableColumn headerText="Check to Edit" id="tableColumn6" sort="toBeEdited">
                                    <webuijsf:checkbox id="checkbox1" selected="#{currentRow.value['toBeEdited']}"/>
                                </webuijsf:tableColumn>
                                <webuijsf:tableColumn headerText="Check to Delete" id="tableColumn7" sort="toBeDeleted">
                                    <webuijsf:checkbox id="checkbox2" selected="#{currentRow.value['toBeDeleted']}"/>
                                </webuijsf:tableColumn>
                            </webuijsf:tableRowGroup>
                        </webuijsf:table>
                        <webuijsf:button actionExpression="#{ViewOrEditUser.editButton_action}" binding="#{ViewOrEditUser.editButton}" id="editButton"
                            style="font-weight: bold; left: 600px; top: 528px; position: absolute; width: 95px" text="EDIT"/>
                        <webuijsf:button actionExpression="#{ViewOrEditUser.deleteButton_action}" binding="#{ViewOrEditUser.deleteButton}" id="deleteButton"
                            style="font-weight: bold; left: 792px; top: 528px; position: absolute; width: 95px" text="DELETE"/>
                        <webuijsf:staticText binding="#{ViewOrEditUser.errorMessage}" id="errorMessage" style="color: red; font-family: 'Courier New',Courier,monospace; left: 936px; top: 528px; position: absolute"/>
                    </webuijsf:form>
                </webuijsf:body>
            </webuijsf:html>
        </webuijsf:page>
    </f:view>
</jsp:root>
    

Could someone please let me know why I am pulling stale data that should not/does not exist anymore? How do I solve this issue?

Thanks kindly in advance,

[Shivaji Byrapaneni]

i cant see you updating 'userVOArray' from where the data table is picking up the values.

plese do that to see the cahage.

[Phoenix Kilimba]

Hello, thanks for the response, but I dont understand what you mean.... Everytimethe page loads the

 init() 

should run, and in my init() method I call

 buildUserTable()   

which in turn calls

  new UserBusinessLogic().getUsersAsVOs();  

which should pull data direct from database. So , yes I AM updating userVOArray where the table is picking up values everytime the page loads...

However I still have the issue. Help?

Thanks in advance,

[Shivaji Byrapaneni]

is your init getting triggered after you had updated the values in the datatable...?

[Phoenix Kilimba]

Thanks Shivaji, no its not. But what would be the significance of this if that WAS the case?