12 Replies Latest reply: Feb 21, 2013 8:28 AM by Tshifhiwa RSS

    Inserting Rows to ADF View Object Programatically with foreign table value

    Tshifhiwa
      hi am Inserting Rows to ADF View Object Programatically ,the thing is i have to dispaly value from foreign table when inserting,for example i have a table which got list of users,i have to select values username,firstname,surname,email,and post/add this to viewObject organisationuser,which i have to pupulate username,firstname,surname,email from UserVO and take the exisisting organisationid organisationtable and update the organisationid in viewObject organisationuser,i try to follow this link but with no luck when i click add button it does not add values to second table,am in jdeveloper 11.1.1.6.0 http://howtolearnadf.blogspot.com/2012/10/insert-rows-in-to-adf-view-object.html
      <af:commandButton text="Add New" id="cb6"
                                                  actionListener="#{pageFlowScope.addMember.updAddMember}"/>
          public Number getorgid(){
              Number orgid;
              DCIteratorBinding it0 = ADFUtils.findIterator("UpdUamOrganisation1Iterator");
              RowSetIterator rsi = it0.getRowSetIterator();    
              Row rw =   rsi.first();
              
              orgid = (Number)rw.getAttribute("Organisationid");
              
              return orgid;
                  
          }
      
          public void updAddMember(ActionEvent actionEvent) {
              // Add event code here...
              //Code to get the bindings for TargetVO :
              OIDOperations   oIDOperations= new  OIDOperations();
              Map<Object,String> mp=new HashMap<Object, String>();
                      DCBindingContainer bindings2 =
                         (DCBindingContainer)BindingContext.getCurrent().getCurrentBindingsEntry();
                          
                     JUCtrlHierBinding obj = (JUCtrlHierBinding)bindings2.findCtrlBinding("UserDetailsViewVO1");
                     ViewObject targetVO = obj.getViewObject();
      
      
                DCBindingContainer bindings =
                         (DCBindingContainer)BindingContext.getCurrent().getCurrentBindingsEntry();
                     DCIteratorBinding empIter =
                         bindings.findIteratorBinding("DeltMember1Iterator");
      
              //SourceVO1Iterator is the iterator under Executables section for the SourceVO1 bindings.
      
                     RowSetIterator roleRSIters = empIter.getRowSetIterator();
                     RowSetIterator rs1 = roleRSIters.getRowSet().getViewObject().createRowSetIterator(null);
                     NameValuePairs nvp = null;
                     
                     String username = null;
      
              while (rs1.hasNext()) {
                                 Row r = rs1.next();   
          
                        
                         nvp = new NameValuePairs();
                         nvp.setAttribute("Organisationid", getorgid());
                         System.out.println("printedorgid " +getorgid());
                         nvp.setAttribute("Username",r.getAttribute("Username"));
                          nvp.setAttribute("Username1",r.getAttribute("Username"));
                         nvp.setAttribute("Firstname",r.getAttribute("Firstname"));
                         nvp.setAttribute("Surname",r.getAttribute("Surname"));
                         nvp.setAttribute("Emailaddress",r.getAttribute("Emailaddress"));  
                          username = (String)r.getAttribute("Username");
                         System.out.println("prininstead " + nvp);
                         targetVO.createAndInitRow(nvp);
                         
                      }
              
              
                     rs1.closeRowSetIterator();
                     targetVO.getApplicationModule().getTransaction().commit();
          }
      the viewObject am inserting values is
      <?xml version="1.0" encoding="windows-1252" ?>
      <!DOCTYPE ViewObject SYSTEM "jbo_03_01.dtd">
      <!---->
      <ViewObject
        xmlns="http://xmlns.oracle.com/bc4j"
        Name="DeltMember"
        Version="11.1.1.61.92"
        InheritPersonalization="true"
        SelectList="UamOrganisationUser.USERNAME, 
             UamOrganisationUser.ORGUSERROLE, 
             UamOrganisationUser.CREATED_DATE, 
             UamUserdetails.FIRSTNAME, 
             UamUserdetails.USERNAME AS USERNAME1, 
             UamUserdetails.SURNAME, 
             UamUserdetails.EMAILADDRESS, 
             UamOrganisationUser.ORGANISATIONID, 
             UamOrganisations.ORGANISATIONID AS ORGANISATIONID1, 
             UamOrganisations.ORGANISATIONNAME"
        FromList="UAM_ORGANISATION_USER UamOrganisationUser, UAM_USERDETAILS UamUserdetails, UAM_ORGANISATIONS UamOrganisations"
        Where="(UamOrganisationUser.USERNAME = UamUserdetails.USERNAME) AND (UamOrganisationUser.ORGANISATIONID = UamOrganisations.ORGANISATIONID)"
        BindingStyle="OracleName"
        CustomQuery="false"
        PageIterMode="Full"
        UseGlueCode="false"
        RowClass="uam.model.UpdOrgDetails.DeltMemberRowImpl"
        ComponentClass="uam.model.UpdOrgDetails.DeltMemberImpl">
        <DesignTime>
          <Attr Name="_codeGenFlag2" Value="Access|Coll|Prog|VarAccess"/>
          <Attr Name="_isCodegen" Value="true"/>
        </DesignTime>
        <Properties>
          <SchemaBasedProperties>
            <LABEL
              ResId="uam.model.UpdOrgDetails.DeltMember_LABEL"/>
          </SchemaBasedProperties>
        </Properties>
        <EntityUsage
          Name="UamOrganisationUser"
          Entity="uam.model.entities.UamOrganisationUser"/>
        <EntityUsage
          Name="UamUserdetails"
          Entity="uam.model.entities.UamUserdetails"
          Association="uam.model.entities.OrguserlinkUserdetailsFkAssoc"
          AssociationEnd="uam.model.entities.OrguserlinkUserdetailsFkAssoc.UamUserdetails"
          SourceUsage="uam.model.UpdOrgDetails.DeltMember.UamOrganisationUser"
          DeleteParticipant="false"
          JoinType="INNER JOIN">
          <DesignTime>
            <AttrArray Name="_srcAttributes">
              <Item
                Value="uam.model.entities.UamOrganisationUser.Username"/>
            </AttrArray>
            <AttrArray Name="_dstAttributes">
              <Item
                Value="uam.model.entities.UamUserdetails.Username"/>
            </AttrArray>
          </DesignTime>
        </EntityUsage>
        <EntityUsage
          Name="UamOrganisations"
          Entity="uam.model.entities.UamOrganisations"
          Association="uam.model.entities.OrguserlinkOrganisationsFkAssoc"
          AssociationEnd="uam.model.entities.OrguserlinkOrganisationsFkAssoc.UamOrganisations"
          SourceUsage="uam.model.UpdOrgDetails.DeltMember.UamOrganisationUser"
          DeleteParticipant="false"
          JoinType="INNER JOIN">
          <DesignTime>
            <AttrArray Name="_srcAttributes">
              <Item
                Value="uam.model.entities.UamOrganisationUser.Organisationid"/>
            </AttrArray>
            <AttrArray Name="_dstAttributes">
              <Item
                Value="uam.model.entities.UamOrganisations.Organisationid"/>
            </AttrArray>
          </DesignTime>
        </EntityUsage>
        <ViewAttribute
          Name="Username"
          IsNotNull="true"
          PrecisionRule="true"
          EntityAttrName="Username"
          EntityUsage="UamOrganisationUser"
          AliasName="USERNAME"/>
        <ViewAttribute
          Name="Orguserrole"
          PrecisionRule="true"
          EntityAttrName="Orguserrole"
          EntityUsage="UamOrganisationUser"
          AliasName="ORGUSERROLE"/>
        <ViewAttribute
          Name="CreatedDate"
          PrecisionRule="true"
          EntityAttrName="CreatedDate"
          EntityUsage="UamOrganisationUser"
          AliasName="CREATED_DATE">
          <TransientExpression><![CDATA[adf.currentDate]]></TransientExpression>
        </ViewAttribute>
        <ViewAttribute
          Name="Firstname"
          IsNotNull="true"
          PrecisionRule="true"
          EntityAttrName="Firstname"
          EntityUsage="UamUserdetails"
          AliasName="FIRSTNAME"/>
        <ViewAttribute
          Name="Username1"
          IsNotNull="true"
          PrecisionRule="true"
          EntityAttrName="Username"
          EntityUsage="UamUserdetails"
          AliasName="USERNAME1"/>
        <ViewAttribute
          Name="Surname"
          IsNotNull="true"
          PrecisionRule="true"
          EntityAttrName="Surname"
          EntityUsage="UamUserdetails"
          AliasName="SURNAME"/>
        <ViewAttribute
          Name="Emailaddress"
          IsNotNull="true"
          PrecisionRule="true"
          EntityAttrName="Emailaddress"
          EntityUsage="UamUserdetails"
          AliasName="EMAILADDRESS"/>
        <ViewAttribute
          Name="Organisationid"
          IsNotNull="true"
          PrecisionRule="true"
          EntityAttrName="Organisationid"
          EntityUsage="UamOrganisationUser"
          AliasName="ORGANISATIONID"/>
        <ViewAttribute
          Name="Organisationid1"
          IsUpdateable="while_insert"
          IsNotNull="true"
          PrecisionRule="true"
          EntityAttrName="Organisationid"
          EntityUsage="UamOrganisations"
          AliasName="ORGANISATIONID1"/>
        <ViewAttribute
          Name="Organisationname"
          IsUnique="true"
          PrecisionRule="true"
          EntityAttrName="Organisationname"
          EntityUsage="UamOrganisations"
          AliasName="ORGANISATIONNAME"/>
        <ResourceBundle>
          <PropertiesBundle
            PropertiesFile="model.ModelBundle"/>
        </ResourceBundle>
      </ViewObject>
      Edited by: adf009 on 2013/02/12 2:02 PM

      Edited by: adf009 on 2013/02/12 2:13 PM

      Edited by: adf009 on 2013/02/12 2:14 PM
        • 1. Re: Inserting Rows to ADF View Object Programatically with foreign table value
          Frank Nimphius-Oracle
          Hi,

          try adding

          RowSetIterator rs1 = roleRSIters.getRowSet().getViewObject().createRowSetIterator(null);
          rsi.first();


          Btw.: one handle to the binding container is sufficient. You don't need to create one per iterator

          Frank
          • 2. Re: Inserting Rows to ADF View Object Programatically with foreign table value
            Tshifhiwa
            hi i have change the code to this
            <af:commandButton text="Add New" id="cb5"
                                                    actionListener="#{pageFlowScope.addMember.updAddMember}"/>
                public void updAddMember(ActionEvent actionEvent) {
                    // Add event code here...
                    //Code to get the bindings for TargetVO :
                    OIDOperations   oIDOperations= new  OIDOperations();
                    Map<Object,String> mp=new HashMap<Object, String>();
                            DCBindingContainer bindings2 =
                               (DCBindingContainer)BindingContext.getCurrent().getCurrentBindingsEntry();
                                
                           JUCtrlHierBinding obj = (JUCtrlHierBinding)bindings2.findCtrlBinding("UserDetailsViewVO1");
                           ViewObject targetVO = obj.getViewObject();
            
            
                      DCBindingContainer bindings =
                               (DCBindingContainer)BindingContext.getCurrent().getCurrentBindingsEntry();
                           DCIteratorBinding empIter =
                               bindings.findIteratorBinding("DeltMember1Iterator");
            
                    //SourceVO1Iterator is the iterator under Executables section for the SourceVO1 bindings.
            
                    RowSetIterator roleRSIters = empIter.getRowSetIterator();
                    RowSetIterator rs1 = roleRSIters.getRowSet().getViewObject().createRowSetIterator(null);
                    rs1.first();
                           NameValuePairs nvp = null;
                           
                           String username = null;
            
                    while (rs1.hasNext()) {
                                       Row r = rs1.next();   
                
                              
                               nvp = new NameValuePairs();                  
                               nvp.setAttribute("Organisationid", getorgid());
                               System.out.println("printedorgid" +getorgid());
                               nvp.setAttribute("Username",r.getAttribute("Username"));
                                nvp.setAttribute("Username1",r.getAttribute("Username"));
                               nvp.setAttribute("Firstname",r.getAttribute("Firstname"));
                               nvp.setAttribute("Surname",r.getAttribute("Surname"));
                               nvp.setAttribute("Emailaddress",r.getAttribute("Emailaddress"));                 
                               System.out.println("prininstead " + nvp);
                               targetVO.createAndInitRow(nvp);
                               
                            }
                    
              
                           rs1.closeRowSetIterator();
                           targetVO.getApplicationModule().getTransaction().commit();
                }
            
            am still not able to add row to aanother view
            am geting this log when clicking the button
            <DCJboDataControl> <initializeApplicationModule> [3705] (oracle.adf.model.bc4j.DataControlFactoryImpl.SyncMode = Immediate
            <DCJboDataControl> <initializeApplicationModule> [3706] (oracle.adf.model.bc4j.DataControlFactoryImpl.SyncMode = Immediate
            <DCJboDataControl> <initializeApplicationModule> [3707] (oracle.adf.model.bc4j.DataControlFactoryImpl.SyncMode = Immediate
            <ADFLogger> <begin> Refreshing binding container
            <DCBindingContainer> <internalRefreshControl> [3708] **** refreshControl() for BindingContainer :uam_view_updateorgPageDef
            <DCBindingContainer> <internalRefreshControl> [3709] WARNING! Executable:uam_view_updateorgPageDef was already refreshed in prepareModel phase!
            <ADFLogger> <begin> Refreshing binding container
            <DCBindingContainer> <internalRefreshControl> [3710] **** refreshControl() for BindingContainer :uam_view_pageDefs_OrgDetailsPageDef_WEB_INF_Updatetaskflow_definition_xml_Updatetaskflow_definition
            <DCBindingContainerState> <validateToken> [3711] Process BindingContainer state token(decompressed state):BCST:=0%V%=N%R=0%Updatetaskflowdefinition1=BCST:=0%V%=N%R=1%uam_view_pageDefs_OrgDetailsPageDef_WEB_INF_Updatetaskflow_definition_xml_Updatetaskflow_definition=BCST:=0%V%=NUpdUamOrganisation1Iterator=-D-,UpdResPerson1Iterator=-D-,UpdPaymentOptions1Iterator=-D-,DeltMember1Iterator=-D-,UamUserdetailsView1Iterator=-D-,UpdOrganisationUser1Iterator=-D-,UamAddress1Iterator=-D-,UserDetailsViewVO1Iterator=-D-,%R=2%ImplicitViewCriteriaQuery=BCST:=0;#;eAF9Uz1vE0EQnXwBSQSK8iUooKGI0vhEHYTkr5ATl7PBjomc4ljfjZ1Ndu+OvT37AhISNAiJggZa
            OioooUa0IAoK/gKioOEPmLmzDSaC7Banm515M/ve29c/YCZWsLRnHbAuywnmd3KV1gG6euPZ592X
            C9G6mARIQgCYorzVPStQzBWYO2gFuQZTnLUEbnx4fOf9qydb10apk5GCtWEi89o5GXgoci3ue5zw
            S8VRoSlDcXX768e3u3NuWqvg0hi8G0gZ+L+7pMmPzr/4+en5U3cKlguwslm5tZ2vO6a9WXHyjbxp
            5QtWuQAXxuN2pf7fsx3btM26mbfMZrnUhFOyxJU+KsA5ucWizUBJpk2/HTRhVZpRCdvcR48+LBa6
            wUSMTZiWNvaacEbagbZjIZqwKKssiniXaR74NqKHnglzsqrQ5RGFTGpTc5nAAszLndBjGlMKLfor
            Br7GRG+zUMNSpocRay4MGmafghsWnJXj7TUsDrJS1YyhahbMynISqnKXCQ0rQ7kMkssYhTOgcqLR
            p+FKTLO78ABOWzAjb5BCf6PWtCLJqGJeVhTvDJpouDyOKwNpJFIYNFsVVcQjnZnCggVZQ3KI4PdQ
            FQXRkjaatWBZ1hXzI46+TmdC4ivws7MknIA+7QnatPr9/sPJcLh6a7BEde7hzRjVEXVqk0LowcJx
            54ZJ1mj6BKh1WKkhU+5+PgwFR6+ouE5HHQcbXD1Mjj+PISVvvjS+fb94//rI8xPE9j8x4/Rm6aKM
            d6Q3c2ImnS7HnhNn+geqU2UdJPqcgSE0iw7bIuh5qeV4aqQrf2rCQWrkVFSnhJpxEY2qb5cL6WM4
            huL8gXFIphNO0xfGXa4bNNuIkYzsX08vbv8=
            :#eryPerformed def SearchAppliedCriteria def SearchAppliedCriteria=data_uam_view_updateorgPageDef_Updatetaskflowdefinition1_uam_view_pageDefs_OrgDetailsPageDef_WEB_INF_Updatetaskflow_definition_xml_Updatetaskflow_definition_ImplicitViewCriteriaQuery
            <DCUtil> <findSpelObject> [4188] DCUtil, returning:oracle.jbo.uicli.binding.JUFormBinding, for uam_view_pageDefs_OrgDetailsPageDef_WEB_INF_Updatetaskflow_definition_xml_Updatetaskflow_definition
            <DCIteratorBinding> <releaseDataInternal> [4189] Releasing iterator binding:OfficecodeList_582
            <DCIteratorBinding> <releaseDataInternal> [4190] Releasing iterator binding:OrganisationtypecodeList_490
            <DCIteratorBinding> <releaseDataInternal> [4191] Releasing iterator binding:OrgsubtypecodeList_583
            <DCIteratorBinding> <releaseDataInternal> [4192] Releasing iterator binding:CountrycodeList_584
            <DCIteratorBinding> <releaseDataInternal> [4193] Releasing iterator binding:ProvinceList_585
            <DCIteratorBinding> <releaseDataInternal> [4194] Releasing iterator binding:CityList_586
            <DCIteratorBinding> <releaseDataInternal> [4195] Releasing iterator binding:SuburbList_588
            <DCIteratorBinding> <releaseDataInternal> [4196] Releasing iterator binding:Suburb1List_587
            <JUCtrlHierNodeBinding> <release> [4197] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_47, value:UpdResPerson1Iterator
            <JUCtrlHierNodeBinding> <release> [4198] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_48, value:UpdResPerson1Iterator
            <JUCtrlHierNodeBinding> <release> [4199] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_94, value:UserDetailsViewVO1Iterator
            <JUCtrlHierNodeBinding> <release> [4200] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_207, value:DeltMember1Iterator
            <DCIteratorBinding> <releaseDataInternal> [4201] Releasing iterator binding:UpdUamOrganisation1Iterator
            <JUCtrlHierNodeBinding> <release> [4202] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_47, value:UpdResPerson1Iterator
            <JUCtrlHierNodeBinding> <release> [4203] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_48, value:UpdResPerson1Iterator
            <DCIteratorBinding> <releaseDataInternal> [4204] Releasing iterator binding:UpdResPerson1Iterator
            <DCIteratorBinding> <releaseDataInternal> [4205] Releasing iterator binding:UpdPaymentOptions1Iterator
            <DCIteratorBinding> <releaseDataInternal> [4206] Releasing iterator binding:LutPaymentmethodsView1Iterator
            <JUCtrlHierNodeBinding> <release> [4207] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_207, value:DeltMember1Iterator
            <DCIteratorBinding> <releaseDataInternal> [4208] Releasing iterator binding:DeltMember1Iterator
            <DCIteratorBinding> <releaseDataInternal> [4209] Releasing iterator binding:UamUserdetailsView1Iterator
            <DCIteratorBinding> <releaseDataInternal> [4210] Releasing iterator binding:UpdOrganisationUser1Iterator
            <DCIteratorBinding> <releaseDataInternal> [4211] Releasing iterator binding:UamAddress1Iterator
            <JUCtrlHierNodeBinding> <release> [4212] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_94, value:UserDetailsViewVO1Iterator
            <DCIteratorBinding> <releaseDataInternal> [4213] Releasing iterator binding:UserDetailsViewVO1Iterator
            <JUCtrlHierNodeBinding> <release> [4214] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_91, value:vcRowsIterator
            <LoopDiagnostic> <dump> [4187] variableIterator variables passivated >>> TrackQueryPerformed def SearchAppliedCriteria def SearchAppliedCriteria=data_uam_view_updateorgPageDef_Updatetaskflowdefinition1_uam_view_pageDefs_OrgDetailsPageDef_WEB_INF_Updatetaskflow_definition_xml_Updatetaskflow_definition_ImplicitViewCriteriaQuery
            <DCUtil> <findSpelObject> [4188] DCUtil, returning:oracle.jbo.uicli.binding.JUFormBinding, for uam_view_pageDefs_OrgDetailsPageDef_WEB_INF_Updatetaskflow_definition_xml_Updatetaskflow_definition
            <DCIteratorBinding> <releaseDataInternal> [4189] Releasing iterator binding:OfficecodeList_582
            <DCIteratorBinding> <releaseDataInternal> [4190] Releasing iterator binding:OrganisationtypecodeList_490
            <DCIteratorBinding> <releaseDataInternal> [4191] Releasing iterator binding:OrgsubtypecodeList_583
            <DCIteratorBinding> <releaseDataInternal> [4192] Releasing iterator binding:CountrycodeList_584
            <DCIteratorBinding> <releaseDataInternal> [4193] Releasing iterator binding:ProvinceList_585
            <DCIteratorBinding> <releaseDataInternal> [4194] Releasing iterator binding:CityList_586
            <DCIteratorBinding> <releaseDataInternal> [4195] Releasing iterator binding:SuburbList_588
            <DCIteratorBinding> <releaseDataInternal> [4196] Releasing iterator binding:Suburb1List_587
            <JUCtrlHierNodeBinding> <release> [4197] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_47, value:UpdResPerson1Iterator
            <JUCtrlHierNodeBinding> <release> [4198] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_48, value:UpdResPerson1Iterator
            <JUCtrlHierNodeBinding> <release> [4199] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_94, value:UserDetailsViewVO1Iterator
            <JUCtrlHierNodeBinding> <release> [4200] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_207, value:DeltMember1Iterator
            <DCIteratorBinding> <releaseDataInternal> [4201] Releasing iterator binding:UpdUamOrganisation1Iterator
            <JUCtrlHierNodeBinding> <release> [4202] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_47, value:UpdResPerson1Iterator
            <JUCtrlHierNodeBinding> <release> [4203] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_48, value:UpdResPerson1Iterator
            <DCIteratorBinding> <releaseDataInternal> [4204] Releasing iterator binding:UpdResPerson1Iterator
            <DCIteratorBinding> <releaseDataInternal> [4205] Releasing iterator binding:UpdPaymentOptions1Iterator
            <DCIteratorBinding> <releaseDataInternal> [4206] Releasing iterator binding:LutPaymentmethodsView1Iterator
            <JUCtrlHierNodeBinding> <release> [4207] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_207, value:DeltMember1Iterator
            <DCIteratorBinding> <releaseDataInternal> [4208] Releasing iterator binding:DeltMember1Iterator
            <DCIteratorBinding> <releaseDataInternal> [4209] Releasing iterator binding:UamUserdetailsView1Iterator
            <DCIteratorBinding> <releaseDataInternal> [4210] Releasing iterator binding:UpdOrganisationUser1Iterator
            <DCIteratorBinding> <releaseDataInternal> [4211] Releasing iterator binding:UamAddress1Iterator
            <JUCtrlHierNodeBinding> <release> [4212] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_94, value:UserDetailsViewVO1Iterator
            <DCIteratorBinding> <releaseDataInternal> [4213] Releasing iterator binding:UserDetailsViewVO1Iterator
            <JUCtrlHierNodeBinding> <release> [4214] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_91, value:vcRowsIterator
            <DCIteratorBinding> <releaseDataInternal> [4215] Releasing iterator binding:operators_503
            <DCIteratorBinding> <releaseDataInternal> [4216] Releasing iterator binding:listIter
            <DCIteratorBinding> <releaseDataInternal> [4217] Releasing iterator binding:values_506
            <DCIteratorBinding> <releaseDataInternal> [4218] Releasing iterator binding:values_506
            <DCIteratorBinding> <releaseDataInternal> [4219] Releasing iterator binding:nestedViewCriteria_508
            <DCIteratorBinding> <releaseDataInternal> [4220] Releasing iterator binding:nestedViewCriteria_508
            <DCIteratorBinding> <releaseDataInternal> [4221] Releasing iterator binding:operators_503
            <DCIteratorBinding> <releaseDataInternal> [4222] Releasing iterator binding:operators_510
            <DCIteratorBinding> <releaseDataInternal> [4223] Releasing iterator binding:listIter
            <DCIteratorBinding> <releaseDataInternal> [4224] Releasing iterator binding:values_513
            <DCIteratorBinding> <releaseDataInternal> [4225] Releasing iterator binding:values_513
            <DCIteratorBinding> <releaseDataInternal> [4226] Releasing iterator binding:nestedViewCriteria_515
            <DCIteratorBinding> <releaseDataInternal> [4227] Releasing iterator binding:nestedViewCriteria_515
            <DCIteratorBinding> <releaseDataInternal> [4228] Releasing iterator binding:operators_510
            <DCIteratorBinding> <releaseDataInternal> [4229] Releasing iterator binding:operators_517
            <DCIteratorBinding> <releaseDataInternal> [4230] Releasing iterator binding:listIter
            <DCIteratorBinding> <releaseDataInternal> [4231] Releasing iterator binding:values_520
            <DCIteratorBinding> <releaseDataInternal> [4232] Releasing iterator binding:values_520
            <DCIteratorBinding> <releaseDataInternal> [4233] Releasing iterator binding:nestedViewCriteria_522
            <DCIteratorBinding> <releaseDataInternal> [4234] Releasing iterator binding:nestedViewCriteria_522
            <DCIteratorBinding> <releaseDataInternal> [4235] Releasing iterator binding:operators_517
            <DCIteratorBinding> <releaseDataInternal> [4236] Releasing iterator binding:operators_524
            <DCIteratorBinding> <releaseDataInternal> [4237] Releasing iterator binding:listIter
            <DCIteratorBinding> <releaseDataInternal> [4238] Releasing iterator binding:values_527
            <DCIteratorBinding> <releaseDataInternal> [4239] Releasing iterator binding:values_527
            <DCIteratorBinding> <releaseDataInternal> [4240] Releasing iterator binding:nestedViewCriteria_529
            <DCIteratorBinding> <releaseDataInternal> [4241] Releasing iterator binding:nestedViewCriteria_529
            <DCIteratorBinding> <releaseDataInternal> [4242] Releasing iterator binding:operators_524
            <DCIteratorBinding> <releaseDataInternal> [4243] Releasing iterator binding:criteriaItemsForSearch_494
            <DCIteratorBinding> <releaseDataInternal> [4244] Releasing iterator binding:viewObjectBindVars_497
            <DCIteratorBinding> <releaseDataInternal> [4245] Releasing iterator binding:viewObjectBindVars_497
            <DCIteratorBinding> <releaseDataInternal> [4246] Releasing iterator binding:properties_499
            <DCIteratorBinding> <releaseDataInternal> [4247] Releasing iterator binding:properties_499
            <DCIteratorBinding> <releaseDataInternal> [4248] Releasing iterator binding:criteriaItemsForSearch_494
            <JUCtrlHierNodeBinding> <release> [4249] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_92, value:vcRowsIterator
            <JUCtrlHierNodeBinding> <release> [4250] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_91, value:vcRowsIterator
            <JUCtrlHierNodeBinding> <release> [4251] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_92, value:vcRowsIterator
            <DCIteratorBinding> <releaseDataInternal> [4252] Releasing iterator binding:vcRowsIterator
            <DCIteratorBinding> <releaseDataInternal> [4253] Releasing iterator binding:variableIterator
            <ApplicationPoolMessageHandler> <doPoolMessage> [4254] **** PoolMessage REQ ATTACH LWS
            <ApplicationPoolMessageHandler> <doPoolMessage> [4255] **** PoolMessage REQ DETACH LWS
            <ViewObjectImpl> <closeStatementsResetRowSet> [4256] ViewObject: [internal_vcival_def]Root.internal_vcival_def_531 close prepared statements...
            <ViewObjectImpl> <closeStatementsResetRowSet> [4257] ViewObject: [internal_vco_def]Root.internal_vco_def_589 close prepared statements...
            <ViewObjectImpl> <closeStatementsResetRowSet> [4258] ViewObject: [internal_vci_def]Root.internal_vci_def_501 close prepared statements...
            <ViewObjectImpl> <closeStatementsResetRowSet> [4259] ViewObject: [AppModule.UserDetailsViewVO1.data_uam_view_updateorgPageDef_Updatetaskflowdefinition1_uam_view_pageDefs_OrgDetailsPageDef_WEB_INF_Updatetaskflow_definition_xml_Updatetaskflow_definition_ImplicitViewCriteriaQuery]Root.AppModule_UserDetailsViewVO1_data_uam_view_updateorgPageDef_Updatetaskflowdefinition1_uam_view_pageDefs_OrgDetailsPageDef_WEB_INF_Updatetaskflow_definition_xml_Updatetaskflow_definition_ImplicitViewCriteriaQuery_492 close prepared statements...
            <DCUtil> <findSpelObject> [4260] DCUtil, returning:oracle.adfinternal.view.faces.model.binding.FacesCtrlSearchBinding, for ImplicitViewCriteriaQuery
            <JUCtrlHierNodeBinding> <release> [4261] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_91, value:vcRowsIterator
            <JUCtrlHierNodeBinding> <release> [4262] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_92, value:vcRowsIterator
            <JUCtrlHierNodeBinding> <release> [4263] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_91, value:vcRowsIterator
            <JUCtrlHierNodeBinding> <release> [4264] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_92, value:vcRowsIterator
            <DCIteratorBinding> <releaseDataInternal> [4265] Releasing iterator binding:vcRowsIterator
            <DCIteratorBinding> <releaseDataInternal> [4266] Releasing iterator binding:variableIterator
            <ADFLogger> <begin> Rollback transaction
            <ApplicationModuleImpl> <resetState> [4267] Resetting AM=Root
            <ApplicationPoolMessageHandler> <doPoolMessage> [4268] **** PoolMessage REQ DETACH LWS
            <ApplicationPoolMessageHandler> <doPoolMessage> [4269] **** PoolMessage REQ ATTACH LWS
            <ApplicationPoolMessageHandler> <doPoolMessage> [4270] **** PoolMessage REQ DETACH LWS
            <DCJboDataControl> <initializeApplicationModule> [4271] (oracle.adf.model.bc4j.DataControlFactoryImpl.SyncMode = Immediate
            <PropertyManager> <loadProperty> [4272] WARNING: Property jbo.maxpoolcookieageset to null
            <PropertyManager> <loadProperty> [4273] Skipping empty Property jbo.maxpoolcookieage from null
            <DCJboDataControl> <initializeApplicationModule> [4274] (oracle.adf.model.bc4j.DataControlFactoryImpl.SyncMode = Immediate
            <DCJboDataControl> <initializeApplicationModule> [4275] (oracle.adf.model.bc4j.DataControlFactoryImpl.SyncMode = Immediate
            <ADFLogger> <begin> Refreshing binding container
            <DCBindingContainer> <internalRefreshControl> [4276] **** refreshControl() for BindingContainer :uam_view_updateorgPageDef
            <DCBindingContainer> <internalRefreshControl> [4277] WARNING! Executable:uam_view_updateorgPageDef was already refreshed in prepareModel phase!
            <ADFLogger> <begin> Refreshing binding container
            <DCBindingContainer> <internalRefreshControl> [4278] **** refreshControl() for BindingContainer :uam_view_pageDefs_OrgDetailsPageDef_WEB_INF_Updatetaskflow_definition_xml_Updatetaskflow_definition
            <DCBindingContainerState> <validateToken> [4279] Process BindingContainer state token(decompressed state):BCST:=0%V%=N%R=0%Updatetaskflowdefinition1=BCST:=0%V%=N%R=1%uam_view_pageDefs_OrgDetailsPageDef_WEB_INF_Updatetaskflow_definition_xml_Updatetaskflow_definition=BCST:=0%V%=NUpdUamOrganisation1Iterator=-D-,UpdResPerson1Iterator=-D-,UpdPaymentOptions1Iterator=-D-,DeltMember1Iterator=-D-,UamUserdetailsView1Iterator=-D-,UpdOrganisationUser1Iterator=-D-,UamAddress1Iterator=-D-,UserDetailsViewVO1Iterator=-D-,%R=2%ImplicitViewCriteriaQuery=BCST:=0;#;eAF9Uz1vE0EQnXwBSQSK8iUooKGI0vhEHYTkr5ATl7PBjomc4ljfjZ1Ndu+OvT37AhISNAiJggZa
            OioooUa0IAoK/gKioOEPmLmzDSaC7Banm515M/ve29c/YCZWsLRnHbAuywnmd3KV1gG6euPZ592X
            C9G6mARIQgCYorzVPStQzBWYO2gFuQZTnLUEbnx4fOf9qydb10apk5GCtWEi89o5GXgoci3ue5zw
            S8VRoSlDcXX768e3u3NuWqvg0hi8G0gZ+L+7pMmPzr/4+en5U3cKlguwslm5tZ2vO6a9WXHyjbxp
            5QtWuQAXxuN2pf7fsx3btM26mbfMZrnUhFOyxJU+KsA5ucWizUBJpk2/HTRhVZpRCdvcR48+LBa6
            wUSMTZiWNvaacEbagbZjIZqwKKssiniXaR74NqKHnglzsqrQ5RGFTGpTc5nAAszLndBjGlMKLfor
            Br7GRG+zUMNSpocRay4MGmafghsWnJXj7TUsDrJS1YyhahbMynISqnKXCQ0rQ7kMkssYhTOgcqLR
            p+FKTLO78ABOWzAjb5BCf6PWtCLJqGJeVhTvDJpouDyOKwNpJFIYNFsVVcQjnZnCggVZQ3KI4PdQ
            FQXRkjaatWBZ1hXzI46+TmdC4ivws7MknIA+7QnatPr9/sPJcLh6a7BEde7hzRjVEXVqk0LowcJx
            54ZJ1mj6BKh1WKkhU+5+PgwFR6+ouE5HHQcbXD1Mjj+PISVvvjS+fb94//rI8xPE9j8x4/Rm6aKM
            d6Q3c2ImnS7HnhNn+geqU2UdJPqcgSE0iw7bIuh5qeV4aqQrf2rCQWrkVFSnhJpxEY2qb5cL6WM4
            huL8gXFIphNO0xfGXa4bNNuIkYzsX08vbv8=
            :#:vcRowsIterator=-D-,,,,
            <LoopDiagnostic> <dump> [4280] variableIterator variables activated <<< [U]:TrackQueryPerformed-null [C]:SearchAppliedCriteria-null SearchAppliedCriteria=data_uam_view_updateorgPageDef_Updatetaskflowdefinition1_uam_view_pageDefs_OrgDetailsPageDef_WEB_INF_Updatetaskflow_definition_xml_Updatetaskflow_definition_ImplicitViewCriteriaQuery
            <ADFLogger> <begin> Refreshing binding container
            <DCBindingContainer> <internalRefreshControl> [4281] **** refreshControl() for BindingContainer :uam_view_updateorgPageDef
            <ADFLogger> <begin> Refreshing binding container
            <DCBindingContainer> <internalRefreshControl> [4282] **** refreshControl() for BindingContainer :uam_view_pageDefs_OrgDetailsPageDef_WEB_INF_Updatetaskflow_definition_xml_Updatetaskflow_definition
            <DCExecutableBinding> <refreshIfNeeded> [4283] Invoke refresh for :DeltMember1Iterator
            <DCIteratorBinding> <refresh> [4284] Executing and syncing on IteratorBinding.refresh from :DeltMember1Iterator
            <DCUtil> <findSpelObject> [4285] DCUtil, returning:oracle.jbo.uicli.binding.JUApplication, for UpdAppModuleDataControl
            <DCJboDataControl> <initializeApplicationModule> [4286] (oracle.adf.model.bc4j.DataControlFactoryImpl.SyncMode = Immediate
            <ApplicationPoolImpl> <reuseReferencedInstance> [4287] Reusing a cached session application module instance
            <ApplicationPoolMessageHandler> <doPoolMessage> [4288] **** PoolMessage REQ ATTACH LWS
            <ADFLogger> <begin> Attaching an iterator binding to a datasource
            <DCIteratorBinding> <getViewObject> [4289] Resolving VO:DeltMember1 for iterator binding:DeltMember1Iterator
            <DCUtil> <findSpelObject> [4290] DCUtil, returning:oracle.adfinternal.view.faces.model.binding.FacesCtrlHierBinding, for DeltMember1
            <ADFLogger> <addContextData> Attaching an iterator binding to a datasource
            <ADFLogger> <begin> Executing iterator binding
            <ADFLogger> <begin> Converting rows into hierarchical nodes
            <ADFLogger> <addContextData> Converting rows into hierarchical nodes
            <ADFLogger> <begin> Estimated row count
            <ADFLogger> <addContextData> Estimated row count
            <ADFLogger> <begin> Estimated row count
            <ADFLogger> <addContextData> Estimated row count
            <LoopDiagnostic> <dump> [4291] variableIterator variables passivated >>> TrackQueryPerformed def SearchAppliedCriteria def SearchAppliedCriteria=data_uam_view_updateorgPageDef_Updatetaskflowdefinition1_uam_view_pageDefs_OrgDetailsPageDef_WEB_INF_Updatetaskflow_definition_xml_Updatetaskflow_definition_ImplicitViewCriteriaQuery
            <DCUtil> <findSpelObject> [4292] DCUtil, returning:oracle.jbo.uicli.binding.JUFormBinding, for uam_view_pageDefs_OrgDetailsPageDef_WEB_INF_Updatetaskflow_definition_xml_Updatetaskflow_definition
            <JUCtrlHierNodeBinding> <release> [4293] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_47, value:UpdResPerson1Iterator
            <JUCtrlHierNodeBinding> <release> [4294] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_48, value:UpdResPerson1Iterator
            <JUCtrlHierNodeBinding> <release> [4295] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_94, value:UserDetailsViewVO1Iterator
            <JUCtrlHierNodeBinding> <release> [4296] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_207, value:DeltMember1Iterator
            <DCIteratorBinding> <releaseDataInternal> [4297] Releasing iterator binding:UpdUamOrganisation1Iterator
            <JUCtrlHierNodeBinding> <release> [4298] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_47, value:UpdResPerson1Iterator
            <JUCtrlHierNodeBinding> <release> [4299] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_48, value:UpdResPerson1Iterator
            <DCIteratorBinding> <releaseDataInternal> [4300] Releasing iterator binding:UpdResPerson1Iterator
            <DCIteratorBinding> <releaseDataInternal> [4301] Releasing iterator binding:UpdPaymentOptions1Iterator
            <DCIteratorBinding> <releaseDataInternal> [4302] Releasing iterator binding:LutPaymentmethodsView1Iterator
            <JUCtrlHierNodeBinding> <release> [4303] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_207, value:DeltMember1Iterator
            <DCIteratorBinding> <releaseDataInternal> [4304] Releasing iterator binding:DeltMember1Iterator
            <DCIteratorBinding> <releaseDataInternal> [4305] Releasing iterator binding:UamUserdetailsView1Iterator
            <DCIteratorBinding> <releaseDataInternal> [4306] Releasing iterator binding:UpdOrganisationUser1Iterator
            <DCIteratorBinding> <releaseDataInternal> [4307] Releasing iterator binding:UamAddress1Iterator
            <JUCtrlHierNodeBinding> <release> [4308] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_94, value:UserDetailsViewVO1Iterator
            <DCIteratorBinding> <releaseDataInternal> [4309] Releasing iterator binding:UserDetailsViewVO1Iterator
            <JUCtrlHierNodeBinding> <release> [4310] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_91, value:vcRowsIterator
            <JUCtrlHierNodeBinding> <release> [4311] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_92, value:vcRowsIterator
            <JUCtrlHierNodeBinding> <release> [4312] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_91, value:vcRowsIterator
            <JUCtrlHierNodeBinding> <release> [4313] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_92, value:vcRowsIterator
            <DCIteratorBinding> <releaseDataInternal> [4314] Releasing iterator binding:vcRowsIterator
            <DCIteratorBinding> <releaseDataInternal> [4315] Releasing iterator binding:variableIterator
            <ApplicationPoolMessageHandler> <doPoolMessage> [4316] **** PoolMessage REQ ATTACH LWS
            <ApplicationPoolMessageHandler> <doPoolMessage> [4317] **** PoolMessage REQ DETACH LWS
            Edited by: adf009 on 2013/02/13 5:10 PM

            Edited by: adf009 on 2013/02/13 5:14 PM
            • 3. Re: Inserting Rows to ADF View Object Programatically with foreign table value
              Timo Hahn
              adf009,
              have you looked into the doc (javadoc)?
              You are creating rows with
              targetVO.createAndInitRow(nvp);
              but don't bother with the row returned by this menthod. Who's putting the row into the target rowset? You don't!
              createAndInitRow(AttributeList nvp): Creates and initializes a new Row object, but does not insert it into the Row Set.
              Timo
              • 4. Re: Inserting Rows to ADF View Object Programatically with foreign table value
                Tshifhiwa
                how do i put the row into the target rowset
                • 5. Re: Inserting Rows to ADF View Object Programatically with foreign table value
                  Timo Hahn
                  Row row = targetVO.createAndInitRow(nvp);
                  targetVO.insertRow(row);
                  Timo
                  • 6. Re: Inserting Rows to ADF View Object Programatically with foreign table value
                    Tshifhiwa
                    i have change code to this but still not able to add/insert row to another viewobject
                        public void updAddMember(ActionEvent actionEvent) {
                            // Add event code here...
                            //Code to get the bindings for TargetVO :
                            OIDOperations   oIDOperations= new  OIDOperations();
                            Map<Object,String> mp=new HashMap<Object, String>();
                                    DCBindingContainer bindings2 =
                                       (DCBindingContainer)BindingContext.getCurrent().getCurrentBindingsEntry();
                                        
                                   JUCtrlHierBinding obj = (JUCtrlHierBinding)bindings2.findCtrlBinding("UserDetailsViewVO1");
                                   ViewObject targetVO = obj.getViewObject();
                    
                    
                              DCBindingContainer bindings =
                                       (DCBindingContainer)BindingContext.getCurrent().getCurrentBindingsEntry();
                                   DCIteratorBinding empIter =
                                       bindings.findIteratorBinding("DeltMember1Iterator");
                    
                            //SourceVO1Iterator is the iterator under Executables section for the SourceVO1 bindings.
                    
                            RowSetIterator roleRSIters = empIter.getRowSetIterator();
                            RowSetIterator rs1 = roleRSIters.getRowSet().getViewObject().createRowSetIterator(null);
                          //  rs1.first();
                                   NameValuePairs nvp = null;
                                   
                                   String username = null;
                                   
                           
                    
                            while (rs1.hasNext()) {
                                               Row r = rs1.next();   
                        
                                      
                                       nvp = new NameValuePairs();                  
                                       nvp.setAttribute("Organisationid", getorgid());
                                       System.out.println("printedorgid" +getorgid());
                                       nvp.setAttribute("Username",r.getAttribute("Username"));
                                       nvp.setAttribute("Username1",r.getAttribute("Username"));
                                       nvp.setAttribute("Firstname",r.getAttribute("Firstname"));
                                       nvp.setAttribute("Surname",r.getAttribute("Surname"));
                                       nvp.setAttribute("Emailaddress",r.getAttribute("Emailaddress"));                                 
                                        r = targetVO.createAndInitRow(nvp);
                                        targetVO.insertRow(r);
                    
                                        
                                       
                                    }
                            
                            
                                   rs1.closeRowSetIterator();
                                   targetVO.getApplicationModule().getTransaction().commit();
                        }
                    Edited by: adf009 on 2013/02/14 5:19 PM
                    • 7. Re: Inserting Rows to ADF View Object Programatically with foreign table value
                      Timo Hahn
                      Back to start?
                      What does not work?
                      Do you get any exceptions?
                      Is the code to insert the rows called?
                      I don't read your code as it's too much to digest. You have debugged the code (i hope) and should be able to give a more detailed description of what is happening where and why you think it's not working OK.

                      Timo
                      • 8. Re: Inserting Rows to ADF View Object Programatically with foreign table value
                        Tshifhiwa
                        What does not work?=the code to insert row to another view
                        Do you get any exceptions?=no i don't get any exception
                        Is the code to insert the rows called?=yes the code to insert rows is called

                        when i click the add button it just refresh the table i suppose to add/create row
                        <af:commandButton text="Add New" id="cb5"
                                                                action="#{pageFlowScope.addMember.updAddMember}"/>
                        
                            public void updAddMember() {
                                // Add event code here...
                                //Code to get the bindings for TargetVO :
                                OIDOperations   oIDOperations= new  OIDOperations();
                                Map<Object,String> mp=new HashMap<Object, String>();
                                        DCBindingContainer bindings2 =
                                           (DCBindingContainer)BindingContext.getCurrent().getCurrentBindingsEntry();
                                            
                                       JUCtrlHierBinding obj = (JUCtrlHierBinding)bindings2.findCtrlBinding("UserDetailsViewVO1");
                                       ViewObject targetVO = obj.getViewObject();
                        
                        
                                  DCBindingContainer bindings =
                                           (DCBindingContainer)BindingContext.getCurrent().getCurrentBindingsEntry();
                                       DCIteratorBinding empIter =
                                           bindings.findIteratorBinding("DeltMember1Iterator");
                        
                                //SourceVO1Iterator is the iterator under Executables section for the SourceVO1 bindings.
                        
                                RowSetIterator roleRSIters = empIter.getRowSetIterator();
                                RowSetIterator rs1 = roleRSIters.getRowSet().getViewObject().createRowSetIterator(null);
                                rs1.first();
                                       NameValuePairs nvp = null;
                                       
                                       String username = null;
                                       
                                
                        
                                while (rs1.hasNext()) {
                                                   Row r = rs1.next();   
                                
                                          
                                           nvp = new NameValuePairs();
                                          // nvp.setAttribute("organisationid", r.getAttribute("organisationid"));
                                           nvp.setAttribute("Organisationid", getorgid());
                                           System.out.println("printedorgid" +getorgid());
                                           nvp.setAttribute("Username",r.getAttribute("Username"));
                                           nvp.setAttribute("Username1",r.getAttribute("Username"));
                                           nvp.setAttribute("Firstname",r.getAttribute("Firstname"));
                                           nvp.setAttribute("Surname",r.getAttribute("Surname"));
                                           nvp.setAttribute("Emailaddress",r.getAttribute("Emailaddress"));                 
                                           System.out.println("prininstead " + nvp);
                                           
                                    
                                    
                                           
                                    
                                            Row row = targetVO.createAndInitRow(nvp);
                                            targetVO.insertRow(row);
                        
                                            
                                           
                                        }
                              
                                       rs1.closeRowSetIterator();
                                       targetVO.getApplicationModule().getTransaction().commit();
                            }
                        }
                        
                        the log error shows
                        <DCJboDataControl> <initializeApplicationModule> [11847] (oracle.adf.model.bc4j.DataControlFactoryImpl.SyncMode = Immediate
                        <DCJboDataControl> <initializeApplicationModule> [11848] (oracle.adf.model.bc4j.DataControlFactoryImpl.SyncMode = Immediate
                        <DCJboDataControl> <initializeApplicationModule> [11849] (oracle.adf.model.bc4j.DataControlFactoryImpl.SyncMode = Immediate
                        <DCJboDataControl> <initializeApplicationModule> [11850] (oracle.adf.model.bc4j.DataControlFactoryImpl.SyncMode = Immediate
                        <ADFLogger> <begin> Refreshing binding container
                        <DCBindingContainer> <internalRefreshControl> [11851] **** refreshControl() for BindingContainer :uam_view_updateorgPageDef
                        <DCBindingContainer> <internalRefreshControl> [11852] WARNING! Executable:uam_view_updateorgPageDef was already refreshed in prepareModel phase!
                        <ADFLogger> <begin> Refreshing binding container
                        <DCBindingContainer> <internalRefreshControl> [11853] **** refreshControl() for BindingContainer :uam_view_pageDefs_OrgDetailsPageDef_WEB_INF_Updatetaskflow_definition_xml_Updatetaskflow_definition
                        <DCBindingContainerState> <validateToken> [11854] Process BindingContainer state token(decompressed state):BCST:=0%V%=N%R=0%Updatetaskflowdefinition1=BCST:=0%V%=N%R=1%uam_view_pageDefs_OrgDetailsPageDef_WEB_INF_Updatetaskflow_definition_xml_Updatetaskflow_definition=BCST:=0%V%=NUpdUamOrganisation1Iterator=-D-,UpdResPerson1Iterator=-D-,UpdPaymentOptions1Iterator=-D-,DeltMember1Iterator=-D-,UamUserdetailsView1Iterator=-D-,UpdOrganisationUser1Iterator=-D-,UserDetailsViewVO1Iterator=-D-,OrgAddress1Iterator=-D-,%R=2%ImplicitViewCriteriaQuery=BCST:=0;#;eAF9Uz1vE0EQnXwBSQSK8iUooKGI0vhEHYTkr5ATl7PBjomc4ljfjZ1Ndu+OvT37AhISNAiJggZa
                        OioooUa0IAoK/gKioOEPmLmzDSaC7Banm515M/ve29c/YCZWsLRnHbAuywnmd3KV1gG6euPZ592X
                        C9G6mARIQgCYorzVPStQzBWYO2gFuQZTnLUEbnx4fOf9qydb10apk5GCtWEi89o5GXgoci3ue5zw
                        S8VRoSlDcXX768e3u3NuWqvg0hi8G0gZ+L+7pMmPzr/4+en5U3cKlguwslm5tZ2vO6a9WXHyjbxp
                        5QtWuQAXxuN2pf7fsx3btM26mbfMZrnUhFOyxJU+KsA5ucWizUBJpk2/HTRhVZpRCdvcR48+LBa6
                        wUSMTZiWNvaacEbagbZjIZqwKKssiniXaR74NqKHnglzsqrQ5RGFTGpTc5nAAszLndBjGlMKLfor
                        Br7GRG+zUMNSpocRay4MGmafghsWnJXj7TUsDrJS1YyhahbMynISqnKXCQ0rQ7kMkssYhTOgcqLR
                        p+FKTLO78ABOWzAjb5BCf6PWtCLJqGJeVhTvDJpouDyOKwNpJFIYNFsVVcQjnZnCggVZQ3KI4PdQ
                        FQXRkjaatWBZ1hXzI46+TmdC4ivws7MknIA+7QnatPr9/sPJcLh6a7BEde7hzRjVEXVqk0LowcJx
                        54ZJ1mj6BKh1WKkhU+5+PgwFR6+ouE5HHQcbXD1Mjj+PISVvvjS+fb94//rI8xPE9j8x4/Rm6aKM
                        d6Q3c2ImnS7HnhNn+geqU2UdJPqcgSE0iw7bIuh5qeV4aqQrf2rCQWrkVFSnhJpxEY2qb5cL6WM4
                        huL8gXFIphNO0xfGXa4bNNuIkYzsX08vbv8=
                        :#:,,,
                        <LoopDiagnostic> <dump> [11855] variableIterator variables activated <<< [U]:TrackQueryPerformed-null [C]:SearchAppliedCriteria-null SearchAppliedCriteria=data_uam_view_updateorgPageDef_Updatetaskflowdefinition1_uam_view_pageDefs_OrgDetailsPageDef_WEB_INF_Updatetaskflow_definition_xml_Updatetaskflow_definition_ImplicitViewCriteriaQuery
                        <DCExecutableBinding> <refreshIfNeeded> [11856] Invoke refresh for :UserDetailsViewVO1Iterator
                        <DCIteratorBinding> <refresh> [11857] Executing and syncing on IteratorBinding.refresh from :UserDetailsViewVO1Iterator
                        <DCUtil> <findSpelObject> [11858] DCUtil, returning:oracle.jbo.uicli.binding.JUApplication, for AppModuleDataControl
                        <DCJboDataControl> <initializeApplicationModule> [11859] (oracle.adf.model.bc4j.DataControlFactoryImpl.SyncMode = Immediate
                        <ApplicationPoolImpl> <reuseReferencedInstance> [11860] Reusing a cached session application module instance
                        <ApplicationPoolMessageHandler> <doPoolMessage> [11861] **** PoolMessage REQ ATTACH LWS
                        <ADFLogger> <begin> Attaching an iterator binding to a datasource
                        <DCIteratorBinding> <getViewObject> [11862] Resolving VO:UserDetailsViewVO1 for iterator binding:UserDetailsViewVO1Iterator
                        <DCUtil> <findSpelObject> [11863] DCUtil, returning:oracle.adfinternal.view.faces.model.binding.FacesCtrlHierBinding, for UserDetailsViewVO1
                        <ADFLogger> <addContextData> Attaching an iterator binding to a datasource
                        <ADFLogger> <begin> Executing iterator binding
                        <ADFLogger> <begin> Converting rows into hierarchical nodes
                        <JUCtrlHierNodeBinding> <convertRowsToNodes> [11864] Warning! Binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_1742 requires key attributes to be able to locate nodes in the hierarchy.
                        <JUCtrlHierNodeBinding> <convertRowsToNodes> [11865] Mark atleast one attribute as a key attribute in the bean or ViewObject definition for each node type in this hierarchy.
                        <ADFLogger> <addContextData> Converting rows into hierarchical nodes
                        <DCBindingContainer> <validateInputValues> [11866] DCBindingContainer:uam_view_pageDefs_OrgDetailsPageDef_WEB_INF_Updatetaskflow_definition_xml_Updatetaskflow_definition no validations performed
                        <DCBindingContainer> <validateInputValues> [11867] DCBindingContainer:uam_view_updateorgPageDef no validations performed
                        <ADFLogger> <begin> Refreshing binding container
                        <DCBindingContainer> <internalRefreshControl> [11868] **** refreshControl() for BindingContainer :uam_view_updateorgPageDef
                        <ADFLogger> <begin> Refreshing binding container
                        <DCBindingContainer> <internalRefreshControl> [11869] **** refreshControl() for BindingContainer :uam_view_pageDefs_OrgDetailsPageDef_WEB_INF_Updatetaskflow_definition_xml_Updatetaskflow_definition
                        <LoopDiagnostic> <dump> [11870] variableIterator variables passivated >>> TrackQueryPerformed def SearchAppliedCriteria def SearchAppliedCriteria=data_uam_view_updateorgPageDef_Updatetaskflowdefinition1_uam_view_pageDefs_OrgDetailsPageDef_WEB_INF_Updatetaskflow_definition_xml_Updatetaskflow_definition_ImplicitViewCriteriaQuery
                        <DCUtil> <findSpelObject> [11871] DCUtil, returning:oracle.jbo.uicli.binding.JUFormBinding, for uam_view_pageDefs_OrgDetailsPageDef_WEB_INF_Updatetaskflow_definition_xml_Updatetaskflow_definition
                        <JUCtrlHierNodeBinding> <release> [11872] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_48, value:UpdResPerson1Iterator
                        <JUCtrlHierNodeBinding> <release> [11873] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_49, value:UpdResPerson1Iterator
                        <JUCtrlHierNodeBinding> <release> [11874] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_1742, value:UserDetailsViewVO1Iterator
                        <JUCtrlHierNodeBinding> <release> [11875] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_1855, value:DeltMember1Iterator
                        <DCIteratorBinding> <releaseDataInternal> [11876] Releasing iterator binding:UpdUamOrganisation1Iterator
                        <JUCtrlHierNodeBinding> <release> [11877] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_48, value:UpdResPerson1Iterator
                        <JUCtrlHierNodeBinding> <release> [11878] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_49, value:UpdResPerson1Iterator
                        <DCIteratorBinding> <releaseDataInternal> [11879] Releasing iterator binding:UpdResPerson1Iterator
                        <DCIteratorBinding> <releaseDataInternal> [11880] Releasing iterator binding:UpdPaymentOptions1Iterator
                        <DCIteratorBinding> <releaseDataInternal> [11881] Releasing iterator binding:LutPaymentmethodsView1Iterator
                        <JUCtrlHierNodeBinding> <release> [11882] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_1855, value:DeltMember1Iterator
                        <DCIteratorBinding> <releaseDataInternal> [11883] Releasing iterator binding:DeltMember1Iterator
                        <DCIteratorBinding> <releaseDataInternal> [11884] Releasing iterator binding:UamUserdetailsView1Iterator
                        <DCIteratorBinding> <releaseDataInternal> [11885] Releasing iterator binding:UpdOrganisationUser1Iterator
                        <JUCtrlHierNodeBinding> <release> [11886] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_1742, value:UserDetailsViewVO1Iterator
                        <DCIteratorBinding> <releaseDataInternal> [11887] Releasing iterator binding:UserDetailsViewVO1Iterator
                        <JUCtrlHierNodeBinding> <release> [11888] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_1739, value:vcRowsIterator
                        <JUCtrlHierNodeBinding> <release> [11889] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_1740, value:vcRowsIterator
                        <JUCtrlHierNodeBinding> <release> [11890] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_1739, value:vcRowsIterator
                        <JUCtrlHierNodeBinding> <release> [11891] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_1740, value:vcRowsIterator
                        <DCIteratorBinding> <releaseDataInternal> [11892] Releasing iterator binding:vcRowsIterator
                        <DCIteratorBinding> <releaseDataInternal> [11893] Releasing iterator binding:variableIterator
                        <DCIteratorBinding> <releaseDataInternal> [11894] Releasing iterator binding:OrgAddress1Iterator
                        <DCIteratorBinding> <releaseDataInternal> [11895] Releasing iterator binding:Suburb1List_64
                        <DCIteratorBinding> <releaseDataInternal> [11896] Releasing iterator binding:Suburb1List_557
                        <ApplicationPoolMessageHandler> <doPoolMessage> [11897] **** PoolMessage REQ ATTACH LWS
                        <ApplicationPoolMessageHandler> <doPoolMessage> [11898] **** PoolMessage REQ DETACH LWS
                        <DCJboDataControl> <initializeApplicationModule> [11899] (oracle.adf.model.bc4j.DataControlFactoryImpl.SyncMode = Immediate
                        <DCJboDataControl> <initializeApplicationModule> [11900] (oracle.adf.model.bc4j.DataControlFactoryImpl.SyncMode = Immediate
                        <DCJboDataControl> <initializeApplicationModule> [11901] (oracle.adf.model.bc4j.DataControlFactoryImpl.SyncMode = Immediate
                        <DCJboDataControl> <initializeApplicationModule> [11902] (oracle.adf.model.bc4j.DataControlFactoryImpl.SyncMode = Immediate
                        <ADFLogger> <begin> Refreshing binding container
                        <DCBindingContainer> <internalRefreshControl> [11903] **** refreshControl() for BindingContainer :uam_view_updateorgPageDef
                        <DCBindingContainer> <internalRefreshControl> [11904] WARNING! Executable:uam_view_updateorgPageDef was already refreshed in prepareModel phase!
                        <ADFLogger> <begin> Refreshing binding container
                        <DCBindingContainer> <internalRefreshControl> [11905] **** refreshControl() for BindingContainer :uam_view_pageDefs_OrgDetailsPageDef_WEB_INF_Updatetaskflow_definition_xml_Updatetaskflow_definition
                        <DCBindingContainerState> <validateToken> [11906] Process BindingContainer state token(decompressed state):BCST:=0%V%=N%R=0%Updatetaskflowdefinition1=BCST:=0%V%=N%R=1%uam_view_pageDefs_OrgDetailsPageDef_WEB_INF_Updatetaskflow_definition_xml_Updatetaskflow_definition=BCST:=0%V%=NUpdUamOrganisation1Iterator=-D-,UpdResPerson1Iterator=-D-,UpdPaymentOptions1Iterator=-D-,DeltMember1Iterator=-D-,UamUserdetailsView1Iterator=-D-,UpdOrganisationUser1Iterator=-D-,UserDetailsViewVO1Iterator=-D-,OrgAddress1Iterator=-D-,%R=2%ImplicitViewCriteriaQuery=BCST:=0;#;eAF9Uz1vE0EQnXwBSQSK8iUooKGI0vhEHYTkr5ATl7PBjomc4ljfjZ1Ndu+OvT37AhISNAiJggZa
                        OioooUa0IAoK/gKioOEPmLmzDSaC7Banm515M/ve29c/YCZWsLRnHbAuywnmd3KV1gG6euPZ592X
                        C9G6mARIQgCYorzVPStQzBWYO2gFuQZTnLUEbnx4fOf9qydb10apk5GCtWEi89o5GXgoci3ue5zw
                        S8VRoSlDcXX768e3u3NuWqvg0hi8G0gZ+L+7pMmPzr/4+en5U3cKlguwslm5tZ2vO6a9WXHyjbxp
                        5QtWuQAXxuN2pf7fsx3btM26mbfMZrnUhFOyxJU+KsA5ucWizUBJpk2/HTRhVZpRCdvcR48+LBa6
                        wUSMTZiWNvaacEbagbZjIZqwKKssiniXaR74NqKHnglzsqrQ5RGFTGpTc5nAAszLndBjGlMKLfor
                        Br7GRG+zUMNSpocRay4MGmafghsWnJXj7TUsDrJS1YyhahbMynISqnKXCQ0rQ7kMkssYhTOgcqLR
                        p+FKTLO78ABOWzAjb5BCf6PWtCLJqGJeVhTvDJpouDyOKwNpJFIYNFsVVcQjnZnCggVZQ3KI4PdQ
                        FQXRkjaatWBZ1hXzI46+TmdC4ivws7MknIA+7QnatPr9/sPJcLh6a7BEde7hzRjVEXVqk0LowcJx
                        54ZJ1mj6BKh1WKkhU+5+PgwFR6+ouE5HHQcbXD1Mjj+PISVvvjS+fb94//rI8xPE9j8x4/Rm6aKM
                        d6Q3c2ImnS7HnhNn+geqU2UdJPqcgSE0iw7bIuh5qeV4aqQrf2rCQWrkVFSnhJpxEY2qb5cL6WM4
                        huL8gXFIphNO0xfGXa4bNNuIkYzsX08vbv8=
                        :#:,,,
                        <LoopDiagnostic> <dump> [11907] variableIterator variables activated <<< [U]:TrackQueryPerformed-null [C]:SearchAppliedCriteria-null SearchAppliedCriteria=data_uam_view_updateorgPageDef_Updatetaskflowdefinition1_uam_view_pageDefs_OrgDetailsPageDef_WEB_INF_Updatetaskflow_definition_xml_Updatetaskflow_definition_ImplicitViewCriteriaQuery
                        <DCExecutableBinding> <refreshIfNeeded> [11908] Invoke refresh for :UpdUamOrganisation1Iterator
                        <DCIteratorBinding> <refresh> [11909] Executing and syncing on IteratorBinding.refresh from :UpdUamOrganisation1Iterator
                        <DCUtil> <findSpelObject> [11910] DCUtil, returning:oracle.jbo.uicli.binding.JUApplication, for UpdAppModuleDataControl
                        <DCJboDataControl> <initializeApplicationModule> [11911] (oracle.adf.model.bc4j.DataControlFactoryImpl.SyncMode = Immediate
                        <ApplicationPoolImpl> <reuseReferencedInstance> [11912] Reusing a cached session application module instance
                        <ApplicationPoolMessageHandler> <doPoolMessage> [11913] **** PoolMessage REQ ATTACH LWS
                        <ADFLogger> <begin> Attaching an iterator binding to a datasource
                        <DCIteratorBinding> <getViewObject> [11914] Resolving VO:UpdUamOrganisation1 for iterator binding:UpdUamOrganisation1Iterator
                        <ADFLogger> <addContextData> Attaching an iterator binding to a datasource
                        <ADFLogger> <begin> Get LOV list
                        <JUMetaObjectManager> <getControlDefinitionFactory> [11915] JUMOM - CTRL_DEF_FACTORY not found: [ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'
                        <JUMetaObjectManager> <getControlDefinitionFactory> [11916] JUMOM - factory from map: oracle.adfinternal.view.faces.model.binding.FacesBindingDefFactoryImpl, [ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'
                        <DCUtil> <findSpelObject> [11917] DCUtil, returning:oracle.jbo.uicli.binding.JUApplication, for UpdAppModuleDataControl
                        <ADFLogger> <addContextData> Get LOV list
                        <DCExecutableBinding> <refreshIfNeeded> [11918] Invoke refresh for :OrgAddress1Iterator
                        <DCIteratorBinding> <refresh> [11919] Executing and syncing on IteratorBinding.refresh from :OrgAddress1Iterator
                        <DCUtil> <findSpelObject> [11920] DCUtil, returning:oracle.jbo.uicli.binding.JUApplication, for UpdAppModuleDataControl
                        <ADFLogger> <begin> Attaching an iterator binding to a datasource
                        <DCIteratorBinding> <getViewObject> [11921] Resolving VO:OrgAddress1 for iterator binding:OrgAddress1Iterator
                        <ADFLogger> <addContextData> Attaching an iterator binding to a datasource
                        <ADFLogger> <begin> Evaluate Expression
                        <ADFLogger> <begin> Evaluate Expression
                        <DCUtil> <findSpelObject> [11922] DCUtil, returning:oracle.jbo.uicli.binding.JUApplication, for AppModuleDataControl
                        <DCJboDataControl> <initializeApplicationModule> [11923] (oracle.adf.model.bc4j.DataControlFactoryImpl.SyncMode = Immediate
                        <ApplicationPoolImpl> <reuseReferencedInstance> [11924] Reusing a cached session application module instance
                        <ApplicationPoolMessageHandler> <doPoolMessage> [11925] **** PoolMessage REQ ATTACH LWS
                        <DCIteratorBinding> <getViewObject> [11926] Resolving VO:UserDetailsViewVO1 for iterator binding:UserDetailsViewVO1Iterator
                        <DCUtil> <findSpelObject> [11927] DCUtil, returning:oracle.adfinternal.view.faces.model.binding.FacesCtrlHierBinding, for UserDetailsViewVO1
                        <ADFLogger> <begin> Evaluate Expression
                        <ADFLogger> <begin> Evaluate Expression
                        <ADFLogger> <begin> Evaluate Expression
                        <JboBeanUtils> <getProperty> [11928] *** Using bean introspection to lookup value :dataControl
                        <ADFLogger> <begin> Refreshing binding container
                        <DCBindingContainer> <internalRefreshControl> [11929] **** refreshControl() for BindingContainer :ImplicitViewCriteriaQuery
                        <DCExecutableBinding> <refreshIfNeeded> [11930] Invoke refresh for :vcRowsIterator
                        <DCIteratorBinding> <refresh> [11931] Executing and syncing on IteratorBinding.refresh from :vcRowsIterator
                        <ADFLogger> <begin> Attaching an iterator binding to a datasource
                        <JboBeanUtils> <getProperty> [11932] *** Using bean introspection to lookup value :result
                        <DebugDiagnostic> <print> [11933] DBG: beforeActionPerformed :GetViewCriteria
                        <ADFLogger> <begin> Evaluate Expression
                        <JboBeanUtils> <getProperty> [11934] *** Using bean introspection to lookup value :dataControl
                        <JUCtrlActionBinding> <doIt> [11935] Invoke method Action:999
                        <ADFLogger> <begin> Evaluate Expression
                        <ADFLogger> <begin> Evaluate Expression
                        <ADFLogger> <begin> Evaluate Expression
                        <ADFLogger> <begin> Executing method binding
                        <DCInvokeMethod> <invokeMethod> [11936] DCInvokeMethod:Invoking oracle.jbo.uicli.binding.JUSearchBindingCustomizer.findOrCreateViewCriteria()
                        <DebugDiagnostic> <print> [11937] DBG: afterActionPerformed :GetViewCriteria
                        <DCUtil> <findSpelObject> [11938] DCUtil, returning:oracle.jbo.common.ViewCriteriaImpl, for result
                        <DCJboDataControl> <initializeApplicationModule> [11939] (oracle.adf.model.bc4j.DataControlFactoryImpl.SyncMode = Immediate
                        <ApplicationPoolImpl> <recycleUnreferencedInstance> [11940] Recycling an unreferenced, available pool instance
                        <ADFLogger> <begin> Rollback transaction
                        <ApplicationModuleImpl> <resetState> [11941] Resetting AM=Root
                        <PropertyManager> <loadProperties> [11942] Propertymanager: skipping reload of file and system based properties
                        <PropertyManager> <loadProperties> [11943] {{ begin Loading BC4J properties 
                        <PropertyManager> <loadProperties> [11944] -----------------------------------------------------------
                        <PropertyManager> <loadProperty> [11945] BC4J Property jbo.default.language='en' -->(MetaObjectManager) from System Default
                        <PropertyManager> <loadProperty> [11946] BC4J Property jbo.default.country='ZA' -->(MetaObjectManager) from System Default
                        <PropertyManager> <loadProperty> [11947] Skipping empty Property jbo.default.locale.variant from System Default
                        <PropertyManager> <loadProperty> [11948] BC4J Property DeployPlatform='LOCAL' -->(SessionImpl) from Client Environment
                        <PropertyManager> <loadProperty> [11949] Skipping empty Property ConnectionMode from System Default
                        <PropertyManager> <loadProperty> [11950] Skipping empty Property HostName from System Default
                        <PropertyManager> <loadProperty> [11951] Skipping empty Property ConnectionPort from System Default
                        <PropertyManager> <loadProperty> [11952] BC4J Property jbo.locking.mode='optimistic' -->(MetaObjectManager) from Client Environment
                        <PropertyManager> <loadProperty> [11953] BC4J Property jbo.txn.disconnect_level='0' -->(SessionImpl) from System Default
                        <PropertyManager> <loadProperty> [11954] Skipping empty Property ApplicationPath from System Default
                        <PropertyManager> <loadProperty> [11955] BC4J Property AppModuleJndiName='$DefaultAppModule' -->(SessionImpl) from Client Environment
                        <PropertyManager> <loadProperty> [11956] Skipping empty Property java.naming.security.principal from System Default
                        <PropertyManager> <loadProperty> [11957] Skipping empty Property java.naming.security.credentials from System Default
                        <PropertyManager> <loadProperty> [11958] Skipping empty Property jbo.user.principal from System Default
                        <PropertyManager> <loadProperty> [11959] BC4J Property jbo.simulate.remote='false' -->(SessionImpl) from System Default
                        <PropertyManager> <loadProperty> [11960] BC4J Property jbo.security.context='oracle.security.jazn' -->(MetaObjectManager) from System Default
                        <PropertyManager> <loadProperty> [11961] Skipping empty Property jbo.object.marshaller from System Default
                        <PropertyManager> <loadProperty> [11962] BC4J Property jbo.use.pers.coll='false' -->(SessionImpl) from System Default
                        <PropertyManager> <loadProperty> [11963] BC4J Property jbo.pers.max.rows.per.node='70' -->(SessionImpl) from System Default
                        <PropertyManager> <loadProperty> [11964] BC4J Property jbo.pers.max.active.nodes='30' -->(SessionImpl) from System Default
                        <PropertyManager> <loadProperty> [11965] BC4J Property jbo.validation.threshold='10' -->(SessionImpl) from System Default
                        <PropertyManager> <loadProperty> [11966] BC4J Property jbo.sparse.array.threshold='20' -->(SessionImpl) from System Default
                        <PropertyManager> <loadProperty> [11967] Skipping empty Property jbo.pcoll.mgr from System Default
                        <PropertyManager> <loadProperty> [11968] BC4J Property jbo.txn_table_name='PS_TXN' -->(SessionImpl) from System Default
                        <PropertyManager> <loadProperty> [11969] BC4J Property jbo.txn_seq_name='PS_TXN_seq' -->(SessionImpl) from System Default
                        <PropertyManager> <loadProperty> [11970] BC4J Property jbo.txn_seq_inc='50' -->(SessionImpl) from System Default
                        <PropertyManager> <loadProperty> [11971] BC4J Property jbo.control_table_name='PCOLL_CONTROL' -->(MetaObjectManager) from System Default
                        <PropertyManager> <loadProperty> [11972] BC4J Property jbo.stringmanager.factory.class='use_default' -->(SessionImpl) from System Default
                        <PropertyManager> <loadProperty> [11973] BC4J Property jbo.domain.date.suppress_zero_time='true' -->(MetaObjectManager) from System Default
                        <PropertyManager> <loadProperty> [11974] BC4J Property jbo.domain.bind_sql_date='true' -->(MetaObjectManager) from System Default
                        <PropertyManager> <loadProperty> [11975] BC4J Property jbo.domain.string.as.bytes.for.raw='false' -->(MetaObjectManager) from System Default
                        <PropertyManager> <loadProperty> [11976] BC4J Property jbo.fetch.mode='AS.NEEDED' -->(MetaObjectManager) from System Default
                        <PropertyManager> <loadProperty> [11977] BC4J Property jbo.323.compatible='false' -->(MetaObjectManager) from System Default
                        <PropertyManager> <loadProperty> [11978] BC4J Property jbo.903.compatible='false' -->(MetaObjectManager) from System Default
                        <PropertyManager> <loadProperty> [11979] Skipping empty Property JBODynamicObjectsPackage from System Default
                        <PropertyManager> <loadProperty> [11980] BC4J Property MetaObjectContextFactory='oracle.jbo.mom.xml.DefaultMomContextFactory' -->(MetaObjectManager) from System Default
                        <PropertyManager> <loadProperty> [11981] BC4J Property jbo.load.components.lazily='false' -->(MetaObjectManager) from System Default
                        <PropertyManager> <loadProperty> [11982] BC4J Property MetaObjectContext='oracle.jbo.mom.xml.XMLContextImpl' -->(MetaObjectManager) from System Default
                        <PropertyManager> <loadProperty> [11983] BC4J Property java.naming.factory.initial='oracle.jbo.common.JboInitialContextFactory' -->(SessionImpl) from Client Environment
                        <PropertyManager> <loadProperty> [11984] BC4J Property IsLazyLoadingTrue='true' -->(MetaObjectManager) from /oracle/jbo/server/jboserver.properties resource
                        <PropertyManager> <loadProperty> [11985] BC4J Property oracle.jbo.usemds='true' -->(MetaObjectManager) from System Default
                        <PropertyManager> <loadProperty> [11986] BC4J Property oracle.adfm.usemds='true' -->(MetaObjectManager) from System Default
                        <PropertyManager> <loadProperty> [11987] BC4J Property ActivateSharedDataHandle='false' -->(MetaObjectManager) from System Default
                        <PropertyManager> <loadProperty> [11988] Skipping empty Property HandleName from System Default
                        <PropertyManager> <loadProperty> [11989] Skipping empty Property Factory-Substitution-List from System Default
                        <PropertyManager> <loadProperty> [11990] WARNING: Property jbo.projectset to null
                        <PropertyManager> <loadProperty> [11991] Skipping empty Property jbo.project from null
                        <PropertyManager> <loadProperty> [11992] BC4J Property jbo.max.cursors='50' -->(MetaObjectManager) from System Default
                        <PropertyManager> <loadProperty> [11993] BC4J Property jbo.dofailover='false' -->(Configuration) from Client Environment
                        <PropertyManager> <loadProperty> [11994] WARNING: Property jbo.envinfoproviderset to null
                        <PropertyManager> <loadProperty> [11995] Skipping empty Property jbo.envinfoprovider from null
                        <PropertyManager> <loadProperty> [11996] Skipping empty Property jbo.rowid_am_conn_name from System Default
                        <PropertyManager> <loadProperty> [11997] Skipping empty Property jbo.rowid_am_datasource_name from System Default
                        <PropertyManager> <loadProperty> [11998] WARNING: Property jbo.ampool.writecookietoclientset to null
                        <PropertyManager> <loadProperty> [11999] Skipping empty Property jbo.ampool.writecookietoclient from null
                        <PropertyManager> <loadProperty> [12000] WARNING: Property jbo.doconnectionpoolingset to null
                        <PropertyManager> <loadProperty> [12001] Skipping empty Property jbo.doconnectionpooling from null
                        <PropertyManager> <loadProperty> [12002] BC4J Property jbo.recyclethreshold='10' -->(Configuration) from Client Environment
                        <PropertyManager> <loadProperty> [12003] WARNING: Property jbo.ampool.dynamicjdbccredentialsset to null
                        <PropertyManager> <loadProperty> [12004] Skipping empty Property jbo.ampool.dynamicjdbccredentials from null
                        <PropertyManager> <loadProperty> [12005] BC4J Property jbo.ampool.resetnontransactionalstate='true' -->(SessionImpl) from System Default
                        <PropertyManager> <loadProperty> [12006] BC4J Property jbo.ampool.sessioncookiefactoryclass='oracle.jbo.common.ampool.DefaultSessionCookieFactory' -->(Configuration) from Client Environment
                        <PropertyManager> <loadProperty> [12007] BC4J Property jbo.ampool.connectionstrategyclass='oracle.jbo.common.ampool.DefaultConnectionStrategy' -->(Configuration) from Client Environment
                        <PropertyManager> <loadProperty> [12008] BC4J Property jbo.ampool.maxpoolsize='-1' -->(Configuration) from Client Environment
                        <PropertyManager> <loadProperty> [12009] BC4J Property jbo.ampool.initpoolsize='0' -->(Configuration) from Client Environment
                        <PropertyManager> <loadProperty> [12010] WARNING: Property jbo.ampool.monitorsleepintervalset to null
                        <PropertyManager> <loadProperty> [12011] Skipping empty Property jbo.ampool.monitorsleepinterval from null
                        <PropertyManager> <loadProperty> [12012] WARNING: Property jbo.ampool.minavailablesizeset to null
                        <PropertyManager> <loadProperty> [12013] Skipping empty Property jbo.ampool.minavailablesize from null
                        <PropertyManager> <loadProperty> [12014] WARNING: Property jbo.ampool.maxavailablesizeset to null
                        <PropertyManager> <loadProperty> [12015] Skipping empty Property jbo.ampool.maxavailablesize from null
                        <PropertyManager> <loadProperty> [12016] WARNING: Property jbo.ampool.maxinactiveageset to null
                        <PropertyManager> <loadProperty> [12017] Skipping empty Property jbo.ampool.maxinactiveage from null
                        <PropertyManager> <loadProperty> [12018] BC4J Property jbo.ampool.timetolive='3600000' -->(Configuration) from Client Environment
                        <PropertyManager> <loadProperty> [12019] BC4J Property jbo.ampool.doampooling='true' -->(Configuration) from Client Environment
                        <PropertyManager> <loadProperty> [12020] BC4J Property jbo.ampool.issupportspassivation='false' -->(Configuration) from Client Environment
                        <PropertyManager> <loadProperty> [12021] BC4J Property jbo.ampool.isuseexclusive='true' -->(SessionImpl) from Client Environment
                        <PropertyManager> <loadProperty> [12022] BC4J Property jbo.passivationstore='null' -->(MetaObjectManager) from System Default
                        <PropertyManager> <loadProperty> [12023] BC4J Property jbo.saveforlater='false' -->(SessionImpl) from System Default
                        <PropertyManager> <loadProperty> [12024] BC4J Property jbo.snapshotstore.undo='persistent' -->(SessionImpl) from System Default
                        Edited by: adf009 on 201
                        • 9. Re: Inserting Rows to ADF View Object Programatically with foreign table value
                          Timo Hahn
                          adf009,
                          once again, I have to say that you have not tested your code in a debug session. You are telling us that your code to add rows to the other table is called. However, when I look through the log output you pasted in your last post, I can't find the output your code should have put to this log. Conclusion, your code is not called!
                          Back to the beginning: you have to learn to use a debugger to step through your code!
                          More advice: if you explain a problem it makes sense to tell us e.g. which VO or row you use to copy which attributes into new rows of which target VO. Try to write it down in words in a way one can understand without looking in your code at all. This helps you too as you have to think about the program flow as you write it down. You may find the problem this way yourself.

                          Timo
                          • 10. Re: Inserting Rows to ADF View Object Programatically with foreign table value
                            Tshifhiwa
                            ok timo i deburg ,i found out that when i click my add button it open an empty row in the current table am geting the bindings for TargetVO .i use VO UserDetailsViewVO1" to get the bindings for TargetVO THE TARGET vo is DeltMember which has iterator DeltMember1Iterator
                            {code}
                            log error is
                            <DCJboDataControl> <initializeApplicationModule> [12242] (oracle.adf.model.bc4j.DataControlFactoryImpl.SyncMode = Immediate
                            <DCJboDataControl> <initializeApplicationModule> [12243] (oracle.adf.model.bc4j.DataControlFactoryImpl.SyncMode = Immediate
                            <DCJboDataControl> <initializeApplicationModule> [12244] (oracle.adf.model.bc4j.DataControlFactoryImpl.SyncMode = Immediate
                            <DCJboDataControl> <initializeApplicationModule> [12245] (oracle.adf.model.bc4j.DataControlFactoryImpl.SyncMode = Immediate
                            <ADFLogger> <begin> Refreshing binding container
                            <DCBindingContainer> <internalRefreshControl> [12246] **** refreshControl() for BindingContainer :uam_view_updateorgPageDef
                            <DCBindingContainer> <internalRefreshControl> [12247] WARNING! Executable:uam_view_updateorgPageDef was already refreshed in prepareModel phase!
                            <ADFLogger> <begin> Refreshing binding container
                            <DCBindingContainer> <internalRefreshControl> [12248] **** refreshControl() for BindingContainer :uam_view_pageDefs_OrgDetailsPageDef_WEB_INF_Updatetaskflow_definition_xml_Updatetaskflow_definition
                            <DCBindingContainerState> <validateToken> [12249] Process BindingContainer state token(decompressed state):BCST:=0%V%=N%R=0%Updatetaskflowdefinition1=BCST:=0%V%=N%R=1%uam_view_pageDefs_OrgDetailsPageDef_WEB_INF_Updatetaskflow_definition_xml_Updatetaskflow_definition=BCST:=0%V%=NUpdUamOrganisation1Iterator=-D-,UpdResPerson1Iterator=-D-,UpdPaymentOptions1Iterator=-D-,DeltMember1Iterator=-D-,UamUserdetailsView1Iterator=-D-,UpdOrganisationUser1Iterator=-D-,UserDetailsViewVO1Iterator=-D-,OrgAddress1Iterator=-D-,%R=2%ImplicitViewCriteriaQuery=BCST:=0;#;eAF9Uz1vE0EQnXwBSQSK8iUooKGI0vhEHYTkr5ATl7PBjomc4ljfjZ1Ndu+OvT37AhISNAiJggZa
                            OioooUa0IAoK/gKioOEPmLmzDSaC7Banm515M/ve29c/YCZWsLRnHbAuywnmd3KV1gG6euPZ592X
                            C9G6mARIQgCYorzVPStQzBWYO2gFuQZTnLUEbnx4fOf9qydb10apk5GCtWEi89o5GXgoci3ue5zw
                            S8VRoSlDcXX768e3u3NuWqvg0hi8G0gZ+L+7pMmPzr/4+en5U3cKlguwslm5tZ2vO6a9WXHyjbxp
                            5QtWuQAXxuN2pf7fsx3btM26mbfMZrnUhFOyxJU+KsA5ucWizUBJpk2/HTRhVZpRCdvcR48+LBa6
                            wUSMTZiWNvaacEbagbZjIZqwKKssiniXaR74NqKHnglzsqrQ5RGFTGpTc5nAAszLndBjGlMKLfor
                            Br7GRG+zUMNSpocRay4MGmafghsWnJXj7TUsDrJS1YyhahbMynISqnKXCQ0rQ7kMkssYhTOgcqLR
                            p+FKTLO78ABOWzAjb5BCf6PWtCLJqGJeVhTvDJpouDyOKwNpJFIYNFsVVcQjnZnCggVZQ3KI4PdQ
                            FQXRkjaatWBZ1hXzI46+TmdC4ivws7MknIA+7QnatPr9/sPJcLh6a7BEde7hzRjVEXVqk0LowcJx
                            54ZJ1mj6BKh1WKkhU+5+PgwFR6+ouE5HHQcbXD1Mjj+PISVvvjS+fb94//rI8xPE9j8x4/Rm6aKM
                            d6Q3c2ImnS7HnhNn+geqU2UdJPqcgSE0iw7bIuh5qeV4aqQrf2rCQWrkVFSnhJpxEY2qb5cL6WM4
                            huL8gXFIphNO0xfGXa4bNNuIkYzsX08vbv8=
                            :#:,,,
                            <LoopDiagnostic> <dump> [12250] variableIterator variables activated <<< :TrackQueryPerformed-null [C]:SearchAppliedCriteria-null SearchAppliedCriteria=data_uam_view_updateorgPageDef_Updatetaskflowdefinition1_uam_view_pageDefs_OrgDetailsPageDef_WEB_INF_Updatetaskflow_definition_xml_Updatetaskflow_definition_ImplicitViewCriteriaQuery
                            <DCExecutableBinding> <refreshIfNeeded> [12251] Invoke refresh for :UserDetailsViewVO1Iterator
                            <DCIteratorBinding> <refresh> [12252] Executing and syncing on IteratorBinding.refresh from :UserDetailsViewVO1Iterator
                            <DCUtil> <findSpelObject> [12253] DCUtil, returning:oracle.jbo.uicli.binding.JUApplication, for AppModuleDataControl
                            <DCJboDataControl> <initializeApplicationModule> [12254] (oracle.adf.model.bc4j.DataControlFactoryImpl.SyncMode = Immediate
                            <ApplicationPoolImpl> <reuseReferencedInstance> [12255] Reusing a cached session application module instance
                            <ApplicationPoolMessageHandler> <doPoolMessage> [12256] **** PoolMessage REQ ATTACH LWS
                            <ADFLogger> <begin> Attaching an iterator binding to a datasource
                            <DCIteratorBinding> <getViewObject> [12257] Resolving VO:UserDetailsViewVO1 for iterator binding:UserDetailsViewVO1Iterator
                            <DCUtil> <findSpelObject> [12258] DCUtil, returning:oracle.adfinternal.view.faces.model.binding.FacesCtrlHierBinding, for UserDetailsViewVO1
                            <ADFLogger> <addContextData> Attaching an iterator binding to a datasource
                            <ADFLogger> <begin> Executing iterator binding
                            <ADFLogger> <begin> Converting rows into hierarchical nodes
                            <JUCtrlHierNodeBinding> <convertRowsToNodes> [12259] Warning! Binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_1249 requires key attributes to be able to locate nodes in the hierarchy.
                            <JUCtrlHierNodeBinding> <convertRowsToNodes> [12260] Mark atleast one attribute as a key attribute in the bean or ViewObject definition for each node type in this hierarchy.
                            <ADFLogger> <addContextData> Converting rows into hierarchical nodes
                            <DCBindingContainer> <validateInputValues> [12261] DCBindingContainer:uam_view_pageDefs_OrgDetailsPageDef_WEB_INF_Updatetaskflow_definition_xml_Updatetaskflow_definition no validations performed
                            <DCBindingContainer> <validateInputValues> [12262] DCBindingContainer:uam_view_updateorgPageDef no validations performed
                            <ADFLogger> <begin> Refreshing binding container
                            <DCBindingContainer> <internalRefreshControl> [12263] **** refreshControl() for BindingContainer :uam_view_updateorgPageDef
                            <ADFLogger> <begin> Refreshing binding container
                            <DCBindingContainer> <internalRefreshControl> [12264] **** refreshControl() for BindingContainer :uam_view_pageDefs_OrgDetailsPageDef_WEB_INF_Updatetaskflow_definition_xml_Updatetaskflow_definition
                            <LoopDiagnostic> <dump> [12265] variableIterator variables passivated >>> TrackQueryPerformed def SearchAppliedCriteria def SearchAppliedCriteria=data_uam_view_updateorgPageDef_Updatetaskflowdefinition1_uam_view_pageDefs_OrgDetailsPageDef_WEB_INF_Updatetaskflow_definition_xml_Updatetaskflow_definition_ImplicitViewCriteriaQuery
                            <DCUtil> <findSpelObject> [12266] DCUtil, returning:oracle.jbo.uicli.binding.JUFormBinding, for uam_view_pageDefs_OrgDetailsPageDef_WEB_INF_Updatetaskflow_definition_xml_Updatetaskflow_definition
                            <JUCtrlHierNodeBinding> <release> [12267] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_47, value:UpdResPerson1Iterator
                            <JUCtrlHierNodeBinding> <release> [12268] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_48, value:UpdResPerson1Iterator
                            <JUCtrlHierNodeBinding> <release> [12269] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_1249, value:UserDetailsViewVO1Iterator
                            <JUCtrlHierNodeBinding> <release> [12270] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_1362, value:DeltMember1Iterator
                            <DCIteratorBinding> <releaseDataInternal> [12271] Releasing iterator binding:UpdUamOrganisation1Iterator
                            <JUCtrlHierNodeBinding> <release> [12272] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_47, value:UpdResPerson1Iterator
                            <JUCtrlHierNodeBinding> <release> [12273] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_48, value:UpdResPerson1Iterator
                            <DCIteratorBinding> <releaseDataInternal> [12274] Releasing iterator binding:UpdResPerson1Iterator
                            <DCIteratorBinding> <releaseDataInternal> [12275] Releasing iterator binding:UpdPaymentOptions1Iterator
                            <DCIteratorBinding> <releaseDataInternal> [12276] Releasing iterator binding:LutPaymentmethodsView1Iterator
                            <JUCtrlHierNodeBinding> <release> [12277] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_1362, value:DeltMember1Iterator
                            <DCIteratorBinding> <releaseDataInternal> [12278] Releasing iterator binding:DeltMember1Iterator
                            <DCIteratorBinding> <releaseDataInternal> [12279] Releasing iterator binding:UamUserdetailsView1Iterator
                            <DCIteratorBinding> <releaseDataInternal> [12280] Releasing iterator binding:UpdOrganisationUser1Iterator
                            <JUCtrlHierNodeBinding> <release> [12281] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_1249, value:UserDetailsViewVO1Iterator
                            <DCIteratorBinding> <releaseDataInternal> [12282] Releasing iterator binding:UserDetailsViewVO1Iterator
                            <JUCtrlHierNodeBinding> <release> [12283] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_1246, value:vcRowsIterator
                            <JUCtrlHierNodeBinding> <release> [12284] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_1247, value:vcRowsIterator
                            <JUCtrlHierNodeBinding> <release> [12285] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_1246, value:vcRowsIterator
                            <JUCtrlHierNodeBinding> <release> [12286] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_1247, value:vcRowsIterator
                            <DCIteratorBinding> <releaseDataInternal> [12287] Releasing iterator binding:vcRowsIterator
                            <DCIteratorBinding> <releaseDataInternal> [12288] Releasing iterator binding:variableIterator
                            <DCIteratorBinding> <releaseDataInternal> [12289] Releasing iterator binding:OrgAddress1Iterator
                            <DCIteratorBinding> <releaseDataInternal> [12290] Releasing iterator binding:Suburb1List_70
                            <ApplicationPoolMessageHandler> <doPoolMessage> [12291] **** PoolMessage REQ ATTACH LWS
                            <ApplicationPoolMessageHandler> <doPoolMessage> [12292] **** PoolMessage REQ DETACH LWS
                            <DCJboDataControl> <initializeApplicationModule> [12293] (oracle.adf.model.bc4j.DataControlFactoryImpl.SyncMode = Immediate
                            <DCJboDataControl> <initializeApplicationModule> [12294] (oracle.adf.model.bc4j.DataControlFactoryImpl.SyncMode = Immediate
                            <DCJboDataControl> <initializeApplicationModule> [12295] (oracle.adf.model.bc4j.DataControlFactoryImpl.SyncMode = Immediate
                            <DCJboDataControl> <initializeApplicationModule> [12296] (oracle.adf.model.bc4j.DataControlFactoryImpl.SyncMode = Immediate
                            <ADFLogger> <begin> Refreshing binding container
                            <DCBindingContainer> <internalRefreshControl> [12297] **** refreshControl() for BindingContainer :uam_view_updateorgPageDef
                            <DCBindingContainer> <internalRefreshControl> [12298] WARNING! Executable:uam_view_updateorgPageDef was already refreshed in prepareModel phase!
                            <ADFLogger> <begin> Refreshing binding container
                            <DCBindingContainer> <internalRefreshControl> [12299] **** refreshControl() for BindingContainer :uam_view_pageDefs_OrgDetailsPageDef_WEB_INF_Updatetaskflow_definition_xml_Updatetaskflow_definition
                            <DCBindingContainerState> <validateToken> [12300] Process BindingContainer state token(decompressed state):BCST:=0%V%=N%R=0%Updatetaskflowdefinition1=BCST:=0%V%=N%R=1%uam_view_pageDefs_OrgDetailsPageDef_WEB_INF_Updatetaskflow_definition_xml_Updatetaskflow_definition=BCST:=0%V%=NUpdUamOrganisation1Iterator=-D-,UpdResPerson1Iterator=-D-,UpdPaymentOptions1Iterator=-D-,DeltMember1Iterator=-D-,UamUserdetailsView1Iterator=-D-,UpdOrganisationUser1Iterator=-D-,UserDetailsViewVO1Iterator=-D-,OrgAddress1Iterator=-D-,%R=2%ImplicitViewCriteriaQuery=BCST:=0;#;eAF9Uz1vE0EQnXwBSQSK8iUooKGI0vhEHYTkr5ATl7PBjomc4ljfjZ1Ndu+OvT37AhISNAiJggZa
                            OioooUa0IAoK/gKioOEPmLmzDSaC7Banm515M/ve29c/YCZWsLRnHbAuywnmd3KV1gG6euPZ592X
                            C9G6mARIQgCYorzVPStQzBWYO2gFuQZTnLUEbnx4fOf9qydb10apk5GCtWEi89o5GXgoci3ue5zw
                            S8VRoSlDcXX768e3u3NuWqvg0hi8G0gZ+L+7pMmPzr/4+en5U3cKlguwslm5tZ2vO6a9WXHyjbxp
                            5QtWuQAXxuN2pf7fsx3btM26mbfMZrnUhFOyxJU+KsA5ucWizUBJpk2/HTRhVZpRCdvcR48+LBa6
                            wUSMTZiWNvaacEbagbZjIZqwKKssiniXaR74NqKHnglzsqrQ5RGFTGpTc5nAAszLndBjGlMKLfor
                            Br7GRG+zUMNSpocRay4MGmafghsWnJXj7TUsDrJS1YyhahbMynISqnKXCQ0rQ7kMkssYhTOgcqLR
                            p+FKTLO78ABOWzAjb5BCf6PWtCLJqGJeVhTvDJpouDyOKwNpJFIYNFsVVcQjnZnCggVZQ3KI4PdQ
                            FQXRkjaatWBZ1hXzI46+TmdC4ivws7MknIA+7QnatPr9/sPJcLh6a7BEde7hzRjVEXVqk0LowcJx
                            54ZJ1mj6BKh1WKkhU+5+PgwFR6+ouE5HHQcbXD1Mjj+PISVvvjS+fb94//rI8xPE9j8x4/Rm6aKM
                            d6Q3c2ImnS7HnhNn+geqU2UdJPqcgSE0iw7bIuh5qeV4aqQrf2rCQWrkVFSnhJpxEY2qb5cL6WM4
                            huL8gXFIphNO0xfGXa4bNNuIkYzsX08vbv8=
                            :#:,,,
                            <LoopDiagnostic> <dump> [12301] variableIterator variables activated <<< [U]:TrackQueryPerformed-null [C]:SearchAppliedCriteria-null SearchAppliedCriteria=data_uam_view_updateorgPageDef_Updatetaskflowdefinition1_uam_view_pageDefs_OrgDetailsPageDef_WEB_INF_Updatetaskflow_definition_xml_Updatetaskflow_definition_ImplicitViewCriteriaQuery
                            <DCExecutableBinding> <refreshIfNeeded> [12302] Invoke refresh for :UpdUamOrganisation1Iterator
                            <DCIteratorBinding> <refresh> [12303] Executing and syncing on IteratorBinding.refresh from :UpdUamOrganisation1Iterator
                            <DCUtil> <findSpelObject> [12304] DCUtil, returning:oracle.jbo.uicli.binding.JUApplication, for UpdAppModuleDataControl
                            <DCJboDataControl> <initializeApplicationModule> [12305] (oracle.adf.model.bc4j.DataControlFactoryImpl.SyncMode = Immediate
                            <ApplicationPoolImpl> <reuseReferencedInstance> [12306] Reusing a cached session application module instance
                            <ApplicationPoolMessageHandler> <doPoolMessage> [12307] **** PoolMessage REQ ATTACH LWS
                            <ADFLogger> <begin> Attaching an iterator binding to a datasource
                            <DCIteratorBinding> <getViewObject> [12308] Resolving VO:UpdUamOrganisation1 for iterator binding:UpdUamOrganisation1Iterator
                            <ADFLogger> <addContextData> Attaching an iterator binding to a datasource
                            <ADFLogger> <begin> Get LOV list
                            <JUMetaObjectManager> <getControlDefinitionFactory> [12309] JUMOM - CTRL_DEF_FACTORY not found: [ACTIVE] ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)'
                            <JUMetaObjectManager> <getControlDefinitionFactory> [12310] JUMOM - factory from map: oracle.adfinternal.view.faces.model.binding.FacesBindingDefFactoryImpl, [ACTIVE] ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)'
                            <DCUtil> <findSpelObject> [12311] DCUtil, returning:oracle.jbo.uicli.binding.JUApplication, for UpdAppModuleDataControl
                            <ADFLogger> <addContextData> Get LOV list
                            <DCExecutableBinding> <refreshIfNeeded> [12312] Invoke refresh for :OrgAddress1Iterator
                            <DCIteratorBinding> <refresh> [12313] Executing and syncing on IteratorBinding.refresh from :OrgAddress1Iterator
                            <DCUtil> <findSpelObject> [12314] DCUtil, returning:oracle.jbo.uicli.binding.JUApplication, for UpdAppModuleDataControl
                            <ADFLogger> <begin> Attaching an iterator binding to a datasource
                            <DCIteratorBinding> <getViewObject> [12315] Resolving VO:OrgAddress1 for iterator binding:OrgAddress1Iterator
                            <ADFLogger> <addContextData> Attaching an iterator binding to a datasource
                            <ADFLogger> <begin> Evaluate Expression
                            <ADFLogger> <begin> Evaluate Expression
                            <DCUtil> <findSpelObject> [12316] DCUtil, returning:oracle.jbo.uicli.binding.JUApplication, for AppModuleDataControl
                            <DCJboDataControl> <initializeApplicationModule> [12317] (oracle.adf.model.bc4j.DataControlFactoryImpl.SyncMode = Immediate
                            <ApplicationPoolImpl> <reuseReferencedInstance> [12318] Reusing a cached session application module instance
                            <ApplicationPoolMessageHandler> <doPoolMessage> [12319] **** PoolMessage REQ ATTACH LWS
                            <DCIteratorBinding> <getViewObject> [12320] Resolving VO:UserDetailsViewVO1 for iterator binding:UserDetailsViewVO1Iterator
                            <DCUtil> <findSpelObject> [12321] DCUtil, returning:oracle.adfinternal.view.faces.model.binding.FacesCtrlHierBinding, for UserDetailsViewVO1
                            <ADFLogger> <begin> Evaluate Expression
                            <ADFLogger> <begin> Evaluate Expression
                            <ADFLogger> <begin> Evaluate Expression
                            <JboBeanUtils> <getProperty> [12322] *** Using bean introspection to lookup value :dataControl
                            <ADFLogger> <begin> Refreshing binding container
                            <DCBindingContainer> <internalRefreshControl> [12323] **** refreshControl() for BindingContainer :ImplicitViewCriteriaQuery
                            <DCExecutableBinding> <refreshIfNeeded> [12324] Invoke refresh for :vcRowsIterator
                            <DCIteratorBinding> <refresh> [12325] Executing and syncing on IteratorBinding.refresh from :vcRowsIterator
                            <ADFLogger> <begin> Attaching an iterator binding to a datasource
                            <JboBeanUtils> <getProperty> [12326] *** Using bean introspection to lookup value :result
                            <DebugDiagnostic> <print> [12327] DBG: beforeActionPerformed :GetViewCriteria
                            <ADFLogger> <begin> Evaluate Expression
                            <JboBeanUtils> <getProperty> [12328] *** Using bean introspection to lookup value :dataControl
                            <JUCtrlActionBinding> <doIt> [12329] Invoke method Action:999
                            <ADFLogger> <begin> Evaluate Expression
                            <ADFLogger> <begin> Evaluate Expression
                            <ADFLogger> <begin> Evaluate Expression
                            <ADFLogger> <begin> Executing method binding
                            <DCInvokeMethod> <invokeMethod> [12330] DCInvokeMethod:Invoking oracle.jbo.uicli.binding.JUSearchBindingCustomizer.findOrCreateViewCriteria()
                            <DebugDiagnostic> <print> [12331] DBG: afterActionPerformed :GetViewCriteria
                            <DCUtil> <findSpelObject> [12332] DCUtil, returning:oracle.jbo.common.ViewCriteriaImpl, for result
                            <DCJboDataControl> <initializeApplicationModule> [12333] (oracle.adf.model.bc4j.DataControlFactoryImpl.SyncMode = Immediate
                            <ApplicationPoolImpl> <recycleUnreferencedInstance> [12334] Recycling an unreferenced, available pool instance
                            <ADFLogger> <begin> Rollback transaction
                            <ApplicationModuleImpl> <resetState> [12335] Resetting AM=Root
                            <PropertyManager> <loadProperties> [12336] Propertymanager: skipping reload of file and system based properties
                            <PropertyManager> <loadProperties> [12337] {{ begin Loading BC4J properties
                            <PropertyManager> <loadProperties> [12338] -----------------------------------------------------------
                            <PropertyManager> <loadProperty> [12339] BC4J Property jbo.default.language='en' -->(MetaObjectManager) from System Default
                            <PropertyManager> <loadProperty> [12340] BC4J Property jbo.default.country='ZA' -->(MetaObjectManager) from System Default
                            <PropertyManager> <loadProperty> [12341] Skipping empty Property jbo.default.locale.variant from System Default
                            <PropertyManager> <loadProperty> [12342] BC4J Property DeployPlatform='LOCAL' -->(SessionImpl) from Client Environment
                            <PropertyManager> <loadProperty> [12343] Skipping empty Property ConnectionMode from System Default
                            <PropertyManager> <loadProperty> [12344] Skipping empty Property HostName from System Default
                            <PropertyManager> <loadProperty> [12345] Skipping empty Property ConnectionPort from System Default
                            <PropertyManager> <loadProperty> [12346] BC4J Property jbo.locking.mode='optimistic' -->(MetaObjectManager) from Client Environment
                            <PropertyManager> <loadProperty> [12347] BC4J Property jbo.txn.disconnect_level='0' -->(SessionImpl) from System Default
                            <PropertyManager> <loadProperty> [12348] Skipping empty Property ApplicationPath from System Default
                            <PropertyManager> <loadProperty> [12349] BC4J Property AppModuleJndiName='$DefaultAppModule' -->(SessionImpl) from Client Environment
                            <PropertyManager> <loadProperty> [12350] Skipping empty Property java.naming.security.principal from System Default
                            <PropertyManager> <loadProperty> [12351] Skipping empty Property java.naming.security.credentials from System Default
                            <PropertyManager> <loadProperty> [12352] Skipping empty Property jbo.user.principal from System Default
                            <PropertyManager> <loadProperty> [12353] BC4J Property jbo.simulate.remote='false' -->(SessionImpl) from System Default
                            <PropertyManager> <loadProperty> [12354] BC4J Property jbo.security.context='oracle.security.jazn' -->(MetaObjectManager) from System Default
                            <PropertyManager> <loadProperty> [12355] Skipping empty Property jbo.object.marshaller from System Default
                            <PropertyManager> <loadProperty> [12356] BC4J Property jbo.use.pers.coll='false' -->(SessionImpl) from System Default
                            <PropertyManager> <loadProperty> [12357] BC4J Property jbo.pers.max.rows.per.node='70' -->(SessionImpl) from System Default
                            <PropertyManager> <loadProperty> [12358] BC4J Property jbo.pers.max.active.nodes='30' -->(SessionImpl) from System Default
                            <PropertyManager> <loadProperty> [12359] BC4J Property jbo.validation.threshold='10' -->(SessionImpl) from System Default
                            <PropertyManager> <loadProperty> [12360] BC4J Property jbo.sparse.array.threshold='20' -->(SessionImpl) from System Default
                            <PropertyManager> <loadProperty> [12361] Skipping empty Property jbo.pcoll.mgr from System Default
                            {code}

                            Edited by: adf009 on 2013/02/20 5:05 PM

                            Edited by: adf009 on 2013/02/20 5:05 PM
                            • 11. Re: Inserting Rows to ADF View Object Programatically with foreign table value
                              Timo Hahn
                              adf009, you don't get it.
                              >
                              ok timo i deburg ,i found out that when i click my add button it open an empty row in the current table am geting the bindings for TargetVO .i use VO UserDetailsViewVO1" to get the bindings for TargetVO THE TARGET vo is DeltMember which has iterator DeltMember1Iterator
                              {quote}
                              What does this mean? I don't understand this and I'm not trying to analyze some log output.
                              All I cna sy is that there is no error in the log output you have posted. search the whole thread for 'error' and you see what I mean.
                              TargetVo, UserDetailsViewVO1, DeltMember and DeltMember1Iterator doesn't mean anything to me as they have no context. You have to tell me in which context you are using the elements in your application.
                              I need to understand what should happen when I select some lov value and fill in some other fields with other values (which values should I put in anyway?) Which table in the UI should show some data? On which row should I click or press a button? What should happen after that? At the point where the problem shows in the UI (like i expect to see a popup but the popup is not shown) describe what exactly you expect to see.
                              My time is vulnerable so as long as you can't come up with something I can quickly analyse, I can't help.

                              Timo
                              • 12. Re: Inserting Rows to ADF View Object Programatically with foreign table value
                                Tshifhiwa
                                ok am serching users using viewObject UserDetailsViewVO1,when the list of users display in table format i have extra column next to each row,the column got button which i need to click so i can add that row to another viewObject(DeltMember).the another view is also display in table using viewobject(DeltMember).i except to click the add button in my UserDetailsViewVO1, and take the username,firstname,surname ,email and populate them in my DeltMember table,in my UI i have two tables the first table(UserDetailsViewVO1) got username,firstname,surname ,email and the second table(DeltMember.) need to be populated with username,firstname,surname ,email from UserDetailsViewVO1 when i click the add button which is located in each row of the first table.at the moment when i click the add button it create am empty row in UserDetailsViewVO1.hi am i still not clear
                                the first table
                                <af:table value="#{bindings.UserDetailsViewVO1.collectionModel}"
                                                        var="row"
                                                        rows="#{bindings.UserDetailsViewVO1.rangeSize}"
                                                        emptyText="#{bindings.UserDetailsViewVO1.viewable ? 'No data to display.' : 'Access Denied.'}"
                                                        fetchSize="#{bindings.UserDetailsViewVO1.rangeSize}"
                                                        rowBandingInterval="0"
                                                        selectedRowKeys="#{bindings.UserDetailsViewVO1.collectionModel.selectedRow}"
                                                        selectionListener="#{bindings.UserDetailsViewVO1.collectionModel.makeCurrent}"
                                                        rowSelection="single" partialTriggers="::qryId1"
                                                        id="t3" width="55%"
                                                        binding="#{pageFlowScope.MemberBean.empTable}"
                                                        inlineStyle="height:237px; width:100px;" columnStretching="last">
                                                <af:column sortProperty="Firstname" sortable="false"
                                                           headerText="#{bindings.UserDetailsViewVO1.hints.Firstname.label}"
                                                           id="c2">
                                                  <af:outputText value="#{row.Firstname}" id="ot2"/>
                                                </af:column>
                                                <af:column sortProperty="Surname" sortable="false"
                                                           headerText="#{bindings.UserDetailsViewVO1.hints.Surname.label}"
                                                           id="c9">
                                                  <af:outputText value="#{row.Surname}" id="ot3"/>
                                                </af:column>
                                                <af:column sortProperty="Emailaddress" sortable="false"
                                                           headerText="#{bindings.UserDetailsViewVO1.hints.Emailaddress.label}"
                                                           id="c8">
                                                  <af:outputText value="#{row.Emailaddress}" id="ot4"/>
                                                </af:column>
                                                <af:column sortProperty="Username" sortable="false"
                                                           headerText="#{bindings.UserDetailsViewVO1.hints.Username.label}"
                                                           id="c1">
                                                  <af:outputText value="#{row.Username}" id="ot1"/>
                                                </af:column>
                                                <af:column id="c10" headerText="Actions">
                                                  <af:commandButton text="Add" id="cb1"
                                                                    actionListener="#{pageFlowScope.MemberBean.addMember}"/>
                                                </af:column>
                                              </af:table>
                                
                                the second table  i need to add value to is
                                <af:table value="#{bindings.addmemberBean.collectionModel}"
                                                        var="row" rows="#{bindings.addmemberBean.rangeSize}"
                                                        emptyText="#{bindings.addmemberBean.viewable ? 'No data to display.' : 'Access Denied.'}"
                                                        fetchSize="#{bindings.addmemberBean.rangeSize}"
                                                        rowBandingInterval="0"
                                                        selectedRowKeys="#{bindings.addmemberBean.collectionModel.selectedRow}"
                                                        selectionListener="#{bindings.addmemberBean.collectionModel.makeCurrent}"
                                                        rowSelection="single" id="t1"
                                                        binding="#{pageFlowScope.MemberBean.tempTable}"
                                                        width="78%" columnStretching="last"
                                                        inlineStyle="height:128px;" partialTriggers="cb5">
                                                <af:column sortProperty="firstname" sortable="false"
                                                           headerText="#{bindings.addmemberBean.hints.firstname.label}"
                                                           id="c5" width="105">
                                                  <af:inputText value="#{row.bindings.firstname.inputValue}"
                                                                label="#{bindings.addmemberBean.hints.firstname.label}"
                                                                required="#{bindings.addmemberBean.hints.firstname.mandatory}"
                                                                columns="#{bindings.addmemberBean.hints.firstname.displayWidth}"
                                                                maximumLength="#{bindings.addmemberBean.hints.firstname.precision}"
                                                                shortDesc="#{bindings.addmemberBean.hints.firstname.tooltip}"
                                                                id="it2">
                                                    <f:validator binding="#{row.bindings.firstname.validator}"/>
                                                  </af:inputText>
                                                </af:column>
                                                <af:column sortProperty="surname" sortable="false"
                                                           headerText="#{bindings.addmemberBean.hints.surname.label}"
                                                           id="c4" width="106">
                                                  <af:inputText value="#{row.bindings.surname.inputValue}"
                                                                label="#{bindings.addmemberBean.hints.surname.label}"
                                                                required="#{bindings.addmemberBean.hints.surname.mandatory}"
                                                                columns="#{bindings.addmemberBean.hints.surname.displayWidth}"
                                                                maximumLength="#{bindings.addmemberBean.hints.surname.precision}"
                                                                shortDesc="#{bindings.addmemberBean.hints.surname.tooltip}"
                                                                id="it1">
                                                    <f:validator binding="#{row.bindings.surname.validator}"/>
                                                  </af:inputText>
                                                </af:column>
                                                <af:column sortProperty="emailaddress" sortable="false"
                                                           headerText="#{bindings.addmemberBean.hints.emailaddress.label}"
                                                           id="c6" width="104">
                                                  <af:inputText value="#{row.bindings.emailaddress.inputValue}"
                                                                label="#{bindings.addmemberBean.hints.emailaddress.label}"
                                                                required="#{bindings.addmemberBean.hints.emailaddress.mandatory}"
                                                                columns="#{bindings.addmemberBean.hints.emailaddress.displayWidth}"
                                                                maximumLength="#{bindings.addmemberBean.hints.emailaddress.precision}"
                                                                shortDesc="#{bindings.addmemberBean.hints.emailaddress.tooltip}"
                                                                id="it4">
                                                    <f:validator binding="#{row.bindings.emailaddress.validator}"/>
                                                  </af:inputText>
                                                </af:column>
                                                <af:column sortProperty="name" sortable="false"
                                                           headerText="#{bindings.addmemberBean.hints.name.label}"
                                                           id="c3" width="105">
                                                  <af:inputText value="#{row.bindings.name.inputValue}"
                                                                label="#{bindings.addmemberBean.hints.name.label}"
                                                                required="#{bindings.addmemberBean.hints.name.mandatory}"
                                                                columns="#{bindings.addmemberBean.hints.name.displayWidth}"
                                                                maximumLength="#{bindings.addmemberBean.hints.name.precision}"
                                                                shortDesc="#{bindings.addmemberBean.hints.name.tooltip}"
                                                                id="it3">
                                                    <f:validator binding="#{row.bindings.name.validator}"/>
                                                  </af:inputText>
                                                </af:column>
                                                <af:column id="c7" headerText="Select User" width="106">
                                                  <af:panelGroupLayout id="pgl6">
                                                    <af:panelFormLayout id="pfl2" rows="1" maxColumns="2">
                                                      <af:commandButton actionListener="#{bindings.Delete.execute}"
                                                                        text="Delete"
                                                                        id="cb5"/>
                                                      <af:selectBooleanCheckbox id="sbc1"/>
                                                    </af:panelFormLayout>
                                                  </af:panelGroupLayout>
                                                </af:column>
                                              </af:table>
                                
                                am geting value from this VO
                                               JUCtrlHierBinding obj = (JUCtrlHierBinding)bindings2.findCtrlBinding("UserDetailsViewVO1");
                                               ViewObject targetVO = obj.getViewObject();
                                
                                
                                
                                
                                and i what to add than in this VO/Iterator
                                          DCBindingContainer bindings =
                                                   (DCBindingContainer)BindingContext.getCurrent().getCurrentBindingsEntry();
                                               DCIteratorBinding empIter =
                                                   bindings.findIteratorBinding("DeltMember1Iterator");
                                Edited by: adf009 on 2013/02/21 10:45 AM

                                Edited by: adf009 on 2013/02/21 10:53 AM

                                Edited by: adf009 on 2013/02/21 10:55 AM

                                Edited by: adf009 on 2013/02/21 10:57 AM

                                Edited by: adf009 on 2013/02/21 5:27 PM