Adding Drag and Drop Functionality for collections in page fragments to create insert

Hello All,
This tutorial is based on using Drag & Drop functionality in collections as af:table to create a new row
i have googled about Drag & Drop but was not able to implement in page fragments(.jsff), all samples was based on JSPX page.

this tutorial is based on DEPARTMENTS table (Default HR Schema) and an other table with Same Structure DEPARTMENTS_DUPL to implement drag and drop.
my scenario is to add row in DEPARTMENTS_DUPL from Departments 
 See the steps to implement- 

•  First create Departments_dupl table in your HR schema, simply run this script



CREATE TABLE DEPARTMENTS_DUPL
  (
    DEPARTMENT_ID   NUMBER(4, 0) ,
    DEPARTMENT_NAME VARCHAR2(30 BYTE) ,
    MANAGER_ID      NUMBER(6, 0) ,
    LOCATION_ID     NUMBER(4, 0)
  )



• Now create Fusion Web Application and create business components

• Now create a bounded taskflow and a page fragment in it, and drop both tables on page
  
  
  
• Now drop af:dragSource as child of Departments table and set properties, here discriminant is to ensure compatibility between drag and drop components, and its value must match for Drag source and Drop Target

• now drop af:dropTarget as child of DepartmentsDupl table and set properties as Action etc and create a DropListener for it that handles drop event, set Flavor class to java.lang.Object

• Now select af:dropTarget and goto source and set value for discriminant same as drag source



  <af:dropTarget dropListener="#{pageFlowScope.DragDropSampleBean.deptDropListener}" actions="COPY">
          <af:dataFlavor discriminant="copyDept" flavorClass="java.lang.Object"/>
        </af:dropTarget>





• Now write code to create a new row in DepartmentsDupl and insert data from Departments on Drop Listener




    public void dragDropAction() {
        ViewObject dept = this.getDepartments1();
        ViewObject deptDupl = this.getDepartmentsDupl1();
        Row curDept = dept.getCurrentRow();
     
        Row dupl = deptDupl.createRow();
        dupl.setAttribute("DepartmentId", curDept.getAttribute("DepartmentId"));
        dupl.setAttribute("DepartmentName", curDept.getAttribute("DepartmentName"));
        dupl.setAttribute("ManagerId", curDept.getAttribute("ManagerId"));
        dupl.setAttribute("LocationId", curDept.getAttribute("LocationId"));
        deptDupl.insertRow(dupl);
        deptDupl.executeQuery();
        this.getDBTransaction().commit();
    }



• Now Run your page and use this cool functionality :-)

 Download Sample App Cheers :-)

Using af:switcher in ADF Faces to dynamically render page components

Hello all,,
Sometimes we need to display page components on a condition basis , this can be achieved in adf using af:switcher component
Normally switcher component is a collection of multiple facets and on a given condition it decides that which facet should be rendered.

How to use af:switcher- see the steps

• Create a Fusion web application and create business components using Departments and Employees table (HR Schema)

•  Now create a page in view Controller and drop a switcher component from component palette

• Switcher is pure server side component so it doesn't have any client representation, so next move is to add facets in af:switcher, to add facets in switcher,
  just right click--insert inside af:switcher-- facet

• As in this tutorial i am going to show 2 tables(Departments U& Employees) so added 2 facets in af:switcher

• Now time to drop tables in corresponding facets, Employees Table in Emp, Departments Table in Dept

•  Now i have created a static List that has values D for Departments and E for Employees, when user selects D the Departments table will be shown and for E Employees table will be shown

• to do this select af:switcher and go to FacetName property and open expression builder to write conditional expression

•  Now run this page and select values in list to see- how switcher works

  Download Sample App Cheers :-)

Bug in ADF 11g R2- Transient and Bind Valiable of Timestamp type

This is a bug in ADF 11g R2, and sometimes so much annoying for developer.

Bug Is-

• Suppose you have created business components for Employees table of HR Schema, there is HireDate in Employees table , see it in EntityObject-

• Now go to source and see, it is of type oracle.jbo.domain.Timestamp (default java representation of Timestamp database data type )

• Now go to Employees ViewObject and create a transient variable for DOB(Date Of Birth)  and select it as Timestamp

•  Now after this if developer tries to get or set value of this transient variable, it shows a exception (java.sql.Timestamp can not be cast to oracle.jbo.domain.Timestamp)

•  To solve this error go to Employees ViewObject and select transient attribute and go to source, se it is of type java.sql.Timestamp

 

• Change it to oracle.jbo.domain.Timestamp  and then run it
• So this is a bug when developer creates new Transient or Query bind variables of Timestamp type, ADF automatically assign it java.sql.Timestamp

Always check it when using Jdveloper 11gR2

Cheers... happy debugging