This discussion is archived
12 Replies Latest reply: Feb 21, 2013 6:28 AM by adf009 RSS

Inserting Rows to ADF View Object Programatically with foreign table value

adf009 Explorer
Currently Being Moderated
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 Employee ACE
    Currently Being Moderated
    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
    adf009 Explorer
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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
    adf009 Explorer
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    Row row = targetVO.createAndInitRow(nvp);
    targetVO.insertRow(row);
    Timo
  • 6. Re: Inserting Rows to ADF View Object Programatically with foreign table value
    adf009 Explorer
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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
    adf009 Explorer
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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
    adf009 Explorer
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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
    adf009 Explorer
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points