List values are not bind with text fields

[Gihan Pandigamage]

hi guys,

I have a problem with my project.I'm using struts2 EJB3,oracle top link and a oracle data base.
I created a view by using four data base tables and then created a entity class for that view.
what I want to do is retrieve data by using that view and display them in a jsp page.
I retrieved data from a list by using that above view.
then when I'm going to show that data in my jsp page they are not appear in the jsp page

below is my jsp code;and "searchClienGrouptList" is my list name which I derived by using a query. my view's name is "clientView"

<s:if test="searchClienGrouptList != null && searchClienGrouptList.size()>0" >
                        <tr>
                            <td colspan="3">

                                <table border="1" align="center" cellpadding="0" cellspacing="0" width="650">
                                    <thead class="tableFont" align="center">
                                        <tr>
                                            <h3></h3>
                                        </tr>
                                        <tr>
                                            <th colspan="6" class="tableTitle" align="left">Search Results</th>
                                        </tr>
                                        <tr>
                                            <th width="80" align="center">Client Code</th>
                                            <th width="80" align="center">Client Name</th>
                                            <th width="80" align="center">NIC</th>
                                            <th width="80" align="center">Passport No</th>
                                            <th width="80" align="center">Business Reg No</th>
                                            <th width="80" align="center">Tax Reg No</th>

                                        </tr>
                                    </thead>
                                    <tbody class="tableFont">

                                        <s:iterator value="searchClienGrouptList">
                                            <tr>
                                                <td align="center"><s:url id="selectUrl" action="loadToFieldClientGroupSearchEdit">
                                                        <s:param name="idcc" value="clientcode"/>
                                                        <s:param name="searchName" value="searchName" />
                                                    </s:url>
                                                    <s:a href="%{selectUrl}" targets="searchClienGrouptList" ><s:property value="%{clientCode}" /></s:a>
                                                </td>
                                                <td> <s:property value="clientName" /></td>
                                                <td> <s:property value="clientnic" /></td>
                                                <td> <s:property value="clientpassportno" /></td>
                                                <td> <s:property value="clientbusinessregno" /></td>
                                                <td> <s:property value="clientTaxRegNo" /></td>

                                            </tr>
                                        </s:iterator>
                                    </tbody>
                                </table>
                            </td>
                        </tr>
                    </s:if>

when I'm going to load data to the jsp page below page appears.

[Bear Bibeault]

Please be sure to ask Struts questions in the Struts forum. I have moved this post there for you.

[David Newton]

Without the action code it will be essentially impossible to help.

The name of your list in the iterator tag, however, is suspicious: "searchClienGrouptList". Is that a typo?

[Gihan Pandigamage]

here is my action code

 
 findService = lookupFindServiceSessionBean();
searchClienGrouptList = (List<entity.ClientView>)findService.searchClient("ClientView",
 "clientCode", ln, "clientName", this.getClientName().trim().toUpperCase(), "clientNIC", 
 this.getClientNIC().trim().toUpperCase(), "clientPassportNo",
 this.getClientPassportNo().trim().toUpperCase(), "clientBusinessRegNo",
 this.getClientBusinessRegNo().trim().toUpperCase(), "clientTaxRegNo",
 this.getClientTaxRegNo().trim().toUpperCase(), "policyNo",
 this.getPolicyNo().trim().toUpperCase(), "vehicleNo",
 this.getVehicleNo().trim().toUpperCase(), "employeeNo",
 this.getEmployeeNo().trim().toUpperCase(), "financialInstituteBranchCode",
 this.getFinancialInstituteBranchCode().trim().toUpperCase(), "addressCity",
 this.getAddressCity().trim().toUpperCase(), "temporaryPolicyNo",
 this.getTemporaryPolicyNo().trim().toUpperCase()); 

I'm using a method called searchClient in the session bean to retrieve data from the database
if you want that code as well please inform
thanks

[David Newton]

It's a *really* bad idea to propagate spelling errors like that.

[David Newton]

