3 Replies Latest reply: Dec 1, 2012 4:20 AM by Tshifhiwa RSS

    child table displaying record as duplicate

    Tshifhiwa
      hi i have a situation where my table is displaying record as duplicate but when i check in the database i only have single record for that record which is been dispaly as duplicate in my application am in jdeveloper 11.1.2.1.0
      my table is
      <af:table value="#{bindings.smsmoduleVO1.collectionModel}" var="row"
                                                rows="#{bindings.smsmoduleVO1.rangeSize}"
                                                emptyText="#{bindings.smsmoduleVO1.viewable ? 'No data to display.' : 'Access Denied.'}"
                                                fetchSize="#{bindings.smsmoduleVO1.rangeSize}" rowBandingInterval="0"
                                                selectedRowKeys="#{bindings.smsmoduleVO1.collectionModel.selectedRow}"
                                                selectionListener="#{bindings.smsmoduleVO1.collectionModel.makeCurrent}" id="t2" partialTriggers="::cb2 ::t1" columnStretching="last">
                                          <af:column sortProperty="#{bindings.smsmoduleVO1.hints.DisplaySeq.name}"
                                                     sortable="false"
                                                     headerText="#{bindings.smsmoduleVO1.hints.DisplaySeq.label}" id="c3"
                                                     width="62">
                                              <af:inputText value="#{row.bindings.DisplaySeq.inputValue}"
                                                            label="#{bindings.smsmoduleVO1.hints.DisplaySeq.label}"
                                                            required="#{bindings.smsmoduleVO1.hints.DisplaySeq.mandatory}"
                                                            columns="#{bindings.smsmoduleVO1.hints.DisplaySeq.displayWidth}"
                                                            maximumLength="#{bindings.smsmoduleVO1.hints.DisplaySeq.precision}"
                                                            shortDesc="#{bindings.smsmoduleVO1.hints.DisplaySeq.tooltip}"
                                                            id="it4">
                                                  <f:validator binding="#{row.bindings.DisplaySeq.validator}"/>
                                                  <af:convertNumber groupingUsed="false"
                                                                    pattern="#{bindings.smsmoduleVO1.hints.DisplaySeq.format}"/>
                                              </af:inputText>
                                          </af:column>
                                          <af:column sortProperty="#{bindings.smsmoduleVO1.hints.Name.name}" sortable="false"
                                                     headerText="#{bindings.smsmoduleVO1.hints.Name.label}" id="c4"
                                                     width="148">
                                              <af:inputText value="#{row.bindings.Name.inputValue}"
                                                            label="#{bindings.smsmoduleVO1.hints.Name.label}"
                                                            required="#{bindings.smsmoduleVO1.hints.Name.mandatory}"
                                                            columns="#{bindings.smsmoduleVO1.hints.Name.displayWidth}"
                                                            maximumLength="#{bindings.smsmoduleVO1.hints.Name.precision}"
                                                            shortDesc="#{bindings.smsmoduleVO1.hints.Name.tooltip}" id="it5">
                                                  <f:validator binding="#{row.bindings.Name.validator}"/>
                                              </af:inputText>
                                          </af:column>
                                          <af:column sortProperty="#{bindings.smsmoduleVO1.hints.AmtypType.name}"
                                                     sortable="false"
                                                     headerText="#{bindings.smsmoduleVO1.hints.AmtypType.label}" id="c5"
                                                     width="105">
                                              <af:inputText value="#{row.bindings.AmtypType.inputValue}"
                                                            label="#{bindings.smsmoduleVO1.hints.AmtypType.label}"
                                                            required="#{bindings.smsmoduleVO1.hints.AmtypType.mandatory}"
                                                            columns="#{bindings.smsmoduleVO1.hints.AmtypType.displayWidth}"
                                                            maximumLength="#{bindings.smsmoduleVO1.hints.AmtypType.precision}"
                                                            shortDesc="#{bindings.smsmoduleVO1.hints.AmtypType.tooltip}"
                                                            id="it6">
                                                  <f:validator binding="#{row.bindings.AmtypType.validator}"/>
                                              </af:inputText>
                                          </af:column>
                                          <af:column sortProperty="#{bindings.smsmoduleVO1.hints.Description.name}"
                                                     sortable="false"
                                                     headerText="#{bindings.smsmoduleVO1.hints.Description.label}" id="c6"
                                                     width="105">
                                              <af:inputText value="#{row.bindings.Description.inputValue}"
                                                            label="#{bindings.smsmoduleVO1.hints.Description.label}"
                                                            required="#{bindings.smsmoduleVO1.hints.Description.mandatory}"
                                                            columns="#{bindings.smsmoduleVO1.hints.Description.displayWidth}"
                                                            maximumLength="#{bindings.smsmoduleVO1.hints.Description.precision}"
                                                            shortDesc="#{bindings.smsmoduleVO1.hints.Description.tooltip}"
                                                            id="it7">
                                                  <f:validator binding="#{row.bindings.Description.validator}"/>
                                              </af:inputText>
                                          </af:column>
                                          <af:column sortProperty="#{bindings.smsmoduleVO1.hints.ReportLevel.name}"
                                                     sortable="false"
                                                     headerText="#{bindings.smsmoduleVO1.hints.ReportLevel.label}" id="c7"
                                                     width="120">
                                              <af:inputText value="#{row.bindings.ReportLevel.inputValue}"
                                                            label="#{bindings.smsmoduleVO1.hints.ReportLevel.label}"
                                                            required="#{bindings.smsmoduleVO1.hints.ReportLevel.mandatory}"
                                                            columns="#{bindings.smsmoduleVO1.hints.ReportLevel.displayWidth}"
                                                            maximumLength="#{bindings.smsmoduleVO1.hints.ReportLevel.precision}"
                                                            shortDesc="#{bindings.smsmoduleVO1.hints.ReportLevel.tooltip}"
                                                            id="it8">
                                                  <f:validator binding="#{row.bindings.ReportLevel.validator}"/>
                                              </af:inputText>
                                          </af:column>
                                      </af:table>
      my parent table is
      <?xml version='1.0' encoding='UTF-8'?>
      <jsp:root xmlns:jsp="http://java.sun.com/JSP/Page" version="2.1" xmlns:af="http://xmlns.oracle.com/adf/faces/rich"
                xmlns:f="http://java.sun.com/jsf/core">
          <af:panelStretchLayout id="psl1" inlineStyle="background-color:Background;">
              <f:facet name="center">
                  <af:panelStretchLayout id="psl2" startWidth="242px" bottomHeight="124px"
                                         inlineStyle="background-color:Background;">
                      <f:facet name="center">
                          <af:panelHeader text="Application Modules" id="ph2"
                                          inlineStyle="height:500px; background-color:Background; border-color:Navy; border-style:ridge;">
                              <f:facet name="context"/>
                              <f:facet name="menuBar"/>
                              <f:facet name="toolbar">
                                  <af:toolbar id="t3">
                                      <af:commandButton actionListener="#{bindings.CreateInsert.execute}" text="CreateInsert" id="cb2"/>
                                      <af:commandButton actionListener="#{bindings.Commit.execute}" text="Save" id="cb1"/>
                                  </af:toolbar>
                              </f:facet>
                              <f:facet name="legend"/>
                              <f:facet name="info"/>
                              <af:panelStretchLayout id="psl3" bottomHeight="52px" startWidth="56px"
                                                     inlineStyle="width:1032px; height:360px; border-color:Navy;">
                                  <f:facet name="center">
                                      <af:table value="#{bindings.smsmoduleVO1.collectionModel}" var="row"
                                                rows="#{bindings.smsmoduleVO1.rangeSize}"
                                                emptyText="#{bindings.smsmoduleVO1.viewable ? 'No data to display.' : 'Access Denied.'}"
                                                fetchSize="#{bindings.smsmoduleVO1.rangeSize}" rowBandingInterval="0"
                                                selectedRowKeys="#{bindings.smsmoduleVO1.collectionModel.selectedRow}"
                                                selectionListener="#{bindings.smsmoduleVO1.collectionModel.makeCurrent}" id="t2" partialTriggers="::cb2 ::t1" columnStretching="last">
                                          <af:column sortProperty="#{bindings.smsmoduleVO1.hints.DisplaySeq.name}"
                                                     sortable="false"
                                                     headerText="#{bindings.smsmoduleVO1.hints.DisplaySeq.label}" id="c3"
                                                     width="62">
                                              <af:inputText value="#{row.bindings.DisplaySeq.inputValue}"
                                                            label="#{bindings.smsmoduleVO1.hints.DisplaySeq.label}"
                                                            required="#{bindings.smsmoduleVO1.hints.DisplaySeq.mandatory}"
                                                            columns="#{bindings.smsmoduleVO1.hints.DisplaySeq.displayWidth}"
                                                            maximumLength="#{bindings.smsmoduleVO1.hints.DisplaySeq.precision}"
                                                            shortDesc="#{bindings.smsmoduleVO1.hints.DisplaySeq.tooltip}"
                                                            id="it4">
                                                  <f:validator binding="#{row.bindings.DisplaySeq.validator}"/>
                                                  <af:convertNumber groupingUsed="false"
                                                                    pattern="#{bindings.smsmoduleVO1.hints.DisplaySeq.format}"/>
                                              </af:inputText>
                                          </af:column>
                                          <af:column sortProperty="#{bindings.smsmoduleVO1.hints.Name.name}" sortable="false"
                                                     headerText="#{bindings.smsmoduleVO1.hints.Name.label}" id="c4"
                                                     width="148">
                                              <af:inputText value="#{row.bindings.Name.inputValue}"
                                                            label="#{bindings.smsmoduleVO1.hints.Name.label}"
                                                            required="#{bindings.smsmoduleVO1.hints.Name.mandatory}"
                                                            columns="#{bindings.smsmoduleVO1.hints.Name.displayWidth}"
                                                            maximumLength="#{bindings.smsmoduleVO1.hints.Name.precision}"
                                                            shortDesc="#{bindings.smsmoduleVO1.hints.Name.tooltip}" id="it5">
                                                  <f:validator binding="#{row.bindings.Name.validator}"/>
                                              </af:inputText>
                                          </af:column>
                                          <af:column sortProperty="#{bindings.smsmoduleVO1.hints.AmtypType.name}"
                                                     sortable="false"
                                                     headerText="#{bindings.smsmoduleVO1.hints.AmtypType.label}" id="c5"
                                                     width="105">
                                              <af:inputText value="#{row.bindings.AmtypType.inputValue}"
                                                            label="#{bindings.smsmoduleVO1.hints.AmtypType.label}"
                                                            required="#{bindings.smsmoduleVO1.hints.AmtypType.mandatory}"
                                                            columns="#{bindings.smsmoduleVO1.hints.AmtypType.displayWidth}"
                                                            maximumLength="#{bindings.smsmoduleVO1.hints.AmtypType.precision}"
                                                            shortDesc="#{bindings.smsmoduleVO1.hints.AmtypType.tooltip}"
                                                            id="it6">
                                                  <f:validator binding="#{row.bindings.AmtypType.validator}"/>
                                              </af:inputText>
                                          </af:column>
                                          <af:column sortProperty="#{bindings.smsmoduleVO1.hints.Description.name}"
                                                     sortable="false"
                                                     headerText="#{bindings.smsmoduleVO1.hints.Description.label}" id="c6"
                                                     width="105">
                                              <af:inputText value="#{row.bindings.Description.inputValue}"
                                                            label="#{bindings.smsmoduleVO1.hints.Description.label}"
                                                            required="#{bindings.smsmoduleVO1.hints.Description.mandatory}"
                                                            columns="#{bindings.smsmoduleVO1.hints.Description.displayWidth}"
                                                            maximumLength="#{bindings.smsmoduleVO1.hints.Description.precision}"
                                                            shortDesc="#{bindings.smsmoduleVO1.hints.Description.tooltip}"
                                                            id="it7">
                                                  <f:validator binding="#{row.bindings.Description.validator}"/>
                                              </af:inputText>
                                          </af:column>
                                          <af:column sortProperty="#{bindings.smsmoduleVO1.hints.ReportLevel.name}"
                                                     sortable="false"
                                                     headerText="#{bindings.smsmoduleVO1.hints.ReportLevel.label}" id="c7"
                                                     width="120">
                                              <af:inputText value="#{row.bindings.ReportLevel.inputValue}"
                                                            label="#{bindings.smsmoduleVO1.hints.ReportLevel.label}"
                                                            required="#{bindings.smsmoduleVO1.hints.ReportLevel.mandatory}"
                                                            columns="#{bindings.smsmoduleVO1.hints.ReportLevel.displayWidth}"
                                                            maximumLength="#{bindings.smsmoduleVO1.hints.ReportLevel.precision}"
                                                            shortDesc="#{bindings.smsmoduleVO1.hints.ReportLevel.tooltip}"
                                                            id="it8">
                                                  <f:validator binding="#{row.bindings.ReportLevel.validator}"/>
                                              </af:inputText>
                                          </af:column>
                                      </af:table>
                                  </f:facet>
                              </af:panelStretchLayout>
                          </af:panelHeader>
                      </f:facet>
                      <f:facet name="start">
                          <af:panelGroupLayout layout="scroll" id="pgl1"
                                               inlineStyle="background-color:Background;width:250px;height:500px;">
                              <af:panelHeader text="Area" id="ph1"
                                              inlineStyle="width:219px; border-color:Navy; border-style:ridge; height:381px;">
                                  <f:facet name="context"/>
                                  <f:facet name="menuBar"/>
                                  <f:facet name="toolbar">
                                      <af:toolbar id="t4">
                                          <af:commandButton actionListener="#{bindings.CreateInsert1.execute}"
                                                            text="CreateInsert1"
                                                            id="cb3"/>
                                          <af:commandButton actionListener="#{bindings.Commit.execute}" text="save" id="cb4"/>
                                      </af:toolbar>
                                  </f:facet>
                                  <f:facet name="legend"/>
                                  <f:facet name="info"/>
                                  <af:panelFormLayout id="pfl1" rows="10" labelAlignment="top" maxColumns="10"
                                                      inlineStyle="width:192px;">
                                      <af:table value="#{bindings.SmsModuleAreasView11.collectionModel}" var="row"
                                                rows="#{bindings.SmsModuleAreasView11.rangeSize}"
                                                emptyText="#{bindings.SmsModuleAreasView11.viewable ? 'No data to display.' : 'Access Denied.'}"
                                                fetchSize="#{bindings.SmsModuleAreasView11.rangeSize}" rowBandingInterval="0"
                                                selectedRowKeys="#{bindings.SmsModuleAreasView11.collectionModel.selectedRow}"
                                                selectionListener="#{bindings.SmsModuleAreasView11.collectionModel.makeCurrent}"
                                                rowSelection="single" id="t1" partialTriggers="::cb3"
                                                inlineStyle="height:226px;width:200px;">
                                          <af:column sortProperty="#{bindings.SmsModuleAreasView11.hints.DisplaySeq.name}"
                                                     sortable="false"
                                                     headerText="Seq"
                                                     id="c2" width="40">
                                              <af:inputText value="#{row.bindings.DisplaySeq.inputValue}"
                                                            label="#{bindings.SmsModuleAreasView11.hints.DisplaySeq.label}"
                                                            required="#{bindings.SmsModuleAreasView11.hints.DisplaySeq.mandatory}"
                                                            columns="#{bindings.SmsModuleAreasView11.hints.DisplaySeq.displayWidth}"
                                                            maximumLength="#{bindings.SmsModuleAreasView11.hints.DisplaySeq.precision}"
                                                            shortDesc="#{bindings.SmsModuleAreasView11.hints.DisplaySeq.tooltip}"
                                                            id="it2">
                                                  <f:validator binding="#{row.bindings.DisplaySeq.validator}"/>
                                                  <af:convertNumber groupingUsed="false"
                                                                    pattern="#{bindings.SmsModuleAreasView11.hints.DisplaySeq.format}"/>
                                              </af:inputText>
                                          </af:column>
                                          <af:column sortProperty="#{bindings.SmsModuleAreasView11.hints.Area.name}"
                                                     sortable="false"
                                                     headerText="#{bindings.SmsModuleAreasView11.hints.Area.label}" id="c1"
                                                     width="164">
                                              <af:inputText value="#{row.bindings.Area.inputValue}"
                                                            label="#{bindings.SmsModuleAreasView11.hints.Area.label}"
                                                            required="#{bindings.SmsModuleAreasView11.hints.Area.mandatory}"
                                                            columns="#{bindings.SmsModuleAreasView11.hints.Area.displayWidth}"
                                                            maximumLength="#{bindings.SmsModuleAreasView11.hints.Area.precision}"
                                                            shortDesc="#{bindings.SmsModuleAreasView11.hints.Area.tooltip}"
                                                            id="it1">
                                                  <f:validator binding="#{row.bindings.Area.validator}"/>
                                              </af:inputText>
                                          </af:column>
                                      </af:table>
                                      <af:inputText value="#{bindings.Description.inputValue}"
                                                    label="#{bindings.Description.hints.label}"
                                                    required="#{bindings.Description.hints.mandatory}"
                                                    columns="20"
                                                    maximumLength="#{bindings.Description.hints.precision}"
                                                    shortDesc="#{bindings.Description.hints.tooltip}" id="it3" rows="5">
                                          <f:validator binding="#{bindings.Description.validator}"/>
                                      </af:inputText>
                                  </af:panelFormLayout>
                              </af:panelHeader>
                          </af:panelGroupLayout>
                      </f:facet>
                  </af:panelStretchLayout>
                  <!-- id="af_one_column_stretched"   -->
              </f:facet>
          </af:panelStretchLayout>
      </jsp:root>
      when i select parent table it display duplicate record in child table related to parent table,even if there is no duplicate record

      Edited by: adf0994 on 2012/12/01 12:24 PM