Does the resulting empty table show the correct number of rows? Have you confirmed the data is being returned correctly? Is that line of code *really* that long?! 800+ chars is too long for a single line of code.

[Gihan Pandigamage]

yes I checked and double checked.I know there are spelling mistakes I changed those words for check whether it's working .
there are 31 records in the database view.and also same number of rows are appeared in the table .
I'm sending all the codes again
please help I'm stuck with this problem than 5 days.

<s:if test="searchClienGrouptList != null && searchClienGrouptList.size()>0" >
                        <tr>
                            <td colspan="6">

                                <table border="1" align="center" cellpadding="0" cellspacing="0" width="440">
                                    <thead class="tableFont" align="center">
                                        <tr>
                                            <h3></h3>
                                        </tr>
                                        <tr>
                                            <th colspan="6" class="tableTitle" align="left" height="20">Search Results</th>
                                        </tr>
                                        <tr>
                                            <th width="80" align="center">Client Code</th>
                                            <th width="80" align="center">Client Name</th>
                                            <th width="80" align="center">NIC</th>
                                            <th width="80" align="center">Passport No</th>
                                            <th width="80" align="center">Business Reg No</th>
                                            <th width="80" align="center">Tax Reg No</th>

                                        </tr>
                                    </thead>
                                    <tbody class="tableFont">
                                        <s:iterator value="searchClienGrouptList">
                                            <tr>
                                                <td align="center"><s:url id="selectUrl" action="loadToFieldClientGroupSearchEdit">
                                                        <s:param name="idcc" value="clientcode"/>
                                                        <s:param name="searchName" value="searchName" />
                                                    </s:url>
                                                    <s:a href="%{selectUrl}" targets="searchClienGrouptList" ><s:property value="%{clientcode}" /></s:a>
                                                </td>
                                               
                                                <td> <s:property value="clientname" /></td>
                                                <td> <s:property value="clientnic" /></td>
                                                <td> <s:property value="clientpassportno" /></td>
                                                <td> <s:property value="clientbusinessregno" /></td>
                                                <td> <s:property value="clienttaxregno" /></td>

                                                
                                            </tr>
                                        </s:iterator>
                                    </tbody>
                                </table>
                            </td>
                        </tr>
                    </s:if>

public String search() {
        System.out.println("inside the search client group method");
        findService = lookupFindServiceSessionBean();

        if (this.getClientcode().trim().toUpperCase().length() > 0) {
            ln = Long.parseLong(this.getClientcode().trim().toUpperCase());
        }
        
 searchClienGrouptList = findService.searchClient("ClientView", "clientcode", ln, "clientname", this.getClientname().trim().toUpperCase(), "clientnic", this.getClientnic().trim().toUpperCase(), "clientpassportno", this.getClientpassportno().trim().toUpperCase(), "clientbusinessregno", this.getClientbusinessregno().trim().toUpperCase(), "clienttaxregno", this.getClienttaxregno().trim().toUpperCase(), "policyno", this.getPolicyno().trim().toUpperCase(), "vehicleno", this.getVehicleno().trim().toUpperCase(), "employeeno", this.getEmployeeno().trim().toUpperCase(), "financialinstitutebranchcode", this.getFinancialinstitutebranchcode().trim().toUpperCase(), "addresscity", this.getAddresscity().trim().toUpperCase(), "temporarypolicyno", this.getTemporarypolicyno().trim().toUpperCase());


        //determine the result page
        if (this.getSearchName().equals("searchClientGroupAdd")) {
            return "searchClientGroupAdd";
        } else if (this.getSearchName().equals("searchClientGroupEdit")) {
            return "searchClientGroupEdit";
        } else {
            return "searchClientGroupDelete";
        }
    }

THANKS FOR HELPING...

[David Newton]

And the bean code? And the action properties?

[Gihan Pandigamage]

this is the bean code

public List<ClientView> searchClient(String strViewName, String strField1, long strPara1, String strField2, String strPara2, String strField3, String strPara3, String strField4, String strPara4, String strField5, String strPara5, String strField6, String strPara6, String strField7, String strPara7, String strField8, String strPara8, String strField9, String strPara9, String strField10, String strPara10, String strField11, String strPara11, String strField12, String strPara12) {
     
              String str = "select c.clientcode, c.clientname, c.clientnic, c.clientpassportno, c.clientbusinessregno, c.clienttaxregno,c.addresscity, c.policyno, c.vehicleno, c.employeeno, c.financialinstitutebranchcode, c.temporarypolicyno FROM " + strViewName + " c";
      
        List lstField = new ArrayList();

        if (strPara1 > 0) {
            lstField.add("c." + strField1 + " like :" + strField1);

        }
        if (strPara2.trim().length() > 0) {
            lstField.add("c." + strField2 + " like :" + strField2);
        }
        if (strPara3.trim().length() > 0) {
            lstField.add("c." + strField3 + " like :" + strField3);
        }
        if (strPara4.trim().length() > 0) {
            lstField.add("c." + strField4 + " like :" + strField4);
        }
        if (strPara5.trim().length() > 0) {
            lstField.add("c." + strField5 + " like :" + strField5);
        }
        if (strPara6.trim().length() > 0) {
            lstField.add("c." + strField6 + " like :" + strField6);
        }
        if (strPara7.trim().length() > 0) {
            lstField.add("c." + strField7 + " like :" + strField7);
        }
        if (strPara8.trim().length() > 0) {
            lstField.add("c." + strField8 + " like :" + strField8);
        }
        if (strPara9.trim().length() > 0) {
            lstField.add("c." + strField9 + " like :" + strField9);
        }
        if (strPara10.trim().length() > 0) {
            lstField.add("c." + strField10 + " like :" + strField10);
        }
        if (strPara11.trim().length() > 0) {
            lstField.add("c." + strField11 + " like :" + strField11);
        }
        if (strPara12.trim().length() > 0) {
            lstField.add("c." + strField12 + " like :" + strField12);
        }

        if (lstField.size() > 0) {
            str = str + " WHERE ";
        }
        for (int i = 0; i < lstField.size(); i++) {
            str = str + lstField.get(i) + " AND ";
        }
        if (lstField.size() > 0) {
            str = str.substring(0, str.length() - 5);
        }

        str = str + " order by c." + strField1;

        Query query = em.createQuery(str);

        if (strPara1 > 0) {
            query.setParameter(strField1, String.valueOf(strPara1));
        }
        if (strPara2.length() > 0) {
            query.setParameter(strField2, '%' + strPara2 + '%');
        }
        if (strPara3.length() > 0) {
            query.setParameter(strField3, '%' + strPara3 + '%');
        }
        if (strPara4.length() > 0) {
            query.setParameter(strField4, '%' + strPara4 + '%');
        }
        if (strPara5.length() > 0) {
            query.setParameter(strField5, '%' + strPara5 + '%');
        }

        if (strPara6.length() > 0) {
            query.setParameter(strField6, '%' + strPara6 + '%');
        }
        if (strPara7.length() > 0) {
            query.setParameter(strField7, '%' + strPara7 + '%');
        }

        if (strPara8.length() > 0) {
            query.setParameter(strField8, '%' + strPara8 + '%');
        }

        if (strPara9.length() > 0) {
            query.setParameter(strField9, '%' + strPara9 + '%');
        }

        if (strPara10.length() > 0) {
            query.setParameter(strField10, '%' + strPara10 + '%');
        }
        if (strPara11.length() > 0) {
            query.setParameter(strField11, '%' + strPara11 + '%');
        }

        if (strPara12.length() > 0) {
            query.setParameter(strField12, '%' + strPara12 + '%');
        }


              return query.getResultList();
    }

what do you mean by action properties
is it my action's getters and setters??

[David Newton]

That's not the bean code, that's the code that retrieves thelist.

[Gihan Pandigamage]

thanks guys..
the problem was solved
there was a little mistake

thanks lot for helping ...
THANKS...