Unwinding ADF

ADF Mobile With EJB Restful Web Service

noreply@blogger.com (Deepak Siddappa) — Sun, 19 May 2013 11:18:00 +0000

This article is the continuation of my previous article on Configuring EJB with Restful Web Service in ADF. Here will see how to integrate EJB Restful Web Service with ADF mobile.

Application screen looks like below when it is deployed and run on the Android Device/Emulator. In the below screen Department list will be displayed.

Clicking on any department will take you to the selected Department details page, edit the details and click on the Save button to submit the data. Clicking on delete button will delete the current department.

From Department List screen, click on add button to add the new record. Enter the details and click on Save button to submit the data.

After the below actions, updated department result page will be displayed as shown below.

You can download the sample workspace from here
[Runs with Oracle JDeveloper 11.1.2.4.0 + HR Schema]

Implementation Steps

Create an ADF Mobile Application, the application consists of two projects. Application Controller project of Application LifeCycle, Listeners, Device Features DataControl and ViewController project contains mobile features content like AMX Files, Task Flows and DataControl.

In Application Controller project, create a Departments.java file and add the below code.

public class Departments {
    private BigDecimal departmentId;
    private String departmentName;
    private BigDecimal locationId;
    private BigDecimal managerId;

    public Departments() {
        super();
    }

    public Departments(BigDecimal departmentId, String departmentName, BigDecimal locationId, BigDecimal managerId) {
        this.departmentId = departmentId;
        this.departmentName = departmentName;
        this.locationId = locationId;
        this.managerId = managerId;
    }

    public void setDepartmentId(BigDecimal departmentId) {
        this.departmentId = departmentId;
    }

    public BigDecimal getDepartmentId() {
        return departmentId;
    }

    public void setDepartmentName(String departmentName) {
        this.departmentName = departmentName;
    }

    public String getDepartmentName() {
        return departmentName;
    }

    public void setLocationId(BigDecimal locationId) {
        this.locationId = locationId;
    }

    public BigDecimal getLocationId() {
        return locationId;
    }

    public void setManagerId(BigDecimal managerId) {
        this.managerId = managerId;
    }

    public BigDecimal getManagerId() {
        return managerId;
    }
}

Create DepartmentsDC.java file and add the below code, create DataControl based on DepartmentsDC file

public class DepartmentsDC {
    public DepartmentsDC() {
        super();
    }

    public Departments ediDepartment(BigDecimal departmentId, String departmentName, BigDecimal locationId,
                                     BigDecimal managerId) {
        return new Departments(departmentId, departmentName, locationId, managerId);
    }

    public Departments addDepartment() {
        BigDecimal defaultVal = new BigDecimal("0");
        return new Departments(defaultVal, "", defaultVal, defaultVal);
    }
}

In the New Gallery expand the General - XML nodes and select XML Schema and click OK, enter Departments.xsd in File Name field and the following attributes as shown in below image.

In the New Gallery expand the General - Connection nodes and select URL Connection and click OK, enter the URL Endpoint details, You can download Configuring EJB with Restful Web Service in ADF from my previous article.

Note: - Next create a URL Service Data Control from - http://IpAddress:7101/EJBRestService/jersey/EJBRESTService api with HTTP Methods: GET, PUT, POST, DELETE.

In the New Gallery expand the General - Data Control nodes and select URL Service Data Control and click OK and enter the details to create the GET method

In the New Gallery expand the General - Data Control nodes and select URL Service Data Control and click OK and enter the details to create the POST method.

In Create URL Service Data Control wizard - step 3 of 5, specify the XSD url which we created earlier.

In the New Gallery expand the General - Data Control nodes and select URL Service Data Control and click OK and enter the details to create the PUT method.

In Create URL Service Data Control wizard - step 3 of 5, specify the XSD url which we created earlier.

In the New Gallery expand the General - Data Control nodes and select URL Service Data Control and click OK and enter the details to create the DELETE method.

In Create URL Service Data Control wizard - step 3 of 5, enter the departmentId value as 0.

Next open the DataControls.dcx file and change the Definition id values to looks like below.

In ViewController project. Locate and expand the Application Sources folder, then expand the META-INF folder. You will see the adfmf-feature.xml file, click on the adfmf-feature.xml file to launch the Feature editor. Add a new feature by clicking the green plus sign on the Features table near top of the editor this will launch the new Create ADF Mobile Feature dialog, modify the values as shown below.

In the Features table, select the newly created feature Departments. Under the Features table, click the Content tab, and locate the Content table. Notice that the content item Departments.1 is created by default. Next add a new file by clicking the green plus sign and select taskflow option, this will launch the new Create ADF Mobile Task Flow dialog, modify the value as shown below.

Click on the DepartmentsTaskflow.xml to open the file in taskflow editor and follow the below steps.

Create three views and name them as deptList, deptAdd and deptEdit respectively
Draw the control flow case from deptList to addDept and Outcome as "add"
Draw the control flow case from deptList to editDept and Outcome as "edit"
From DataControl palette drag and drop getDepartmentsFindAll and drop as method-call
Draw the control flow case from getDepartmentsFindAll method-call to deptList and Outcome as "getDepartmentsFindAll"
Draw the control flow case from addDept to getDepartmentsFindAll method-call and Outcome as "list"
Draw the control flow case from editDept to getDepartmentsFindAll method-call and Outcome as "list"

DepartmentsTaskflow.xml will looks as shown below diagram.

Double click on deptList view will launch Create ADF Mobile AMX Page dialog, in page facets select Header and Secondary Action. Go to source tab and follow the below steps:

In Header facet, amx:outputText set the value as "Dept List"
In Secondary Action facet, for amx:commandButton modify the values text: Add, action: add
From DC palette drag and drop EJBService->getDepartmentsFindAll()->Return->departmentss->departments->ADF Mobile List View and select the default options
In amx:Item, set the action as "edit"
Inside amx:Item set the setPropertyListener as shown below

Note:- Created the DataControl DepartmentsDC with addDepartment and editDepartment methods, so that the type casting the ADF form values to departments object will be easy.

Double click on deptAdd view will launch Create ADF Mobile AMX Page dialog, in page facets select Header, Primary Action. Go to source tab and follow the below steps:

In Header facet, amx:outputText set the value as "Add Dept"
In Primary Action facet, for amx:commandButton modify the values text: Back, action: __back
From DC palette drag and drop DepartmentsDC->addDepartment->Departments->Form as ADF Mobile Form.
Go to bindings and add the following attributesValues, departmentId, departmentName, locationId, managerId as shown below.

From DC palette drag and drop postDepartments->Method as ADF Mobile Button, set name as "Save", action as "list" and set the setPropertyListener as shown below

Double click on deptAdd view will launch Create ADF Mobile AMX Page dialog, in page facets select Header, Primary, Secondary Action. Go to source tab and follow the below steps:

In Header facet, amx:outputText set the value as "Edit Dept"
In Primary Action facet, for amx:commandButton modify the values text: Back, action: __back
In Secondary Action facet, from DC palette drag and drop EJBService->deleteDepartments->Method as ADF Mobile Button, set action as "list". In Edit Action Binding wizard mention the parameter for departmentId as #{pageFlowScope.departmentId}
From DC palette drag and drop DepartmentsDC->editDepartment->Departments->Form as ADF Mobile Form and in edit action binding wizard mention the parameters as shown below

Go to bindings and add the following attributesValues, departmentId, departmentName, locationId, managerId as shown below.

From DC palette drag and drop putDepartments->Method as ADF Mobile Button, set name as "Save", action as "list" and set the setPropertyListener as shown below.

Configuring EJB with Restful Web Service in ADF

noreply@blogger.com (Deepak Siddappa) — Thu, 18 Apr 2013 15:01:00 +0000

In current JDeveloper we can expose EJB's as Web Service, however this will be a SOAP based web service. In this article will discuss on configuring EJB with restful web service using jersey support. This article provides an example of building a complete RESTful API using the different HTTP methods:

GET to retrieve data
POST to add data
PUT to update data
DELETE to delete data

You can download the sample workspace from here
[Runs with Oracle JDeveloper 11.1.2.3.0 + HR Schema]

Implementation Steps:-

Create a EJB project, then create the DEPARTMENT JPA/EJB 3.0 Entity using the"Entities from tables" EJB wizard, create a Stateless Session bean and select Departments JPA Entity to generates façade methods.

Open the Departments entity and annotate with @XmlRootElement, when a top level class or an enum type is annotated with the @XmlRootElement annotation, then its value is represented as XML element in an XML document. Basically this allow ADF to convert this object directly to XML.JSON.

Add a new project ('REST Web Service Project') in the application and mention the name as WebService. Go to 'Project properties' > 'Dependencies' and add the Model project as a dependency.

Next add the supporting libraries to the Rest Web Service project, go to 'Project properties' > 'Libraries and Classpath'. Libraries are listed in the below screen shot, you can find the libraries in EJBRestService/libs folder.

Create and open EJBRestService java class, annotate with @Path("EJBRESTService") on class level. Click on the @Path notice on the left side yellow bulb will be appeared and click on the bulb to "Configure web.xml for jersey JAX-RS web services" as shown in below.

Now web.xml is created under WEB-INF folder. Open the file and replace with the below xml code.

<?xml version = '1.0' encoding = 'windows-1252'?>
<web-app xmlns="http://java.sun.com/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"
         version="2.5">
    <filter>
        <filter-name>JpsFilter</filter-name>
        <filter-class>oracle.security.jps.ee.http.JpsFilter</filter-class>
        <init-param>
            <param-name>enable.anonymous</param-name>
            <param-value>true</param-value>
        </init-param>
    </filter>
    <filter-mapping>
        <filter-name>JpsFilter</filter-name>
        <url-pattern>/*</url-pattern>
        <dispatcher>FORWARD</dispatcher>
        <dispatcher>REQUEST</dispatcher>
        <dispatcher>INCLUDE</dispatcher>
    </filter-mapping>
    <servlet>
        <servlet-name>jersey</servlet-name>
        <servlet-class>com.sun.jersey.spi.container.servlet.ServletContainer</servlet-class>
        <init-param>
            <param-name>com.sun.jersey.config.property.resourceConfigClass</param-name>
            <param-value>com.sun.jersey.api.core.PackagesResourceConfig</param-value>
        </init-param>
        <init-param>
            <param-name>com.sun.jersey.config.property.packages</param-name>
            <param-value>webservice</param-value>
        </init-param>
        <init-param>
            <param-name>com.sun.jersey.api.json.POJOMappingFeature</param-name>
            <param-value>true</param-value>
        </init-param>
        <!--load-on-startup>1</load-on-startup-->
    </servlet>
    <servlet-mapping>
        <servlet-name>jersey</servlet-name>
        <url-pattern>/jersey/*</url-pattern>
    </servlet-mapping>
    <ejb-local-ref>
        <ejb-ref-name>ejb/SessionEJBBean</ejb-ref-name>
        <ejb-ref-type>Session</ejb-ref-type>
        <local>model.SessionEJBLocal</local>
        <ejb-link>SessionEJB</ejb-link>
    </ejb-local-ref>
</web-app>

Points to be noticed from the above xml code are :

param-value under com.sun.jersey.config.property.packages tag - change the package name by your own package name used in the application.
Add the Ejb References

Open the EJBRestService.java file and add the below code.

@Path("EJBRESTService")
public class EJBRestService {
    public EJBRestService() {
        super();
    }

    @GET
    @Produces(MediaType.APPLICATION_XML)
    public List getAllDepts() {
        List list = new ArrayList();
        try {
            Context ic = getInitialContext();
            SessionEJBLocal sessionEJB = (SessionEJBLocal)ic.lookup("java:comp/env/ejb/SessionEJBBean");
            for (Departments departments : (List)sessionEJB.getDepartmentsFindAll()) {
                list.add(departments);
            }
            ic.close();
        } catch (NamingException e) {
            e.printStackTrace();
        }
        return list;
    }

    @POST
    @Consumes(MediaType.APPLICATION_XML)
    public void persistDept(Departments departments) {
        try {
            Context ic = getInitialContext();
            SessionEJBLocal sessionEJB = (SessionEJBLocal)ic.lookup("java:comp/env/ejb/SessionEJBBean");
            sessionEJB.persistDepartments(departments);
            ic.close();
        } catch (NamingException e) {
            e.printStackTrace();
        }
    }

    @PUT
    @Consumes(MediaType.APPLICATION_XML)
    public void mergeDept(Departments departments) {
        try {
            Context ic = getInitialContext();
            SessionEJBLocal sessionEJB = (SessionEJBLocal)ic.lookup("java:comp/env/ejb/SessionEJBBean");
            sessionEJB.mergeDepartments(departments);
            ic.close();
        } catch (NamingException e) {
            e.printStackTrace();
        }
    }

    @DELETE
    @Path("{departmentId}")
    public void removeDept(@PathParam("departmentId")
        BigDecimal departmentId) {
        try {
            Context ic = getInitialContext();
            SessionEJBLocal sessionEJB = (SessionEJBLocal)ic.lookup("java:comp/env/ejb/SessionEJBBean");
            Departments departments = new Departments();
            departments.setDepartmentId(departmentId);
            sessionEJB.removeDepartments(departments);
            ic.close();
        } catch (NamingException e) {
            e.printStackTrace();
        }
    }

    private static Context getInitialContext() throws NamingException {
        InitialContext ic = new InitialContext(); // WebLogic Server 10.x connection details
        return ic;
    }
}

Now deploy/run the EJBRestService.java client in the Integrated Weblogic Server to test. Once client runs it will provide the Target Application WADL/Target URL in JDeveloper console, click on any link to run the service in HTTP Analyzer. Below screen shows the GET method accessed in HTTP Analyzer with result.

Note:- Put and Post method are not working with HTTP Analyzer, you might need to create java client/ADF application to test these methods.

Sync Device Back Button With ADF Mobile App's Back Button In TaskFlows

noreply@blogger.com (Deepak Siddappa) — Tue, 02 Apr 2013 17:36:00 +0000

This article is the continuation of my previous article on Handling the Device Back button in ADF Mobile Application. Scenario in this article is to use the device back button to go back to previous page within taskflows, Android device has a back button and our apps should take an advantage of that.

Thanks for Bryan Laipple, in his forum reply he provided the solution on how to programmatically navigate within task flows. Application screen looks like below when it is deployed and run on the Android Device/Emulator. In the below screen Employee list will be displayed.

Clicking on any employee will take you to the selected Employee details page. Notice in the below screen there is no back button provided explicitly, here we can take an advantage of device back button to navigate back to previous page. Now click on the device back button to go back to previous page.

You can download the sample workspace from here. I have checked in Android Device/Emulator and it's working fine.

In below section I will not provide all the steps to create the application from scratch, only key ones are shown. Created DeviceBackButtonTaskFlow.xml taskflow in this application looks like below.

Programmatically navigate within task flows in two ways: -

Javascript - Create Javascript file under the feature and add the below code which catches the event that fires when the user presses the device back button. In Javascript function directly call adf.mf.api.amx.doNavigation(outcome), here outcome is the variable that represents the navigation string corresponding to the control flow case.

//This is an event that fires when the user presses the device back button
document.addEventListener("deviceready", onDeviceReady, false);

function onDeviceReady() {
    document.addEventListener("backbutton", backKeyDown, true);
}

function backKeyDown() {
    //Check the device back button action happened in Employee.amx
    if ($('#EmployeeId').length) {
  //Navigate within taskflows using javascript
  adf.mf.api.amx.doNavigation("backToEmployeeList");
    }
}

Java - Create Javascript file under the feature and add the below code which catches the event that fires when the user presses the device back button.

//This is an event that fires when the user presses the device back button
document.addEventListener("deviceready", onDeviceReady, false);

function onDeviceReady() {
    document.addEventListener("backbutton", backKeyDown, true);
}

function backKeyDown() {
    //Check the device back button action happened in Employee.amx
    if ($('#EmployeeId').length) {
        //Call the java method in managed bean
        adf.mf.api.invokeMethod("mobile.EmployeeManagedBean", "handleNavigation", onInvokeSuccess, onFail);
    }
}

function onInvokeSuccess(param) {
    //To do code after success
};

function onFail() {
    //To do code after failure
};

Next create a EmployeeManagedBean class under DeviceBackButtonTaskFlow. Add the below code to navigate within the taskflow. This method will be called from javascript function.

public void handleNavigation() {
        //Code to naviagte within task flows programmatically
        AdfmfContainerUtilities.invokeContainerJavaScriptFunction(AdfmfJavaUtilities.getFeatureName(),
                                                                  "adf.mf.api.amx.doNavigation",
                                                                  new Object[] { "backToEmployeeList" });
}

Oracle JDeveloper and Oracle ADF 11g Release 1 (11.1.1.7.0) released

noreply@blogger.com (Deepak Siddappa) — Tue, 02 Apr 2013 14:46:00 +0000

The 11g Release 1 (11.1.1.7.0) version of JDeveloper and ADF is a minor update release, download here. It contains many bug fixes as well as a few new features to enjoy.

Handling the Device Back button in ADF Mobile Application

noreply@blogger.com (Deepak Siddappa) — Mon, 01 Apr 2013 05:04:00 +0000

While developing an ADF Mobile application for Android/IOS, you may require to capture the device back button on user click. Here we will add little logic to exit the application once the user clicks on device back button.

We can directly use the phone gap backbutton api to override the default back button behaviour, you can register an event listener for the 'backbutton' event. It is no longer necessary to call any other method to over ride the back button behaviour. Now, you only need to register an event listener for 'backbutton'.

Application screen looks like below when it is deployed and run on the Android Device/Emulator. Click on the device back button will launch the confirm dialog, user can click OK to exit the application.

You can download the sample workspace from here. I have checked in Android Device/Emulator and it's working fine, not sure in IOS device.

Implementation Steps

Create an ADF Mobile Application, the application consists of two projects. Application Controller project of Application LifeCycle, Listeners, Device Features DataControl and ViewController project contains mobile features content like AMX Files, Task Flows and DataControl.

Right click on the ViewController project and in New Gallery window, select Web Tier-> HTML -> JavaScript File and name as "index.js". Next locate and expand the Application Sources folder, then expand the META-INF folder. You will see the adfmf-feature.xml file, click on the adfmf-feature.xml file to launch the Feature editor. Add a new feature by clicking the green plus sign on the Features table near top of the editor this will launch the new Create ADF Mobile Feature dialog, leave the default values and click ok.

In the Features table, select the newly created feature "feature1". Under the Features table, click the Content tab, and locate the Content table. Notice that the content item feature1.1 is created by default. Next add a new file by clicking the green plus sign and select ADF Mobile AMX Page, this will launch the new Create ADF Mobile AMX Page dialog, modify the File Name as index.amx.

Next in Includes section, click the green plus sign and Insert Include the javascript file as shown below.

Open the index.js file and below code catches the event that fires when the user presses the device back button.

//This is an event that fires when the user presses the device back button
document.addEventListener("deviceready", onDeviceReady, false);

function onDeviceReady() {
    document.addEventListener("backbutton", backKeyDown, true);
}

function backKeyDown() {
    var cFirm = confirm("Are you sure you want to exit the application?");
    if (cFirm == true) {
        //Code to exit the application
        navigator.app.exitApp();
    }
}

ADF Mobile : Display Custom Springboard layout with 3 * 3 matrix

noreply@blogger.com (Deepak Siddappa) — Tue, 26 Mar 2013 07:33:00 +0000

Scenario here is to display 3 * 3 matrix dynamic table in custom springboard amx page using ApplicationFeatures data control with Features data collection.

Using amx:tableLayout only we might not be able to get the required structure. We need to use amx:panelGroupLayout with inlineStyle to achieve the above scenario. Credit goes to Matt Cooper, I have extracted the idea based on one of his forum reply. Here is the code below.

<amx:tableLayout id="tl1" shortDesc="features-table" inlineStyle="width:100%;">
  <amx:rowLayout id="rl1">
 <amx:cellFormat id="cf1" shortDesc="features-column" inlineStyle="width:100%;">
   <amx:panelGroupLayout id="pgl1" layout="wrap">
  <amx:iterator var="row" value="#{bindings.features.collectionModel}" id="i1">
    <amx:panelGroupLayout id="plam2" inlineStyle="width:33%;display:inline-block;" halign="center"
        valign="middle">
   <amx:tableLayout id="tl2">
     <amx:rowLayout id="rl2">
    <amx:cellFormat id="cf2" halign="center" valign="middle">
      <amx:commandLink id="cl1" actionListener="#{bindings.gotoFeature.execute}">
     <amx:image id="i2" source="/images/#{row.name}-springboard.png"
          inlineStyle="width:36px;height:36px"/>
     <amx:setPropertyListener from="#{row.id}" to="#{pageFlowScope.FeatureId}" type="action"/>
      </amx:commandLink>
    </amx:cellFormat>
     </amx:rowLayout>
     <amx:rowLayout id="rl3">
    <amx:cellFormat id="cf3" halign="center" valign="middle">
      <amx:commandLink id="cl2" actionListener="#{bindings.gotoFeature.execute}">
     <amx:outputText value="#{row.name}" id="ot2"/>
     <amx:setPropertyListener from="#{row.id}" to="#{pageFlowScope.FeatureId}" type="action"/>
      </amx:commandLink>
    </amx:cellFormat>
     </amx:rowLayout>
   </amx:tableLayout>
   <amx:spacer id="s2" height="25"/>
    </amx:panelGroupLayout>
  </amx:iterator>
   </amx:panelGroupLayout>
 </amx:cellFormat>
  </amx:rowLayout>
</amx:tableLayout>

Notice: - In panelGroupLayout, I have set the width to 33%, since I need 3 columns per row. Adjust the width as desired to fit the number of features Items per row based on our requirements.

Application screen looks like below when it deployed and run on Android Device/Emulator. Click on any image/link will take you to the respective feature tab.

You can download the sample workspace from here. You can get more details on Configuring the custom Springboard and Navigation Bar Behavior.

Get ADF Mobile Form values in managed bean using Accessor Iterator

noreply@blogger.com (Deepak Siddappa) — Mon, 11 Mar 2013 14:57:00 +0000

Scenario is how to get the ADF Mobile form values in managed bean programmatically. Accessor Iterator can be used with AdfmfJavaUtilities.getValueExpression() method to get values. getValueExpression method is for expressions that refer to values, this method should perform syntactic validation of the expression.

Below is one of the way to access from values, here is the code below.

ValueExpression ve =
            AdfmfJavaUtilities.getValueExpression("#{bindings.editEmployeeIterator.currentRow.dataProvider}",
                                                  Object.class);
        Object obj = ve.getValue(AdfmfJavaUtilities.getAdfELContext());
        Employee empRes = new Employee(); 
        if (obj instanceof ConcreteJavaBeanObject) {
            ConcreteJavaBeanObject cjbo = (ConcreteJavaBeanObject)obj;
            empRes = (Employee)cjbo.getInstance();
        }
        System.out.println(empRes.getId());
        System.out.println(empRes.getEmail());
        System.out.println(empRes.getFirstName());
        System.out.println(empRes.getLastName());

You can download the sample workspace from here. Application screen looks like below when it deployed and run on Android Device/Emulator. In first screen Employee list will be displayed, Next click on Add button to navigate for Employee form and looks like below.

Click on the Save button, check the employee form values by enabling debugger mode as shown below. You can check on how to Debugging ADF Mobile Apps on Android.

Integrating Open Weather Map in ADF Mobile Application

noreply@blogger.com (Deepak Siddappa) — Tue, 05 Mar 2013 13:57:00 +0000

Today I tried implementing demo weather application using JSON-REST. OpenWeatherMap is a web service that provides free weather data and forecast API suitable for any cartographic services including web and smartphones applications. Ideology is inspired by OpenStreetMap and Wikipedia that make information free and available for everybody. OpenWeatherMap wide range of weather data - map with current weather, week forecast, precipitation, wind, clouds, data from weather stations, data from radars. Weather data is received from global meteorological broadcast services and more than 40000 weather stations, OpenWeatherMap provides response data as JSON string.

Few articles on JSON-REST - Using JSON-REST in ADF Mobile, ADF Mobile REST JSON/XML

Application screen looks like below when it deployed and run on Android Device/Emulator. Displays the blank screen. Click on the Add button to added the cities.

Enter and search the city name which you want to see weather information, this will internally call the Open Weather api to get the information about the city and also similar cities will be displayed as list items like shown in below screen. Now click on the City which you want to add it for the main screen, this will save the city details to the local SQLite database. You can add multiple cities to the main screen.

Weather information for added Cities with current date will be displayed, now clicking on the city name will display weather forecast screen.

In Forecast screen, next 7 days weather forecast information will be displayed for the selected city.

You can download the sample workspace from here.

Implementation Steps

Create an ADF Mobile Application, the application consists of two projects. Application Controller project of Application LifeCycle, Listeners, Device Features DataControl and ViewController project contains mobile features content like AMX Files, Task Flows and DataControl.

In ViewController project, create the connections for the below OpenWeatherMap API.

http://api.openweathermap.org/data/2.1/find/name - Find city via its name, the inquiry retunes list of cities that match search substring.
http://api.openweathermap.org/data/2.1/weather/city - Gets current weather in concrete chosen city
http://api.openweathermap.org/data/2.2/forecast/city - Gets Weather forecast in the city for the next 7 days.

To create connections go to File->New->Connections->Url Connection and name the connections mentioned in below connections.xml.

<?xml version = '1.0' encoding = 'UTF-8'?>
<References xmlns="http://xmlns.oracle.com/adf/jndi">
   <Reference name="OpenWeatherSearchCities" className="oracle.adf.model.connection.url.HttpURLConnection" xmlns="">
      <Factory className="oracle.adf.model.connection.url.URLConnectionFactory"/>
      <RefAddresses>
         <XmlRefAddr addrType="OpenWeatherSearchCities">
            <Contents>
               <urlconnection name="OpenWeatherSearchCities" url="http://api.openweathermap.org/data/2.1/find/name"/>
            </Contents>
         </XmlRefAddr>
      </RefAddresses>
   </Reference>
   <Reference name="OpenWeatherCurrentCityDetails" className="oracle.adf.model.connection.url.HttpURLConnection" xmlns="">
      <Factory className="oracle.adf.model.connection.url.URLConnectionFactory"/>
      <RefAddresses>
         <XmlRefAddr addrType="OpenWeatherCurrentCityDetails">
            <Contents>
               <urlconnection name="OpenWeatherCurrentCityDetails" url="http://api.openweathermap.org/data/2.1/weather/city"/>
            </Contents>
         </XmlRefAddr>
      </RefAddresses>
   </Reference>
   <Reference name="OpenWeatherForecast" className="oracle.adf.model.connection.url.HttpURLConnection" xmlns="">
      <Factory className="oracle.adf.model.connection.url.URLConnectionFactory"/>
      <RefAddresses>
         <XmlRefAddr addrType="OpenWeatherForecast">
            <Contents>
               <urlconnection name="OpenWeatherForecast" url="http://api.openweathermap.org/data/2.2/forecast/city"/>
            </Contents>
         </XmlRefAddr>
      </RefAddresses>
   </Reference>
</References>

In Application Controller project. Create a DBConnectionFactory.java class and this class contains code for connecting to SQLlite DB. Connecting to the SQLite database is somewhat different from opening a connection to an Oracle database. Please read the Access Device Native SQLite Database to Store Data article to know detailed steps for implementing SQLite.

Note:- Weather.sql file should be put in .adf/META-INF/ folder. You can get the sql file by downloading the OpenWeather application.

In ViewController project, locate and expand the Application Sources folder, create a CityCurrentDetails.java file and add the below code.

public class CityCurrentDetails extends City {
    private double temp;
    private double pressure;
    private double tempMin;
    private double tempMax;
    private double wind;
    private int clouds;
    private String description;
    private String icon;
    private transient PropertyChangeSupport propertyChangeSupport = new PropertyChangeSupport(this);

    public CityCurrentDetails() {
        super();
    }

    public CityCurrentDetails(double temp, double pressure, double tempMin, double tempMax, double wind, int clouds,
                              String description, String icon, int id, String name, String country, double lat,
                              double lon) {
        super();
        this.temp = temp;
        this.pressure = pressure;
        this.tempMin = tempMin;
        this.tempMax = tempMax;
        this.wind = wind;
        this.clouds = clouds;
        this.description = description;
        this.icon = icon;
        this.setId(id);
        this.setName(name);
        this.setCountry(country);
        this.setLat(lat);
        this.setLon(lon);
    }


    public void addPropertyChangeListener(PropertyChangeListener l) {
        propertyChangeSupport.addPropertyChangeListener(l);
    }

    public void removePropertyChangeListener(PropertyChangeListener l) {
        propertyChangeSupport.removePropertyChangeListener(l);
    }

    public void setTemp(double temp) {
        double oldTemp = this.temp;
        this.temp = temp;
        propertyChangeSupport.firePropertyChange("temp", oldTemp, temp);
    }

    public double getTemp() {
        return temp;
    }

    public void setPressure(double pressure) {
        double oldPressure = this.pressure;
        this.pressure = pressure;
        propertyChangeSupport.firePropertyChange("pressure", oldPressure, pressure);
    }

    public double getPressure() {
        return pressure;
    }

    public void setTempMin(double tempMin) {
        double oldTempMin = this.tempMin;
        this.tempMin = tempMin;
        propertyChangeSupport.firePropertyChange("tempMin", oldTempMin, tempMin);
    }

    public double getTempMin() {
        return tempMin;
    }

    public void setTempMax(double tempMax) {
        double oldTempMax = this.tempMax;
        this.tempMax = tempMax;
        propertyChangeSupport.firePropertyChange("tempMax", oldTempMax, tempMax);
    }

    public double getTempMax() {
        return tempMax;
    }

    public void setWind(double wind) {
        double oldWind = this.wind;
        this.wind = wind;
        propertyChangeSupport.firePropertyChange("wind", oldWind, wind);
    }

    public double getWind() {
        return wind;
    }

    public void setClouds(int clouds) {
        int oldClouds = this.clouds;
        this.clouds = clouds;
        propertyChangeSupport.firePropertyChange("clouds", oldClouds, clouds);
    }

    public int getClouds() {
        return clouds;
    }

    public void setDescription(String description) {
        String oldDescription = this.description;
        this.description = description;
        propertyChangeSupport.firePropertyChange("description", oldDescription, description);
    }

    public String getDescription() {
        return description;
    }

    public void setIcon(String icon) {
        String oldIcon = this.icon;
        this.icon = icon;
        propertyChangeSupport.firePropertyChange("icon", oldIcon, icon);
    }

    public String getIcon() {
        return icon;
    }
}

Create CityCurrentDetailsDC.java file and add the below code, create DataControl based on CityCurrentDetailsDC.java file.

public class CityCurrentDetailsDC {
    private static List s_cityCurrentDetails = null;
    private transient ProviderChangeSupport providerChangeSupport = new ProviderChangeSupport(this);

    public CityCurrentDetailsDC() {
        super();
    }

    public void addProviderChangeListener(ProviderChangeListener l) {
        providerChangeSupport.addProviderChangeListener(l);
    }

    public void removeProviderChangeListener(ProviderChangeListener l) {
        providerChangeSupport.removeProviderChangeListener(l);
    }

    /**
     * This method will read the record from the db and 
     * Gets current weather for all the cities listed
     * @return CityCurrentDetails[] list
     */
    public CityCurrentDetails[] fetchCityCurrentDetails() {
        s_cityCurrentDetails = new ArrayList();
        try {
            Connection conn = DBConnectionFactory.getConnection();
            s_cityCurrentDetails.clear();
            conn.setAutoCommit(false);

            PreparedStatement pStmt = conn.prepareStatement("SELECT * FROM CITY");
            ResultSet rs = pStmt.executeQuery();
            while (rs.next()) {
                if (rs.getInt("ID") != 0) {

                    RestServiceAdapter restServiceAdapter = Model.createRestServiceAdapter();
                    // Clear any previously set request properties, if any
                    restServiceAdapter.clearRequestProperties();
                    // Set the connection name
                    restServiceAdapter.setConnectionName("OpenWeatherCurrentCityDetails");
                    // Specify the type of request
                    restServiceAdapter.setRequestType(RestServiceAdapter.REQUEST_TYPE_GET);
                    restServiceAdapter.addRequestProperty("Content-Type", "application/json");
                    restServiceAdapter.addRequestProperty("Accept", "application/json; charset=UTF-8");
                    // Specify the number of retries
                    restServiceAdapter.setRetryLimit(0);
                    // Set the URI which is defined after the endpoint in the connections.xml.
                    // The request is the endpoint + the URI being set
                    restServiceAdapter.setRequestURI("/" + rs.getInt("ID") + "?units=metric");
                    String response = "not found";
                    JSONBeanSerializationHelper jsonHelper = new JSONBeanSerializationHelper();

                    response = restServiceAdapter.send("");
                    CurrentDetailsServiceResponse serviceResponse =
                        (CurrentDetailsServiceResponse)jsonHelper.fromJSON(CurrentDetailsServiceResponse.class,
                                                                           response);

                    CityCurrentDetails cityCurDetails = new CityCurrentDetails();
                    cityCurDetails.setId(rs.getInt("ID"));
                    cityCurDetails.setName(rs.getString("NAME"));
                    cityCurDetails.setCountry(rs.getString("COUNTRY"));
                    cityCurDetails.setLat(rs.getDouble("LAT"));
                    cityCurDetails.setLon(rs.getDouble("LON"));

                    JSONObject cloudsObj = (JSONObject)serviceResponse.getClouds();
                    cityCurDetails.setClouds(cloudsObj.getInt("all"));

                    JSONObject mainObj = (JSONObject)serviceResponse.getMain();
                    DecimalFormat mainDecimalFormat = new DecimalFormat("###.#");
                    String temp = mainDecimalFormat.format(mainObj.getDouble("temp"));
                    cityCurDetails.setTemp(Double.valueOf(temp).doubleValue());
                    String tempMax = mainDecimalFormat.format(mainObj.getDouble("temp_max"));
                    cityCurDetails.setTempMax(Double.valueOf(tempMax).doubleValue());
                    String tempMin = mainDecimalFormat.format(mainObj.getDouble("temp_min"));
                    cityCurDetails.setTempMin(Double.valueOf(tempMin).doubleValue());
                    cityCurDetails.setPressure(mainObj.getDouble("pressure"));
                    // double humidity = mainObj.getDouble("humidity");

                    JSONObject windObj = (JSONObject)serviceResponse.getWind();
                    cityCurDetails.setWind(windObj.getDouble("speed"));

                    JSONArray weatherRes = (JSONArray)serviceResponse.getWeather();
                    for (int m = 0; m < weatherRes.length(); m++) {
                        JSONObject weatherObj = (JSONObject)weatherRes.getJSONObject(m);
                        cityCurDetails.setDescription(weatherObj.getString("description"));
                        cityCurDetails.setIcon(weatherObj.getString("icon"));
                    }
                    s_cityCurrentDetails.add(cityCurDetails);

                }
            }
        } catch (Exception e) {
            e.printStackTrace();
        }

        CityCurrentDetails c[] = null;
        c = (CityCurrentDetails[])s_cityCurrentDetails.toArray(new CityCurrentDetails[s_cityCurrentDetails.size()]);
        return c;
    }
}

The "OpenWeatherCurrentCityDetails" api will provide JSON response and structure will be as shown below.

Next step is important because we need do JSON deserialization, here we will use RestServiceAdapter and JSONBeanSerializationHelper classes. The RestServiceAdapter will handle the Rest Service and JSONBeanSerializationHelper helps us converting JSON to Java, for ex:-
CurrentDetailsServiceResponse serviceResponse =(CurrentDetailsServiceResponse)jsonHelper.fromJSON(CurrentDetailsServiceResponse.class, response);

Create CurrentDetailsServiceResponse.java file and add the below code. Make sure to use the proper data types.

public class CurrentDetailsServiceResponse {
    private int id;
    private JSONObject coord;
    private String name;
    private JSONObject main;
    private String dt;
    private JSONObject wind;
    private JSONObject clouds;
    private JSONArray weather;
    private JSONObject sys;

    public CurrentDetailsServiceResponse() {
        super();
    }

    public void setId(int id) {
        this.id = id;
    }

    public int getId() {
        return id;
    }

    public void setCoord(JSONObject coord) {
        this.coord = coord;
    }

    public JSONObject getCoord() {
        return coord;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getName() {
        return name;
    }

    public void setMain(JSONObject main) {
        this.main = main;
    }

    public JSONObject getMain() {
        return main;
    }

    public void setDt(String dt) {
        this.dt = dt;
    }

    public String getDt() {
        return dt;
    }

    public void setWind(JSONObject wind) {
        this.wind = wind;
    }

    public JSONObject getWind() {
        return wind;
    }

    public void setClouds(JSONObject clouds) {
        this.clouds = clouds;
    }

    public JSONObject getClouds() {
        return clouds;
    }

    public void setWeather(JSONArray weather) {
        this.weather = weather;
    }

    public JSONArray getWeather() {
        return weather;
    }

    public void setSys(JSONObject sys) {
        this.sys = sys;
    }

    public JSONObject getSys() {
        return sys;
    }
}

Next create a City.java file and add the below code.

public class City {
    private int id;
    private String name;
    private String country;
    private double lat;
    private double lon;
    private transient PropertyChangeSupport propertyChangeSupport = new PropertyChangeSupport(this);

    public City() {
        super();
    }

    public City(int id, String name, String country, double lat, double lon) {
        super();
        this.id = id;
        this.name = name;
        this.country = country;
        this.lat = lat;
        this.lon = lon;
    }

    public String getKey() {
        Integer i = new Integer(id);
        return i.toString();
    }

    public void addPropertyChangeListener(PropertyChangeListener l) {
        propertyChangeSupport.addPropertyChangeListener(l);
    }

    public void removePropertyChangeListener(PropertyChangeListener l) {
        propertyChangeSupport.removePropertyChangeListener(l);
    }

    public void setId(int id) {
        int oldId = this.id;
        this.id = id;
        propertyChangeSupport.firePropertyChange("id", oldId, id);
    }

    public int getId() {
        return id;
    }

    public void setName(String name) {
        String oldName = this.name;
        this.name = name;
        propertyChangeSupport.firePropertyChange("name", oldName, name);
    }

    public String getName() {
        return name;
    }

    public void setCountry(String country) {
        String oldCountry = this.country;
        this.country = country;
        propertyChangeSupport.firePropertyChange("country", oldCountry, country);
    }

    public String getCountry() {
        return country;
    }

    public void setLat(double lat) {
        double oldLat = this.lat;
        this.lat = lat;
        propertyChangeSupport.firePropertyChange("lat", oldLat, lat);
    }

    public double getLat() {
        return lat;
    }

    public void setLon(double lon) {
        double oldLon = this.lon;
        this.lon = lon;
        propertyChangeSupport.firePropertyChange("lon", oldLon, lon);
    }

    public double getLon() {
        return lon;
    }
}

Create CityDC.java file and add the below code, create DataControl based on CityDC.java file.

public class CityDC {
    private static List s_city = null;
    private transient ProviderChangeSupport providerChangeSupport = new ProviderChangeSupport(this);

    public CityDC() {
        super();
    }

    public void addProviderChangeListener(ProviderChangeListener l) {
        providerChangeSupport.addProviderChangeListener(l);
    }

    public void removeProviderChangeListener(ProviderChangeListener l) {
        providerChangeSupport.removeProviderChangeListener(l);
    }

    /**
     * Find city via its name, the inquiry retunes list of cities that match search substring.
     * @param queryString
     * @return City[] list
     */
    public City[] searchCities(String queryString) {
        s_city = new ArrayList();
        if (queryString != "" || queryString.length() > 0) {
            RestServiceAdapter restServiceAdapter = Model.createRestServiceAdapter();
            // Clear any previously set request properties, if any
            restServiceAdapter.clearRequestProperties();
            // Set the connection name
            restServiceAdapter.setConnectionName("OpenWeatherSearchCities");
            // Specify the type of request
            restServiceAdapter.setRequestType(RestServiceAdapter.REQUEST_TYPE_GET);
            restServiceAdapter.addRequestProperty("Content-Type", "application/json");
            restServiceAdapter.addRequestProperty("Accept", "application/json; charset=UTF-8");
            // Specify the number of retries
            restServiceAdapter.setRetryLimit(0);
            // Set the URI which is defined after the endpoint in the connections.xml.
            // The request is the endpoint + the URI being set
            restServiceAdapter.setRequestURI("?q=" + queryString);
            String response = "not found";
            JSONBeanSerializationHelper jsonHelper = new JSONBeanSerializationHelper();

            try {
                // For GET request, there is no payload
                response = restServiceAdapter.send("");
                CityServiceResponse serviceResponse =
                    (CityServiceResponse)jsonHelper.fromJSON(CityServiceResponse.class, response);
                JSONArray listRes = (JSONArray)serviceResponse.getList();
                s_city = new ArrayList();
                for (int m = 0; m < listRes.length(); m++) {
                    JSONObject listObj = (JSONObject)listRes.getJSONObject(m);
                    int id = listObj.getInt("id");
                    String name = listObj.getString("name");

                    JSONObject coordObj = listObj.getJSONObject("coord");
                    double lat = coordObj.getDouble("lat");
                    double lon = coordObj.getDouble("lon");

                    JSONObject sysObj = listObj.getJSONObject("sys");
                    String county = sysObj.getString("country");
                    s_city.add(new City(id, name, county, lat, lon));
                }

            } catch (Exception e) {
                e.printStackTrace();
            }
        }
        City c[] = null;
        c = (City[])s_city.toArray(new City[s_city.size()]);
        return c;
    }

    /**
     * Method will commit the details of newly created city object
     * @return
     */
    public boolean AddCityToDB(int id, String name, String country, double lat, double lon) {
        Trace.log(Utility.ApplicationLogger, Level.INFO, City.class, "AddCityToDB", "Coming inside AddCityToDB");
        boolean result = false;
        try {
            Connection conn = DBConnectionFactory.getConnection();
            conn.setAutoCommit(false);
            String insertSQL = "Insert into CITY (ID,NAME,COUNTRY,LAT,LON) values (?,?,?,?,?)";
            PreparedStatement pStmt = conn.prepareStatement(insertSQL);
            pStmt.setInt(1, id);
            pStmt.setString(2, name);
            pStmt.setString(3, country);
            pStmt.setDouble(4, lat);
            pStmt.setDouble(5, lon);
            pStmt.execute();
            conn.commit();
            result = true;
        } catch (SQLException e) {
            e.printStackTrace();
        } catch (Exception e) {
            e.printStackTrace();
        }
        Trace.log(Utility.ApplicationLogger, Level.INFO, City.class, "AddCityToDB", "Exiting AddCityToDB");
        return result;
    }
}

The "OpenWeatherSearchCities" api will provide JSON response and structure will be as shown below.

Create a CityServiceResponse.java file to convert JSON response to java object.

public class CityServiceResponse {
    private int cod;
    private JSONArray list;
    private String units;

    public CityServiceResponse() {
        super();
    }

    public void setCod(int cod) {
        this.cod = cod;
    }

    public int getCod() {
        return cod;
    }
    
    public void setList(JSONArray list) {
        this.list = list;
    }

    public JSONArray getList() {
        return list;
    }

    public void setUnits(String units) {
        this.units = units;
    }

    public String getUnits() {
        return units;
    }
}

Next create a Forecast.java file and add the below code.

public class Forecast {
    private String dt;
    private double temp;
    private double night;
    private double eve;
    private double morn;
    private double pressure;
    private double humidity;
    private double speed;
    private String description;
    private String icon;
    private transient PropertyChangeSupport propertyChangeSupport = new PropertyChangeSupport(this);

    public Forecast(String dt, double temp, double night, double eve, double morn, double pressure, double humidity,
                    double speed, String description, String icon) {
        super();
        this.dt = dt;
        this.temp = temp;
        this.night = night;
        this.eve = eve;
        this.morn = morn;
        this.pressure = pressure;
        this.humidity = humidity;
        this.speed = speed;
        this.description = description;
        this.icon = icon;
    }

    public Forecast() {

    }

    public void addPropertyChangeListener(PropertyChangeListener l) {
        propertyChangeSupport.addPropertyChangeListener(l);
    }

    public void removePropertyChangeListener(PropertyChangeListener l) {
        propertyChangeSupport.removePropertyChangeListener(l);
    }

    public void setDt(String dt) {
        String oldDt = this.dt;
        this.dt = dt;
        propertyChangeSupport.firePropertyChange("dt", oldDt, dt);
    }

    public String getDt() {
        return dt;
    }

    public void setTemp(double temp) {
        double oldTemp = this.temp;
        this.temp = temp;
        propertyChangeSupport.firePropertyChange("temp", oldTemp, temp);
    }

    public double getTemp() {
        return temp;
    }

    public void setNight(double night) {
        double oldNight = this.night;
        this.night = night;
        propertyChangeSupport.firePropertyChange("night", oldNight, night);
    }

    public double getNight() {
        return night;
    }

    public void setEve(double eve) {
        double oldEve = this.eve;
        this.eve = eve;
        propertyChangeSupport.firePropertyChange("eve", oldEve, eve);
    }

    public double getEve() {
        return eve;
    }

    public void setMorn(double morn) {
        double oldMorn = this.morn;
        this.morn = morn;
        propertyChangeSupport.firePropertyChange("morn", oldMorn, morn);
    }

    public double getMorn() {
        return morn;
    }

    public void setPressure(double pressure) {
        double oldPressure = this.pressure;
        this.pressure = pressure;
        propertyChangeSupport.firePropertyChange("pressure", oldPressure, pressure);
    }

    public double getPressure() {
        return pressure;
    }

    public void setHumidity(double humidity) {
        double oldHumidity = this.humidity;
        this.humidity = humidity;
        propertyChangeSupport.firePropertyChange("humidity", oldHumidity, humidity);
    }

    public double getHumidity() {
        return humidity;
    }


    public void setDescription(String description) {
        String oldDescription = this.description;
        this.description = description;
        propertyChangeSupport.firePropertyChange("description", oldDescription, description);
    }

    public String getDescription() {
        return description;
    }

    public void setIcon(String icon) {
        String oldIcon = this.icon;
        this.icon = icon;
        propertyChangeSupport.firePropertyChange("icon", oldIcon, icon);
    }

    public String getIcon() {
        return icon;
    }

    public void setSpeed(double speed) {
        double oldSpeed = this.speed;
        this.speed = speed;
        propertyChangeSupport.firePropertyChange("speed", oldSpeed, speed);
    }

    public double getSpeed() {
        return speed;
    }
}

Create ForecastDC.java file and add the below code, create DataControl based on ForecastDC.java file.

public class ForecastDC {
    private static List s_forecast = null;

    public ForecastDC() {
        super();
    }

    /**
     * Gets Weather forecast in the city for the next 7 days 
     * @param cityId
     * @return Forecast[] list
     */
    public Forecast[] searchCities(int cityId) {
        RestServiceAdapter restServiceAdapter = Model.createRestServiceAdapter();
        // Clear any previously set request properties, if any
        restServiceAdapter.clearRequestProperties();
        // Set the connection name
        restServiceAdapter.setConnectionName("OpenWeatherForecast");
        // Specify the type of request
        restServiceAdapter.setRequestType(RestServiceAdapter.REQUEST_TYPE_GET);
        restServiceAdapter.addRequestProperty("Content-Type", "application/json");
        restServiceAdapter.addRequestProperty("Accept", "application/json; charset=UTF-8");
        // Specify the number of retries
        restServiceAdapter.setRetryLimit(0);
        // Set the URI which is defined after the endpoint in the connections.xml.
        // The request is the endpoint + the URI being set
        restServiceAdapter.setRequestURI("/" + cityId + "?mode=daily_compact&units=metric");
        String response = "not found";
        JSONBeanSerializationHelper jsonHelper = new JSONBeanSerializationHelper();
        try {
            // For GET request, there is no payload
            response = restServiceAdapter.send("");
            ForecastServiceResponse serviceResponse =
                (ForecastServiceResponse)jsonHelper.fromJSON(ForecastServiceResponse.class, response);
            JSONArray listRes = (JSONArray)serviceResponse.getList();
            s_forecast = new ArrayList();
            System.out.println(listRes.length());
            for (int m = 0; m < listRes.length(); m++) {
                JSONObject listObj = (JSONObject)listRes.getJSONObject(m);
                Forecast forecast = new Forecast();
                
                long timeStamp = listObj.getInt("dt");
                Calendar mydate = Calendar.getInstance();
                mydate.setTimeInMillis(timeStamp * 1000);
                
                SimpleDateFormat dateFormat = new SimpleDateFormat("E dd");
                dateFormat.setCalendar(mydate);
                String dateVal = dateFormat.format(mydate.getTime());
                forecast.setDt(dateVal);
                
                forecast.setTemp(listObj.getDouble("temp"));
                forecast.setEve(listObj.getDouble("eve"));
                forecast.setMorn(listObj.getDouble("morn"));
                forecast.setNight(listObj.getDouble("night"));
                forecast.setHumidity(listObj.getDouble("humidity"));
                forecast.setPressure(listObj.getDouble("pressure"));
                forecast.setSpeed(listObj.getDouble("speed"));
                forecast.setDescription("coming here");
                JSONArray weatherRes = (JSONArray)listObj.getJSONArray("weather");
                for (int n = 0; n < weatherRes.length(); n++) {
                    JSONObject weatherObj = (JSONObject)weatherRes.getJSONObject(n);
                    forecast.setDescription(weatherObj.getString("description"));
                    forecast.setIcon(weatherObj.getString("icon"));
                }
                s_forecast.add(forecast);
            }

        } catch (Exception e) {
            e.printStackTrace();
        }

        Forecast f[] = null;
        f = (Forecast[])s_forecast.toArray(new Forecast[s_forecast.size()]);
        return f;
    }
}

The "OpenWeatherForecast" api will provide JSON response and structure will be as shown below.

Create a ForecastServiceResponse.java file to convert JSON response to java object.

public class ForecastServiceResponse {
    private int cnt;
    private JSONArray list;

    public ForecastServiceResponse() {
        super();
    }

    public void setCnt(int cnt) {
        this.cnt = cnt;
    }

    public int getCnt() {
        return cnt;
    }

    public void setList(JSONArray list) {
        this.list = list;
    }

    public JSONArray getList() {
        return list;
    }
}

In the Features table, select the newly created feature Email. Under the Features table, click the Content tab, and locate the Content table. Notice that the content item Weather.1 is created by default. Next add a new file by clicking the green plus sign and select taskflow option, this will launch the new Create ADF Mobile Task Flow dialog, modify the value as shown below.

Click on the WeatherTaskflow.xml to open the file in taskflow editor and follow the below steps.

Create views and name them as DashBoardView, AddCityView and ForeCastView respectively.
Draw the control flow case from DashBoardView to AddCityView and Outcome as "addCity".
Draw the control flow case from AddCityView to DashBoardView and Outcome as "backToDashBoard".
Draw the control flow case from DashBoardView to ForeCastView and Outcome as "foreCast".
Draw the control flow case from ForeCastView to DashBoardView and Outcome as "backToDashBoard".

WeatherTaskflow.xml

Double click on DashBoardView view will launch Create ADF Mobile AMX Page dialog. Open the DashBoardView.amx page and to source tab and follow the below steps:

In Header facet, amx:outputText set the value as "Open Weather".
In Primary Action facet, for amx:commandButton modify the values text: Refresh, actionListener: #{bindings.fetchCityCurrentDetails.execute}.
In Secondary Action facet, for amx:commandButton modify the values text: Add, action: addCity.
From DC palette drag and drop CityCurrentDetailsDC->fetchCityCurrentDetails->cityCurrentDetails as ADF Mobile List View and select the default options.
Go to bindings Create executable binding->invoke Action with Id =invokeFetchCityCurrentDetails , Binds = fetchCityCurrentDetails and Refresh = always
Modify the code as shown in below code.

<amx:panelPage id="pp1">
        <amx:facet name="header">
            <amx:outputText value="Open Weather" id="ot1"/>
        </amx:facet>
        <amx:facet name="primary">
            <amx:commandButton text="Refresh" id="cb2" actionListener="#{bindings.fetchCityCurrentDetails.execute}"/>
        </amx:facet>
        <amx:facet name="secondary">
            <amx:commandButton text="Add" id="cb1" action="addCity"/>
        </amx:facet>
        <amx:listView var="row" value="#{bindings.CityCurrentDetails.collectionModel}"
                      fetchSize="#{bindings.CityCurrentDetails.rangeSize}" id="lv1"
                      styleClass="adfmf-listView-insetList">
            <amx:listItem id="li1" showLinkIcon="false" shortDesc="Forecast Row" action="foreCast">
                <amx:setPropertyListener from="#{row.id}" to="#{pageFlowScope.forecastCityId}" type="action"/>
                <amx:setPropertyListener from="#{row.name}" to="#{pageFlowScope.forecastName}" type="action"/>
                <amx:setPropertyListener from="#{row.country}" to="#{pageFlowScope.forecastCountry}" type="action"/>
                <amx:tableLayout id="tl4" width="100%" shortDesc="Forecast Table layout">
                    <amx:rowLayout id="rl41">
                        <amx:cellFormat id="cf4i" width="40px" rowSpan="2" halign="center" shortDesc="Image cell">
                            <amx:image id="imaged1" source="/Images/#{row.icon}.png"
                                       inlineStyle="height:32px;width:32px" shortDesc="Forecast Image"/>
                        </amx:cellFormat>
                        <amx:cellFormat id="cf41" columnSpan="3" width="100%" height="28px" shortDesc="City name cell">
                            <amx:outputText id="outputTextd1" value="#{row.name}, #{row.country} - #{row.description}"/>
                        </amx:cellFormat>
                    </amx:rowLayout>
                    <amx:rowLayout id="rl42">
                        <amx:cellFormat id="cf43" columnSpan="3" width="100%" height="20px" shortDesc="Temprature cell">
                            <amx:outputText id="outputTextd3"
                                            value="#{row.temp}°C, temperature from #{row.tempMin}°C to #{row.tempMax}°C"
                                            styleClass="adfmf-listItem-captionText"/>
                        </amx:cellFormat>
                    </amx:rowLayout>
                    <amx:rowLayout id="rl1">
                        <amx:cellFormat id="cf2" width="40px" halign="center" shortDesc=""/>
                        <amx:cellFormat id="cf1" columnSpan="3" width="100%" height="20px"
                                        shortDesc="Winds, Clouds, Pressure cell">
                            <amx:outputText id="ot2"
                                            value="Wind #{row.wind}m/s. clouds #{row.clouds}%, #{row.pressure} hpa"
                                            styleClass="adfmf-listItem-captionText"/>
                        </amx:cellFormat>
                    </amx:rowLayout>
                </amx:tableLayout>
            </amx:listItem>
        </amx:listView>
    </amx:panelPage>

DashBoardView amx page preview looks like below.

Double click on AddCityView view will launch Create ADF Mobile AMX Page dialog. Open the AddCityView.amx page and to source tab and follow the below steps:

In Header facet, amx:outputText set the value as "Search City".
From DC palette drag and drop CityDC->SearchCities as ADF Mobile Parameter Form
Move Search button code to Secondary Action facet.
Drag and drop CityDC->SearchCities->City as ADF Mobile List View and select the default options
Go to bindings and Create Control Binding as shown below

From Component palette drag and drop amx:setPropertyListener into amx:listItem and modify the values as shown in below code.

<amx:panelpage id="pp1">
        <amx:facet name="header">
            <amx:outputtext id="ot1" value="Search City">
        </amx:outputtext></amx:facet>
        <amx:facet name="secondary">
            <amx:commandbutton actionlistener="#{bindings.searchCities.execute}" disabled="#{!bindings.searchCities.enabled}" id="cb2" text="Search">
        </amx:commandbutton></amx:facet>
        <amx:panelformlayout id="pfl1">
            <amx:inputtext id="it2" inlinestyle="text-align:left;" value="#{bindings.queryString.inputValue}">
        </amx:inputtext></amx:panelformlayout>
        <amx:listview fetchsize="#{bindings.City.rangeSize}" id="lv1" value="#{bindings.City.collectionModel}" var="row">
            <amx:listitem action="backToDashBoard" actionlistener="#{bindings.AddCityToDB.execute}" id="li1">
                <amx:outputtext id="ot2" value="#{row.name}, #{row.country}">
                <amx:setpropertylistener from="#{row.id}" to="#{pageFlowScope.id}" type="action">
                <amx:setpropertylistener from="#{row.name}" to="#{pageFlowScope.name}" type="action">
                <amx:setpropertylistener from="#{row.country}" to="#{pageFlowScope.country}" type="action">
                <amx:setpropertylistener from="#{row.lat}" to="#{pageFlowScope.lat}" type="action">
                <amx:setpropertylistener from="#{row.lon}" to="#{pageFlowScope.lon}" type="action">
            </amx:setpropertylistener></amx:setpropertylistener></amx:setpropertylistener></amx:setpropertylistener></amx:setpropertylistener></amx:outputtext></amx:listitem>
        </amx:listview>
 </amx:panelpage>

AddCityView amx page preview looks like below.

Double click on ForeCastView view will launch Create ADF Mobile AMX Page dialog. Open the AddCityView.amx page and to source tab and follow the below steps:

In Header facet, amx:outputText set the value as "Forecast"
In PrimaryAction facet, for amx:commandButton modify the values text: Back, action: backtoDashBoard.
From DC palette drag and drop ForecastDC->searchCities->Forecast as ADF Mobile List View and select the default options.
In Edit Action Binding dialog for cityId parameter provide value as "#{pageFlowScope.forecastCityId}"
Go to bindings Create executable binding->invoke Action with Id = invokeSearchCities, Binds = searchCities and Refresh = always
Modify the code as shown in below code.

<amx:panelPage id="pp1">
 <amx:facet name="header">
  <amx:outputText value="Forecast" id="ot1"/>
 </amx:facet>
 <amx:facet name="primary">
  <amx:commandButton id="cb1" text="Back" action="backtoDashBoard"/>
 </amx:facet>
 <amx:panelGroupLayout id="pgl1" styleClass="amx-style-groupbox" inlineStyle="width:400px;">
  <amx:outputText value="#{pageFlowScope.forecastName}, #{pageFlowScope.forecastCountry}" id="ot2"/>
 </amx:panelGroupLayout>
 <amx:listView var="row" value="#{bindings.Forecast.collectionModel}" fetchSize="#{bindings.Forecast.rangeSize}"
      id="lv1" styleClass="adfmf-listView-insetList" inlineStyle="width:400px;">
  <amx:listItem id="li1" showLinkIcon="false">
   <amx:tableLayout id="tl4" width="100%" shortDesc="Forecast Table layout">
    <amx:rowLayout id="rl41">
     <amx:cellFormat id="cf4i" columnSpan="4" halign="start" shortDesc="Date">
      <amx:outputText value="#{row.dt}, #{row.temp}°C - #{row.description} " id="ot3"/>
     </amx:cellFormat>
    </amx:rowLayout>
    <amx:rowLayout id="rl1">
     <amx:cellFormat id="cf1" width="20px" rowSpan="2" halign="center" shortDesc="Image cell">
      <amx:image id="imaged1" source="/Images/#{row.icon}.png"
           inlineStyle="height:32px;width:32px" shortDesc="Forecast Image"/>
     </amx:cellFormat>
     <amx:cellFormat id="cf41" columnSpan="3" width="100%" height="28px" shortDesc="City name cell">
      <amx:outputText id="outputTextd1"
          value="Morn #{row.morn}°C, Eve #{row.eve}°C, Night #{row.night}°C"
          styleClass="adfmf-listItem-captionText"/>
     </amx:cellFormat>
    </amx:rowLayout>
    <amx:rowLayout id="rl42">
     <amx:cellFormat id="cf43" columnSpan="3" width="100%" height="20px" shortDesc="Temprature cell">
      <amx:outputText id="outputTextd3"
          value="Wind #{row.speed}m/s. humidity #{row.humidity}%, #{row.pressure} hpa"
          styleClass="adfmf-listItem-captionText"/>
     </amx:cellFormat>
    </amx:rowLayout>
   </amx:tableLayout>
  </amx:listItem>
 </amx:listView>
</amx:panelPage>AddCityView amx page preview looks like below.

Deploy the application to device/emulator/package, Happy Weather Forecast :)

Usage of User Preferences in ADF Mobile

noreply@blogger.com (Deepak Siddappa) — Tue, 19 Feb 2013 14:08:00 +0000

Preferences enable you to add settings that can be configured by end users. In this article will see how to use adfmf:preferenceList to change the display name format setting in the Contacts list at run time.

ADF Mobile supports application-level and application feature-level user preference pages, in this demo I'm using application feature-level user preference page. Preferences are populated with default values at startup. These values are defined in the adf-feature.xml file, on load of application user can click on preferences feature in navigation bar and select the display name format to be displayed.

Application screen looks like below when it deployed and run on Android Device/Emulator. Displays the Contacts list on the screen.

Click on the menu button, this will launch the Navigation Bar with Preferences, Hide Navigation and SpringBoard options. Click on Preferences.

In Contact Preference Screen, clicking on Name Display will open the popup by displaying Name Display formats which are defined in adf-feature.xml file. Now select "LastName FirstName".

I found the way to refresh the Contacts list in the screen, so striking of the below section. Here user don't need to click on the refresh button, after clicking on the device back button will refresh the contact list.

Next click on the device back button will take you to the Contacts screen, notice here data will be displayed in the old format only "FirstName LastName". Here clicking of the device back button handler should be provide to refresh the Contacts list on the screen. I didn't find any ways to refresh list after back button action, so filed the bug against this once I get the solution will update the article. Time being as a workaround provide refresh button, after clicking on refresh button Contacts list will be redraw with updated name display format.

You can download the sample workspace from here. In below section I will not provide all the steps to create the application, only key ones are shown. Above sample download workspace doesn't have extended lifecycle listener class, please follow the below steps to create LifeCycleListener for fetaure.

By design, for a feature to be informed of Device Actions that are sourced from outside of that feature that feature must have a lifecycle listener. Follow the below steps.

Add new Java Class
Set Name and package as desired
Click '+' under Optional Attributes to add an interface
Choose the interface LifeCycleListener (oracle.adfmf.feature), Save (no other changes to default class contents need to be made for this)

Next Open the adfmf-feature.xml and map ExtendedFetureLifeCycleListener.java to LifeCycle Event Listener as shown below.

Use the adfmf:preferences element to create the preferences in adf-feature.xml file as below.

<adfmf:feature id="Preference" name="Preference">
 <adfmf:content id="Preference.1">
  <adfmf:amx file="Preference/ContactList.amx"/>
 </adfmf:content>
 <adfmf:preferences>
  <adfmf:preferenceGroup id="Pref1" label="Contact Preference">
   <adfmf:preferenceList id="Pref1NameDisplay" label="Name Display" default="NF1">
    <adfmf:preferenceValue name="FirstName LastName" value="NF1"/>
    <adfmf:preferenceValue name="LastName FirstName" value="NF2"/>
   </adfmf:preferenceList>
  </adfmf:preferenceGroup>
 </adfmf:preferences>
</adfmf:feature>

In ContactList.amx page access the preference values using EL expression and ternary operator is used the switch between the display names.

#{preferenceScope.feature.Preference.Pref1.Pref1NameDisplay eq 'NF1' ? row.firstLastName : row.lastFirstName}"

ADF Mobile Email - Send Multiple File Attachments with amx:selectManyCheckbox option

noreply@blogger.com (Deepak Siddappa) — Tue, 12 Feb 2013 05:16:00 +0000

Here's a use case: A presenter is showing presentation on their Android/iPhone/iPad devices to the client. After the presentation, client may asks for the presentation files for there further understanding. Now presenter wants to attach all the files used in presentation and send mail to the client.

Application screen looks like below when it deployed and run on Android Device/Emulator. Displays the Employees List in first screen.

Clicking on any employee will leads to the Compose screen, where the selected employee email will be pre-populated in "To" field.

Enter the subject and message details need to be send. Click on "Attach a file" button, a popup window will open and files under the "/mnt/sdcard/Download" folder will be displayed. Now select the files that as to be attached and click on Ok button.

Now notice the attached files will be displayed in-front of Attached Files. Next clicking on Send Email button will take you to the next screen where all the email clients installed in the device will be listed, select any client and send the email.

Tested in Android device, I'm able to send email with multiple attachments. You can download the sample workspace from here.

Implementation Steps

Create an ADF Mobile Application, the application consists of two projects. Application Controller project of Application LifeCycle, Listeners, Device Features DataControl and ViewController project contains mobile features content like AMX Files, Task Flows and DataControl.

In ViewController project, locate and expand the Application Sources folder, create a Employee.java file and add the below code.

public class Employee {
    protected int id;
    protected String firstName;
    protected String lastName;
    protected String email;
    private transient PropertyChangeSupport propertyChangeSupport = new PropertyChangeSupport(this);

    public void addPropertyChangeListener(PropertyChangeListener l) {
        propertyChangeSupport.addPropertyChangeListener(l);
    }

    public void removePropertyChangeListener(PropertyChangeListener l) {
        propertyChangeSupport.removePropertyChangeListener(l);
    }

    public Employee() {
        super();
    }

    public Employee(int id, String firstName, String lastName, String email) {
        super();
        this.id = id;
        this.firstName = firstName;
        this.lastName = lastName;
        this.email = email;
    }

    public void setId(int id) {
        int oldId = this.id;
        this.id = id;
        propertyChangeSupport.firePropertyChange("id", oldId, id);
    }

    public int getId() {
        return id;
    }

    public void setFirstName(String firstName) {
        String oldFirstName = this.firstName;
        this.firstName = firstName;
        propertyChangeSupport.firePropertyChange("first", oldFirstName, firstName);
    }

    public String getFirstName() {
        return firstName;
    }

    public void setLastName(String lastName) {
        String oldLastName = this.lastName;
        this.lastName = lastName;
        propertyChangeSupport.firePropertyChange("last", oldLastName, lastName);
    }

    public String getLastName() {
        return lastName;
    }

    public void setEmail(String email) {
        String oldEmail = this.email;
        this.email = email;
        propertyChangeSupport.firePropertyChange("email", oldEmail, email);
    }

    public String getEmail() {
        return email;
    }
}

Create EmployeeListDC.java file and add the below code, create DataControl based on EmployeeListDC.java file.

public class EmployeeListDC {
    private static List s_employees = null;
    private transient ProviderChangeSupport providerChangeSupport = new ProviderChangeSupport(this);


    public void addProviderChangeListener(ProviderChangeListener l) {
        providerChangeSupport.addProviderChangeListener(l);
    }

    public void removeProviderChangeListener(ProviderChangeListener l) {
        providerChangeSupport.removeProviderChangeListener(l);
    }

    public EmployeeListDC() {
        super();
        if (s_employees == null) {
            s_employees = new ArrayList();
            s_employees.add(new Employee(1, "Praveen", "Thulasiraman", "praveen.thulasiraman@xyz.com"));
            s_employees.add(new Employee(2, "Arul", "wilson", "arul.wilson@xyz.com"));
            s_employees.add(new Employee(3, "Deepak", "Siddappa", "deepak.siddappa@xyz.com"));
            s_employees.add(new Employee(4, "Arun", "Sridhran", "arun.x.sridharan@xyz.com"));
        }
    }

    public Employee[] getEmployees() {
        Employee e[] = null;
        e = (Employee[])s_employees.toArray(new Employee[s_employees.size()]);
        return e;
    }
}

Create FileAttachment.java file and add below code.

public class FileAttachment {
    private int fileIndex;
    private String fileName;
    private String filePath;
    private transient PropertyChangeSupport propertyChangeSupport = new PropertyChangeSupport(this);

    public void addPropertyChangeListener(PropertyChangeListener l) {
        propertyChangeSupport.addPropertyChangeListener(l);
    }

    public void removePropertyChangeListener(PropertyChangeListener l) {
        propertyChangeSupport.removePropertyChangeListener(l);
    }

    public FileAttachment() {
        super();
    }

    public FileAttachment(int fileIndex, String fileName, String filePath) {
        super();
        this.fileName = fileName;
        this.filePath = filePath;
        this.fileIndex = fileIndex;
    }

    public void setFileIndex(int fileIndex) {
        int oldFileIndex = this.fileIndex;
        this.fileIndex = fileIndex;
        propertyChangeSupport.firePropertyChange("fileIndex", oldFileIndex, fileIndex);
    }

    public int getFileIndex() {
        return fileIndex;
    }

    public void setFileName(String fileName) {
        String oldFileName = this.fileName;
        this.fileName = fileName;
        propertyChangeSupport.firePropertyChange("fileName", oldFileName, fileName);
    }

    public String getFileName() {
        return fileName;
    }

    public void setFilePath(String filePath) {
        String oldFilePath = this.filePath;
        this.filePath = filePath;
        propertyChangeSupport.firePropertyChange("fileName", oldFilePath, filePath);
    }

    public String getFilePath() {
        return filePath;
    }
}

Create FileAttachmentListDC.java file and add the below code, create DataControl based on FileAttachmentListDC.java file.

public class FileAttachmentListDC {
    private static List s_FileAttachment = null;
    private transient ProviderChangeSupport providerChangeSupport = new ProviderChangeSupport(this);

    public void addProviderChangeListener(ProviderChangeListener l) {
        providerChangeSupport.addProviderChangeListener(l);
    }

    public void removeProviderChangeListener(ProviderChangeListener l) {
        providerChangeSupport.removeProviderChangeListener(l);
    }

    public FileAttachmentListDC() {
        super();
        if (s_FileAttachment == null) {
            s_FileAttachment = new ArrayList();
            executeReadDir();
        }
    }

    public void executeReadDir() {
        //  String dirName = AdfmfJavaUtilities.getDirectoryPathRoot(AdfmfJavaUtilities.DeviceOnlyDirectory);
        //Hard Coding the Folder path
        String dirName = "/mnt/sdcard/Download";
        try {
            showDir(new File(dirName));
            providerChangeSupport.fireProviderRefresh("FileAttachment");
        } catch (IOException e) {
            e.printStackTrace();
        }
    }

    /**
     * Recursively read the dir and get the file list
     * @param file
     * @throws IOException
     */
    static void showDir(File file) throws IOException {
        int indexCounter = 0;
        if (file.isDirectory()) {
            File[] files = file.listFiles();
            for (int i = 0; i < files.length; i++)
                showDir(files[i]);
        } else {
            s_FileAttachment.add(new FileAttachment(indexCounter, file.getName(), file.getPath()));
            indexCounter++;
        }
    }

    public FileAttachment[] getFileAttachment() {
        FileAttachment a[] = null;
        a = (FileAttachment[])s_FileAttachment.toArray(new FileAttachment[s_FileAttachment.size()]);
        return a;
    }

    /**
     * Clear the PageScopeVariables
     */
    public void clearScopeVariables() {
        ValueExpression ve1 = AdfmfJavaUtilities.getValueExpression("#{pageFlowScope.filePaths}", String.class);
        ve1.setValue(AdfmfJavaUtilities.getAdfELContext(), "");

        ValueExpression ve2 = AdfmfJavaUtilities.getValueExpression("#{pageFlowScope.fileNames}", String.class);
        ve2.setValue(AdfmfJavaUtilities.getAdfELContext(), "");
    }
}

In the Features table, select the newly created feature Email. Under the Features table, click the Content tab, and locate the Content table. Notice that the content item Email.1 is created by default. Next add a new file by clicking the green plus sign and select taskflow option, this will launch the new Create ADF Mobile Task Flow dialog, modify the value as shown below.

Click on the EmailTaskflow.xml to open the file in taskflow editor and follow the below steps.

1) Create two views and name them as EmpList and Email respectively.

2) Draw the control flow case from EmpList to Email and Outcome as "composeEmail", Behavior->Transition as "flipRight".

3) Draw the control flow case from Email to EmpList and Outcome as "empList", Behavior->Transition as "slideLeft".

Double click on EmpList view will launch Create ADF Mobile AMX Page dialog. Open the EmpList.amx page and to source tab and follow the below steps:
1) In Header facet, amx:outputText set the value as "Employee List"
2) From DC palette drag and drop EmployeeListDC->employees->ADF Mobile List View and select the default options
3) From Component palette drag and drop amx:setPropertyListener into amx:listItem and modify the values as shown in below code.

<amx:listView var="row" value="#{bindings.employees.collectionModel}"
			  fetchSize="#{bindings.employees.rangeSize}" id="lv1">
	<amx:listItem id="li1" action="composeEmail">
		<amx:outputText value="#{row.firstName} #{row.lastName}" id="ot2"/>
		<amx:setPropertyListener from="#{row.email}" to="#{pageFlowScope.email}" type="action"/>
	</amx:listItem>
</amx:listView>

Double click on Email view will launch Create ADF Mobile AMX Page dialog, in page facets select Header. Open the Email.amx page and to source tab and follow the below steps:

1) In Header facet, amx:outputText set the value as "Compose"
2) From DC palette drag and drop DeviceFeatures->sendEmail->ADF Mobile Parameter Form
3) Drop the command button and showPopupBehavior on the button
3) From Component palette drag and drop Popup component on the Panel Page
4) Inside the Popup, drop FileAttachmentListDC->fileAttachment->MultipleSelection as ADF Mobile Select Many Checkbox and in Edit List binding dialog select values as below
Multi Select Base Attribute : fileName
Multi Select Display Attribute : filePath
5) Next drop a command button inside the popup window and closePopupBehavior onto the command button.
6) Create the valueChangeListener for amx:selectManyCheckbox

<amx:panelPage id="pp1">
	<amx:facet name="header">
		<amx:outputText value="Compose" id="ot1"/>
	</amx:facet>
	<amx:panelFormLayout id="pfl1" labelPosition="topStart" fieldHalign="start">
		<amx:inputText value="#{pageFlowScope.email}" label="To" id="it4" readOnly="true"/>
		<amx:inputText value="#{bindings.subject.inputValue}" label="Subject" id="it1"/>
		<amx:inputText value="#{bindings.body.inputValue}" label="Body" id="it5"/>
		<amx:inputText value="Attached Files: #{pageFlowScope.fileNames}" label="" id="it3" readOnly="true"/>
	</amx:panelFormLayout>
	<amx:commandButton text="Attach a file" id="cb3" styleClass="adfmf-commandButton-rounded">
		<amx:showPopupBehavior popupId="AttachmentPopup" type="action" align="overlapBottom" alignId="pp1"/>
	</amx:commandButton>
	<amx:commandButton actionListener="#{bindings.sendEmail.execute}" text="Send Email"
					   disabled="#{!bindings.sendEmail.enabled}" id="cb1" action="empList"
					   styleClass="adfmf-commandButton-rounded"/>
</amx:panelPage>
<amx:popup id="AttachmentPopup" animation="slideUp">
	<amx:selectManyCheckbox value="#{bindings.fileAttachment.inputValue}" id="smc1"
							valueChangeListener="#{pageFlowScope.EmailBean.fetchSelectedFileNames}">
		<amx:selectItems value="#{bindings.fileAttachment.items}"/>
	</amx:selectManyCheckbox>
	<amx:commandButton text="Ok" id="cb2" styleClass="adfmf-commandButton-rounded ">
		<amx:closePopupBehavior popupId="AttachmentPopup" type="action"/>
	</amx:commandButton>
</amx:popup>

7) Create a pageFlowScope managed bean and copy the below method code.

/**
 * Get the selected filePaths
 * @param valueChangeEvent
 */
public void fetchSelectedFileNames(ValueChangeEvent valueChangeEvent) {
	Object[] objArr = (Object[])valueChangeEvent.getNewValue();

	ValueExpression ve =
		AdfmfJavaUtilities.getValueExpression("#{bindings.fileAttachment1.collectionModel}", AmxCollectionModel.class);
	AmxCollectionModel model = (AmxCollectionModel)ve.getValue(AdfmfJavaUtilities.getAdfELContext());

	StringBuffer sbFilePath = new StringBuffer();
	StringBuffer sbFileName = new StringBuffer();
	for (int x = 0; x < objArr.length; x++) {
		Object obj = objArr[x];

		Map provider = (Map)model.getProviders().get(obj);
		String filePathVal = provider.get("filePath").toString();
		sbFilePath.append("," + filePathVal.toString());

		String fileNameval = provider.get("fileName").toString();
		sbFileName.append("," + fileNameval.toString());
	}

	ValueExpression ve1 = AdfmfJavaUtilities.getValueExpression("#{pageFlowScope.filePaths}", String.class);
	ve1.setValue(AdfmfJavaUtilities.getAdfELContext(), sbFilePath.substring(1));

	ValueExpression ve2 = AdfmfJavaUtilities.getValueExpression("#{pageFlowScope.fileNames}", String.class);
	ve2.setValue(AdfmfJavaUtilities.getAdfELContext(), sbFileName.substring(1));
}

8) Go to the bindings tab and modify the values as below for sendEmail Method

9) Create a tree binding as shown below.

10) Create a Action binding

11) Click on Create Executable binding and select Invoke action and follow as shown in below image.

Edit clearVars invoke action and set the Refresh to always, so when ever page loads clearScopeVariables method will get executed to clear all the pageFlowScope variable values.

In the Application menu, select Deploy - New Deployment Profile to start the Create Deployment Profile dialog box. In the Profile Type drop-down list, ensure ADF Mobile for Android/IOS is selected and then click OK. Next select Deploy - New Deployment deployment profile. In the subsequent dialog box, select Deploy application to device/emulator/package, and click Finish.

Adf Mobile - Iterate through all the rows in tree binding using CollectionModel

noreply@blogger.com (Deepak Siddappa) — Fri, 08 Feb 2013 17:27:00 +0000

Scenario is how to iterate through all the rows in tree bindings using managed bean method, using collectionModel we can get the rows. collectionModel exposes a collection of data, EL expressions used within a component that is bound to a collectionModel can be referenced with a row variable, which will resolve the expression for each element in the collection.

Here is the code below which iterate through the rows using collection model. Make sure the departments should be of type Tree binding.

ValueExpression ve1 =
 AdfmfJavaUtilities.getValueExpression("#{bindings.departments.collectionModel}", AmxCollectionModel.class);
AmxCollectionModel model = (AmxCollectionModel)ve1.getValue(AdfmfJavaUtilities.getAdfELContext());

StringBuffer deptNamesString = new StringBuffer();
Object[] myArr = model.getKeys();
for (int x = 0; x < myArr.length; x++) {
 Object myObj = myArr[x];
 Map provider = (Map)model.getProviders().get(myObj);
 String val = provider.get("deptName").toString();
 deptNamesString.append("," + val);
}
//Populating the pageFlowscope variable, which will be displayed in amx page
ValueExpression ve2 =
 AdfmfJavaUtilities.getValueExpression("#{pageFlowScope.departmentNameString}", String.class);
ve2.setValue(AdfmfJavaUtilities.getAdfELContext(), deptNamesString.substring(1));

You can download the sample workspace from here. Application screen looks like below when it deployed and run on Android Device/Emulator. In first screen DepartmentNames values will be empty after clicking on Execute button, in managed bean method using collection model rows will be iterated and stored in pageFlowScope variable, same variable value will be displayed on the screen.

How to retrieve Selected Items from selectManyCheckbox using ValueChnageListener

noreply@blogger.com (Deepak Siddappa) — Fri, 08 Feb 2013 07:51:00 +0000

The selectManyCheckbox component creates a component which allows the user to select many values from a series of checkboxes. Below is the code to retrieve selected items from selectManyCheckbox using ValueChangeListener method.

Note:- valueChangeEvent.getNewValue() will return Object value like [Ljava.lang.Object;@fcfd12, need to loop the object arrayList to get the values.

public void myValueChangeListener(ValueChangeEvent valueChangeEvent) {
        Object[] objArr = (Object[])valueChangeEvent.getNewValue();
        for (int x = 0; x < objArr.length; x++) {
            Object obj = objArr[x];
            System.out.println(obj.toString());
       }
}

In Below image, how the selectManyCheckbox will be displayed at run time and user selected check box values will be displayed in Jdeveloper console.

ADF Mobile - Create Drill Down Graph Reports

noreply@blogger.com (Deepak Siddappa) — Thu, 31 Jan 2013 14:06:00 +0000

Drill Down Graph Report - Scenario here is to show all the cars sales report for this year in Pie Chart and when user click a individual car in pie chart slice, a drill through report opens, which accepts the car type as a parameter, and then displays car models sale in Bar Chart.

In ADF Mobile, "clickListener" method is not provided for DVT components. Click listener interface will receive click events on the gauge components and can do further data process in BC4J. In ADF Mobile "Action" method is supported on DataItem in the graphs. Action defines a reference to the an action method sent by the command button component, or static outcome of an action. So in this article I'm explaining how to build drill down reports using <dvtm:pieChart> and <dvtm:barChart>.

Application screen looks like below when it deployed and run on Android Device/Emulator. Displays the Cars Sales Reports in first screen.

In above screen, slide the screen towards right. Notice only check boxes are displayed and attributes values(Legends) are not getting displayed for the pie chart slices, this could be an error.

Next click on any pie chart slice and respective car models will be displayed in Bar Chart screen.

You can download the sample workspace from here

[Runs with Oracle JDeveloper 11.1.2.3.0]

Implementation Steps

Create an ADF Mobile Application, the application consists of two projects. Application Controller project of Application LifeCycle, Listeners, Device Features DataControl and ViewController project contains mobile features content like AMX Files, Task Flows and DataControl.

In ViewController project, locate and expand the Application Sources folder, create a Cars.java file and add the below code.

public class Cars {
    private String carName;
    private int carSalesCount;
    private transient PropertyChangeSupport propertyChangeSupport = new PropertyChangeSupport(this);

    public Cars() {
        super();
    }

    public Cars(String carName, int carSalesCount) {
        this.carName = carName;
        this.carSalesCount = carSalesCount;
    }

    public void setCarName(String carName) {
        String oldCarName = this.carName;
        this.carName = carName;
        propertyChangeSupport.firePropertyChange("carName", oldCarName, carName);
    }

    public String getCarName() {
        return carName;
    }

    public void setCarSalesCount(int carSalesCount) {
        int oldCarSalesCount = this.carSalesCount;
        this.carSalesCount = carSalesCount;
        propertyChangeSupport.firePropertyChange("carSalesCount", oldCarSalesCount, carSalesCount);
    }

    public int getCarSalesCount() {
        return carSalesCount;
    }

    public void setPropertyChangeSupport(PropertyChangeSupport propertyChangeSupport) {
        this.propertyChangeSupport = propertyChangeSupport;
    }

    public PropertyChangeSupport getPropertyChangeSupport() {
        return propertyChangeSupport;
    }
}

Create CarModels.java file and add the below code.

public class CarModels extends Cars {
    private String modelName;
    private int modelSalesCount;
    private transient PropertyChangeSupport propertyChangeSupport = new PropertyChangeSupport(this);

    public CarModels() {
        super();
    }

    public CarModels(String carName, String modelName, int modelSalesCount) {
        super();
        setCarName(carName);
        this.modelName = modelName;
        this.modelSalesCount = modelSalesCount;
    }

    public void setModelName(String modelName) {
        String oldModelName = this.modelName;
        this.modelName = modelName;
        propertyChangeSupport.firePropertyChange("modelName", oldModelName, modelName);
    }

    public String getModelName() {
        return modelName;
    }

    public void setModelSalesCount(int modelSalesCount) {
        int oldModelSalesCount = this.modelSalesCount;
        this.modelSalesCount = modelSalesCount;
        propertyChangeSupport.firePropertyChange("modelSalesCount", oldModelSalesCount, modelSalesCount);
    }

    public int getModelSalesCount() {
        return modelSalesCount;
    }

    public void setPropertyChangeSupport(PropertyChangeSupport propertyChangeSupport) {
        this.propertyChangeSupport = propertyChangeSupport;
    }

    public PropertyChangeSupport getPropertyChangeSupport() {
        return propertyChangeSupport;
    }
}

Create Generic.java file and add the below code, create DataControl based on Generic.java file.

public class Generic {
    private static List s_cars = null;
    private static List s_carModels = null;
    private static List s_filterCarModels = null;
    private transient ProviderChangeSupport providerChangeSupport = new ProviderChangeSupport(this);
    private transient PropertyChangeSupport propertyChangeSupport = new PropertyChangeSupport(this);

    public Generic() {
        super();
        if (s_cars == null) {
            s_cars = new ArrayList();
            s_cars.add(new Cars("Audi", 2000));
            s_cars.add(new Cars("BMW", 2500));
            s_cars.add(new Cars("Honda", 5000));
            s_cars.add(new Cars("Mitsubishi", 1000));
            s_cars.add(new Cars("Toyota", 4000));
            s_cars.add(new Cars("Volkswagen", 3000));
        }
        if (s_carModels == null) {
            s_carModels = new ArrayList();
            s_carModels.add(new CarModels("Audi", "A3", 300));
            s_carModels.add(new CarModels("Audi", "A4", 1000));
            s_carModels.add(new CarModels("Audi", "Quattro", 700));
            s_carModels.add(new CarModels("BMW", "BMW128", 1000));
            s_carModels.add(new CarModels("BMW", "BMW528", 800));
            s_carModels.add(new CarModels("BMW", "Gran Coupe", 700));
            s_carModels.add(new CarModels("Honda", "Accord", 1200));
            s_carModels.add(new CarModels("Honda", "Civic", 2000));
            s_carModels.add(new CarModels("Honda", "Hybrid", 1800));
            s_carModels.add(new CarModels("Mitsubishi", "Lancer", 400));
            s_carModels.add(new CarModels("Mitsubishi", "Evolution", 300));
            s_carModels.add(new CarModels("Mitsubishi", "Outlander", 300));
            s_carModels.add(new CarModels("Toyota", "Camry", 1800));
            s_carModels.add(new CarModels("Toyota", "Corolla", 1200));
            s_carModels.add(new CarModels("Toyota", "Cruiser", 1000));
            s_carModels.add(new CarModels("Volkswagen", "Beetle", 1300));
            s_carModels.add(new CarModels("Volkswagen", "Jetta", 800));
            s_carModels.add(new CarModels("Volkswagen", "Tiguan", 900));
        }

    }

    public void addPropertyChangeListener(PropertyChangeListener l) {
        propertyChangeSupport.addPropertyChangeListener(l);
    }

    public void removePropertyChangeListener(PropertyChangeListener l) {
        propertyChangeSupport.removePropertyChangeListener(l);
    }

    public void addProviderChangeListener(ProviderChangeListener l) {
        providerChangeSupport.addProviderChangeListener(l);
    }

    public void removeProviderChangeListener(ProviderChangeListener l) {
        providerChangeSupport.removeProviderChangeListener(l);
    }

    /**
     * Method will populate the result list to s_cars.
     */
    public Cars[] getCars() {
        Cars c[] = null;
        c = (Cars[])s_cars.toArray(new Cars[s_cars.size()]);
        return c;
    }

    /**
     * Method will populate the result list to s_carModels.
     */
    public CarModels[] getCarModels() {
        CarModels cm[] = null;
        cm = (CarModels[])s_carModels.toArray(new CarModels[s_carModels.size()]);
        return cm;
    }

    /**
     * Method will filter the result from s_carModels list.
     */
    public CarModels[] filteredCarModels(String carType) {
        CarModels cm[] = null;
        s_filterCarModels = new ArrayList();
        for (Iterator i = s_carModels.iterator(); i.hasNext(); ) {
            CarModels curCM = (CarModels)i.next();
            if (curCM.getCarName().equals(carType)) {
                s_filterCarModels.add(new CarModels(curCM.getCarName(), curCM.getModelName(),
                                                    curCM.getModelSalesCount()));
            }
        }
        cm = (CarModels[])s_filterCarModels.toArray(new CarModels[s_filterCarModels.size()]);
        providerChangeSupport.fireProviderRefresh("carModels");
        return cm;
    }
}

In the Features table, select the newly created feature Graph. Under the Features table, click the Content tab, and locate the Content table. Notice that the content item Graph.1 is created by default. Next add a new file by clicking the green plus sign and select taskflow option, this will launch the new Create ADF Mobile Task Flow dialog, modify the value as shown below.

Click on the GraphTaskflow.xml to open the file in taskflow editor and follow the below steps.
1) Create two views and name them as carsView and carModelsView respectively.
2) Draw the control flow case from carsView to carModelsView and Outcome as "carsModel", Behavior->Transition as "flipRight".
3) Draw the control flow case from carModelsView to carsView and Outcome as "car", Behavior->Transition as "slideLeft".

Double click on carsView view will launch Create ADF Mobile AMX Page dialog. Open the carsView.amx page and to source tab and follow the below steps:

1) In Header facet, amx:outputText set the value as "Sales Report"
2) From DC palette drag and drop Generic->Cars->ADF Mobile Chart and in Component Gallery dialog, select Pie chart and click ok.
3) In Create Mobile Pie Chart dialog, select the values as shown in below image.

4) For dvtm:pieDataItem, set the action as "action" and drop amx:setPropertyListener and modify the values as shown in below code.

 <dvtm:pieChart var="row" value="#{bindings.cars.collectionModel}" id="pc1" animationOnDisplay="auto"
                       inlineStyle="width:400px; height:280px; float:left; background-color:white;" threeDEffect="on"
                       title="Car">
            <amx:facet name="dataStamp">
                <dvtm:pieDataItem sliceId="#{row.carName}" value="#{row.carSalesCount}" action="carsModel">
                    <amx:setPropertyListener from="#{row.carName}" to="#{pageFlowScope.carName}"/>
                </dvtm:pieDataItem>
            </amx:facet>
 </dvtm:pieChart>

Double click on carModelsView view will launch Create ADF Mobile AMX Page dialog, in page facets select Header, Primary Action. Open the deptList.amx page and to source tab and follow the below steps:

1) In Header facet, amx:outputText set the value as "Sales Report"
2) In Seconday Action facet, for amx:commandButton modify the values text: Back, action: __back.
3) From DC palette drag and drop Generic->filteredCarModels->CarModels->ADF Mobile Chart and in Component Gallery dialog, select Bar chart and click ok.
4) In Create Mobile Bar Chart dialog, select the values as shown in below image.

Enter the carType parameter value as #{pageFlowScope.carName}.

Open the carModelsView.amx and modify the properties for dvtm:barChart as shown below.

<dvtm:barChart var="row" value="#{bindings.CarModels.collectionModel}" id="bc1"
      inlineStyle="width:400px; height:300px; float:left; background-color:white;"
      title="#{pageFlowScope.carName} Car Models">
 <amx:facet name="dataStamp">
  <dvtm:chartDataItem group="#{row.modelName}" value="#{row.modelSalesCount}" series="Sales Count"/>
 </amx:facet>
 <dvtm:legend position="end" id="l1"/>
</dvtm:barChart>

Click on Create Executable binding and select Invoke action and follow as shown in below image.

Edit invokeFilterdCarModels invoke actiion and set the Refresh to always, so when ever page loads employeesTotalRows method will get executed.

Note:- When the screen loads for the first time Bar Chart will get cached and for second time execution filteredCarModels method will not get executed at all even if the parameter value changed. To overcome this we have to set invoke Action for filteredCarModels method, this executes the invokeAction every time a page is navigated to regardless of the state of the binding container.

Preview of the carsView.amx and carModelsView.amx will looks like below.

ADF Mobile - Access Device Native SQLite Database to Store Data

noreply@blogger.com (Deepak Siddappa) — Thu, 24 Jan 2013 12:33:00 +0000

Today I learnt on how to access device native SQLite database to store data and perform CRUD operations. This is my first article on ADF Mobile, In this article I will show on how to read data for display, create and save new record to the database.

You can find more examples in Oracle ADF Mobile Samples, by looking into the samples and Debugging ADF Mobile Apps on Android. I was able to use SQLite database to store the data.

Download the sample workspace from here and application screen looks like below when it deployed to Android Emulator. Displaying the Departments List is fetched from SQLite, click on the Add button to create new department record.

Enter the details in the department form and click on Save button. The Department information will saved to the database and moved to Dept List screen.

Department list will get updated by newly added department record.

Implementation Steps

Create an ADF Mobile Application, the application consists of two projects. Application Controller project of Application LifeCycle, Listeners, Device Features DataControl and ViewController project contains mobile features content like AMX Files, Task Flows and DataControl.

In Application Controller project. Create a DBConnectionFactory.java class and copy the below code, this class contains code for connecting to SQLlite DB. Connecting to the SQLite database is somewhat different from opening a connection to an Oracle database, here use the java.sql.Connection object associated with your application to connect to the SQLite database.

public class DBConnectionFactory {
    protected static Connection conn = null;

    public DBConnectionFactory() {
        super();
    }

    /**
     * Connect to the SQLite database
     * @return
     * @throws Exception
     */
    public static Connection getConnection() throws Exception {
        if (conn == null) {
            try {
                // ApplicationDirectory returns the private read-write sandbox area
                // of the mobile device's file system that this application can access.
                // This is where the database is created
                String Dir = AdfmfJavaUtilities.getDirectoryPathRoot(AdfmfJavaUtilities.ApplicationDirectory);
                String connStr = "jdbc:sqlite:" + Dir + "/DEMO.db";

                // If the database does not exist, a new database is automatically
                // created when the SQLite JDBC connection is created
                conn = new SQLite.JDBCDataSource(connStr).getConnection();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
        return conn;
    }
}

Note:- demo.sql file should be put in .adf/META-INF/ folder. You can get the sql file by downloading the MobileDemo application.

Open LifeCycleListenerImpl.java file and add the below method code.

/**
* This method will read the sql file and
* commit the sql statements to the SQLite DB
*/
private void InitDB() {
	try {
		// Since the SQL script has been packaged as a resource within
		// the application, the getResourceAsStream method is used
		ClassLoader cl = Thread.currentThread().getContextClassLoader();
		InputStream is = cl.getResourceAsStream(".adf/META-INF/demo.sql");
		if (is == null) {
			System.err.println("Could not look up : .adf/META-INF/demo.sql");
			return;
		}

		BufferedReader bReader = new BufferedReader(new InputStreamReader(is));
		List stmts = new ArrayList();
		String strstmt = "";
		String ln = bReader.readLine();

		// The while loop iterates over all the lines in the SQL script,
		// assembling them into valid SQL statements and executing them as
		// a terminating semicolon is encountered
		while (ln != null) {
			// Skipping blank lines, comments, and COMMIT statements
			if (ln.startsWith("REM") || ln.startsWith("COMMIT")) {
				ln = bReader.readLine();
				continue;
			}
			strstmt = strstmt + ln;
			if (strstmt.endsWith(";")) {
				stmts.add(strstmt);
				strstmt = "";
				ln = bReader.readLine();
				continue;
			}
			ln = bReader.readLine();
		}

		// To improve performance, the statements are executed
		// one at a time in the context of a single transaction
		DBConnectionFactory.getConnection().setAutoCommit(false);
		for (int i = 0; i < stmts.size(); i++) {
			Statement pStmt = DBConnectionFactory.getConnection().createStatement();
			pStmt.executeUpdate((String)stmts.get(i));
		}
		DBConnectionFactory.getConnection().commit();
	} catch (Exception e) {
		e.printStackTrace();
	}
}

In Start() method LifeCycleListenerImpl.java file, add the below code.

try {
	//Getting the connection to the database
	Statement stat = DBConnectionFactory.getConnection().createStatement();
	ResultSet rs = stat.executeQuery("SELECT * FROM DEPARTMENTS;");
  } catch (SQLException e) {
	// if the error message is "out of memory",
	// it probably means no database file is found
	InitDB();
  } catch (Exception e) {
	e.printStackTrace();
}

Expand the ViewController project. Locate and expand the Application Sources folder, create a Department.java file and add the below code.

public class Department {
    protected int deptId;
    protected String deptName;
    protected int mgrId;
    protected int locId;
    private transient PropertyChangeSupport propertyChangeSupport = new PropertyChangeSupport(this);

    public Department() {
        super();
    }

    public Department(int deptId, String deptName, int mgrId, int locId) {
        setDeptId(deptId);
        setDeptName(deptName);
        setMgrId(mgrId);
        setLocId(locId);
    }

    Department(Department newDept) {
        setDeptId(newDept.getDeptId());
        setDeptName(newDept.getDeptName());
        setMgrId(newDept.getMgrId());
        setLocId(newDept.getLocId());
    }

    public String getKey() {
        Integer i = new Integer(deptId);
        return i.toString();
    }

    public void addPropertyChangeListener(PropertyChangeListener l) {
        propertyChangeSupport.addPropertyChangeListener(l);
    }

    public void removePropertyChangeListener(PropertyChangeListener l) {
        propertyChangeSupport.removePropertyChangeListener(l);
    }


    public void setDeptId(int deptId) {
        int oldDeptId = this.deptId;
        this.deptId = deptId;
        propertyChangeSupport.firePropertyChange("deptId", oldDeptId, deptId);
    }

    public int getDeptId() {
        return deptId;
    }

    public void setDeptName(String deptName) {
        String oldDeptName = this.deptName;
        this.deptName = deptName;
        propertyChangeSupport.firePropertyChange("deptName", oldDeptName, deptName);
    }

    public String getDeptName() {
        return deptName;
    }

    public void setMgrId(int mgrId) {
        int oldMgrId = this.mgrId;
        this.mgrId = mgrId;
        propertyChangeSupport.firePropertyChange("mgrId", oldMgrId, mgrId);
    }

    public int getMgrId() {
        return mgrId;
    }

    public void setLocId(int locId) {
        int oldLocId = this.locId;
        this.locId = locId;
        propertyChangeSupport.firePropertyChange("locId", oldLocId, locId);
    }

    public int getLocId() {
        return locId;
    }
}

Create DepartmentList.java file and add the below code. Create DataControl based on DepartmentList.java file.

public class DepartmentList {
    private static List s_departments = null;
    private Department editDepartment = new Department();

    private transient ProviderChangeSupport providerChangeSupport = new ProviderChangeSupport(this);

    public void addProviderChangeListener(ProviderChangeListener l) {
        providerChangeSupport.addProviderChangeListener(l);
    }

    public void removeProviderChangeListener(ProviderChangeListener l) {
        providerChangeSupport.removeProviderChangeListener(l);
    }

    public DepartmentList() {
        if (s_departments == null) {
            s_departments = new ArrayList();
            Execute();
        }
    }

    /**
     * Method will query the database and populate
     * the result list to s_departments
     */
    public void Execute() {
        Trace.log(Utility.ApplicationLogger, Level.INFO, DepartmentList.class, "Execute",
                  "Coming Inside Execute Method");
        try {
            Connection conn = DBConnectionFactory.getConnection();
            s_departments.clear();
            conn.setAutoCommit(false);
            PreparedStatement stat = conn.prepareStatement("SELECT * from DEPARTMENTS ORDER BY DEPARTMENT_NAME");
            ResultSet rs = stat.executeQuery();
            while (rs.next()) {
                int id = rs.getInt("DEPARTMENT_ID");
                String deptName = rs.getString("DEPARTMENT_NAME");
                int mgrId = rs.getInt("MANAGER_ID");
                int locId = rs.getInt("LOCATION_ID");
                Department d = new Department(id, deptName, mgrId, locId);
                s_departments.add(d);
            }
            rs.close();
            Trace.log(Utility.ApplicationLogger, Level.INFO, DepartmentList.class, "Execute",
                      "Exiting from Execute Method");
            //  providerChangeSupport.fireProviderRefresh("departments");
        } catch (SQLException e) {
            System.err.println(e.getMessage());
        } catch (Exception e) {
            System.err.println(e.getMessage());
        }
    }

    /**
     * Method will get count of departments in database
     * @return
     */
    public int getDepartmentCount() {
        return s_departments.size();
    }

    /**
     * Method will get the list of departments
     * @return
     */
    public Department[] getDepartments() {
        Department d[] = null;
        d = (Department[])s_departments.toArray(new Department[s_departments.size()]);
        return d;
    }

    /**
     * Method will create new deptartment object instance
     */
    public void AddDepartment() {
        Trace.log(Utility.ApplicationLogger, Level.INFO, DepartmentList.class, "AddDepartment",
                  "Coming inside AddDepartment");
        //Incrementing the intial deptId by 10
        int deptId = getDepartmentCount() + 10;
        setEditDepartment(new Department(deptId, "", 0, 0));
        Trace.log(Utility.ApplicationLogger, Level.INFO, DepartmentList.class, "AddDepartment",
                  "Exiting AddDepartment");
    }

    /**
     * Method will commit the details of newly created department object
     * @return
     */
    public boolean AddDepartmentToDB() {
        Trace.log(Utility.ApplicationLogger, Level.INFO, DepartmentList.class, "AddDepartmentToDB",
                  "Coming inside AddDepartmentToDB");
        boolean result = false;
        try {
            Connection conn = DBConnectionFactory.getConnection();
            conn.setAutoCommit(false);
            String insertSQL =
                "Insert into DEPARTMENTS (DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) values (?,?,?,?)";
            PreparedStatement pStmt = conn.prepareStatement(insertSQL);
            pStmt.setInt(1, editDepartment.getDeptId());
            pStmt.setString(2, editDepartment.getDeptName());
            pStmt.setInt(3, editDepartment.getMgrId());
            pStmt.setInt(4, editDepartment.getLocId());
            pStmt.execute();
            conn.commit();
            result = true;
        } catch (SQLException e) {
            System.err.println(e.getMessage());
        } catch (Exception e) {
            System.err.println(e.getMessage());
        }
        Trace.log(Utility.ApplicationLogger, Level.INFO, DepartmentList.class, "AddDepartment",
                  "Exiting AddDepartmentToDB");
        return result;
    }

    /**
     * Method will call the AddDepartmentToDB
     * Call PropertyChangeSupport listener to push data changes to the UI
     */
    public void saveDepartment() {
        Trace.log(Utility.ApplicationLogger, Level.INFO, DepartmentList.class, "saveDepartment",
                  "Coming inside saveDepartment");
        if (AddDepartmentToDB()) {
            Department newDepartment = new Department(editDepartment);
            s_departments.add(0, newDepartment);
            providerChangeSupport.fireProviderCreate("departments", newDepartment.getKey(), newDepartment);
        }
        Trace.log(Utility.ApplicationLogger, Level.INFO, DepartmentList.class, "saveDepartment",
                  "Exiting saveDepartment");
    }

    public void setEditDepartment(Department editDepartment) {
        this.editDepartment = editDepartment;
    }

    public Department getEditDepartment() {
        return editDepartment;
    }
}

Note:- Import Error might be showing in DepartmentList java, in viewController project properties->Dependencies add the ApplicationContoller.jpr

In ViewController project. Locate and expand the Application Sources folder, then expand the META-INF folder. You will see the adfmf-feature.xml file, click on the adfmf-feature.xml file to launch the Feature editor. Add a new feature by clicking the green plus sign on the Features table near top of the editor this will launch the new Create ADF Mobile Feature dialog, modify the values as shown below.

Click on the DepartmentsTaskflow.xml to open the file in taskflow editor and follow the below steps.
1) Create views and name them as deptList and editDept respectively.
2) Draw the control flow case from deptList to editDept and Outcome as "add", Behavior->Transition as "flipRight".
3) Draw the control flow case from editDept to deptList and Outcome as "list", Behavior->Transition as "slideRight".

Double click on deptList view will launch Create ADF Mobile AMX Page dialog, in page facets select Header and Secondary Action. Open the deptList.amx page and go to page bindings, in Bindings section click on create control binding and select methodAction item. In create action binding wizard select DepartmentList->AddDepartment

Go to source tab and follow the below steps:
1) In Header facet, amx:outputText set the value as "Dept List"
2) In Seconday Action facet, for amx:commandButton modify the values
text: Add, action: add, actionListener: #{bindings.AddDepartment.execute}
3) From DC palette drag and drop departments->ADF Mobile List View and select the default options

Double click on editDept view will launch Create ADF Mobile AMX Page dialog, in page facets select Header, Primary Action and Secondary Action. Open the deptList.amx page and go to page bindings, in Bindings section click on create control binding and select methodAction item. In create action binding wizard select DepartmentList->saveDepartment

Go to source tab and follow the below steps:
1) In Header facet, amx:outputText set the value as "Add Dept"
2) In Primary Action facet, for amx:commandButton modify the values
text:Cancel, action:_back
3) In Seconday Action facet, for amx:commandButton modify the values
text: Save, action: _back, actionListener: #{bindings.saveDepartment.execute}
4) From DC palette drag and drop editDepartments->Form as ADF Mobile form, In Edit Form fields delete "key" value binding

Preview of the deptList.amx and editDept.amx will looks like below.

Now last configuration, in Application Resources palette expand Descriptor->ADF META-INF. You will see the adfmf-application.xml, click on the adfmf-application.xml file to launch the adfmf-application editor. In Application section for Lifecycle Event Listener set as "application.LifeCycleListenerImpl".

Make sure the below Libraries and Classpath present in the ViewController project.

In the ADF Mobile for Android Deployment Profile Properties dialog box, Select the Android Options node and confirm your values look like the ones below.

In the Application menu, select Deploy - New Deployment deployment profile. In the subsequent dialog box, select Deploy application to device/emulator/package, and click Finish.

Watch the Deployment Log window for any errors.

EJB DC - Deleting Multi-Selected Rows From Adf Table

noreply@blogger.com (Deepak Siddappa) — Thu, 17 Jan 2013 17:57:00 +0000

Let us take a scenario where in users wants to delete multiple records in the ADF table. In EJB this can't be achieved in straight forward way, we have to manually get all the selected row keys and delete the rows data using EntityManager API.

You can download the sample workspace from here
[Runs with Oracle JDeveloper 11.1.2.3.0 + HR Schema]

You can also look at how to achieve in this article link "Update multiple rows using EJB Data Control".

Implementation Steps

Create Fusion Web Application with entity based on Departments, then create a stateless session bean and add the below method. Expose the method to local/remote interface and generate data control.

Note:- Here in the below code "em" is a EntityManager.

/**
* Here param deptList will be having the selected row.
* Iterating through the deptList and find the depratments object instance by primary key
* Delete the data using entity manager api
* @param deptList
*/
public void deleteMultipleDeptRows(List deptList) {
	if (deptList.size() > 0) {
		Iterator iter = deptList.iterator();
		while (iter.hasNext()) {
			HashMap map = (HashMap)iter.next();
			//Finding the departments object instance
			Departments departments = em.find(Departments.class, map.get("departmentId"));
			em.remove(departments);
		}
	}
}

Create index.jspx page and drag and drop departmentsFindAll->Table as ADF Table. and create the backingBean as "IndexBean". Surround the table with panel collection, add the toolbar, drop button inside toolbar and name as "Delete Multiple Rows".

Bind the departments table to the backing bean as show below.

Create the ActionListener method called "deleteAction" for save button.

Open the IndexBean backing bean and add the below code.

public void deleteAction(ActionEvent actionEvent) {
	RowKeySet selectedDepts = getDeptTable().getSelectedRowKeys();
	Iterator selectedDeptIter = selectedDepts.iterator();
	DCBindingContainer bindings = (DCBindingContainer)BindingContext.getCurrent().getCurrentBindingsEntry();
	DCIteratorBinding deptIter = bindings.findIteratorBinding("departmentsFindAllIterator");
	RowSetIterator deptRSIter = deptIter.getRowSetIterator();
	List deptList = new ArrayList();
	while (selectedDeptIter.hasNext()) {
		Key key = (Key)((List)selectedDeptIter.next()).get(0);
		Row currentRow = deptRSIter.getRow(key);

		HashMap rowValues = new HashMap();
		rowValues.put("departmentId", currentRow.getAttribute("departmentId"));
		deptList.add(rowValues);
	}
	//Execute the deleteMultipleDeptRows method by passing deptList param
	OperationBinding oper = bindings.getOperationBinding("deleteMultipleDeptRows");
	oper.getParamsMap().put("deptList", deptList);
	oper.execute();
	deptIter.executeQuery();
	//Refresh the table
	AdfFacesContext.getCurrentInstance().addPartialTarget(this.getDeptTable());
}

Go to Bindings tab in index.jspx page and add deleteMultipleDeptRows method action.

Run the index.jspx page, select the multiple rows and clicking on "Delete Multiple Rows" button should delete the multiple records from the database.

Create ADF Input Form Without First Displaying Existing Records

noreply@blogger.com (Deepak Siddappa) — Wed, 16 Jan 2013 16:17:00 +0000

You can create a form that allows a user to enter information for a new record and then commit that record into the data source. While you can choose to use the default ADF Form and then drop the Create operation as a command button, when this type of form is first rendered, it displays the data for the first instance in the collection.

The ADF Creation form allows users to create new instances in the collection without first displaying existing instances, this scenario might be very simple but the new developers find difficulty in creating empty ADF Input Form when page loads for the first time.

You can download the sample workspace from here.
[Runs with Oracle JDeveloper 11.1.2.2.0 + HR Schema]

Implementation Steps:-

Create Fusion web application with Business Components from Tables based on Department table. In view controller project create a jspx page then drag and drop DepartmentsView1->Form as ADF Form as shown in below image.

Go to page bindings, in Bindings section click on create control binding and select action item. In create action binding wizard select AppModuleDataControl->DepartmentsView1->Operation->createInsert.

In Executables section click in create executables Binding and select invokeAction item. In Insert invokeAction wizard and follow as shown in below image.

Edit the invokeCreateInsert and set the refresh to renderModel because when ever the page loaded this will execute the createInsert operation by inserting the empty record in the collection.

Run the jspx page and the web page will loaded with empty record.

Solr Search integration with ADF Faces - Part 1

noreply@blogger.com (Deepak Siddappa) — Tue, 11 Dec 2012 10:29:00 +0000

Solr is the popular, blazing fast open source enterprise search platform from the Apache Lucene project. Its major features include powerful full-text search, hit highlighting, faceted search, dynamic clustering, database integration, rich document (e.g., Word, PDF) handling, and geospatial search.

Here why I'm trying to integrate Solr search with ADF Faces is, take a scenario where we need to build an EBook application having large data set. Each book may consists some 200 pages, If user wants to search some content inside the book or in cross books. It's very difficult to search in which page of the book the content exits and more over it will be overhead on DB server. By using Solr we can avoid this and do content indexing and do full-text also.

In Part 1, will learn on how to do content indexing. In my next post - Part 2, I will show how full-text search can be integrated with ADF application. Follow the article to install Solr server n windows, I have installed the Apache Solr 4.0 version, after the complete installation of jdk, tomcat, solr we can see the screen as follows, click on the collection1 schema and notice Num Docs will be 0.

Next download the SolrJ version 4.0, Solrj is a java client to access solr. It offers a java interface to add, update, and query the solr index.

Model Diagram: Download the sql script.

Next is to add the fields that will be indexed in Solr server, open the C:\solr\collection1\conf\schema.xml and alert the schema file by adding the below fields under <fields> tag. Before adding below fields shutdown the tomcat server.

Notice few fields will be already there, so add only missing fields then start the tomcat server and try to access the Solr admin. If the page doesn't load properly then schema file has some issue.

Create Fusion Web Application with entities based on category and product tables. Create a session bean and java client, add the following jar in "Project Properties-> Libraries and ClassPath":

apache-solr-solrj-4.0.0
commons-codec-1.3
commons-httpclient-3.1
commons-io-2.1
jcl-over-slf4j-1.6.4
slf4j-api-1.6.4
slf4j-jdk14-1.6.4
solr-solrj-1.4.0

All the above jar will be present in downloaded "apache-solr-4.0.0\dist\solrj-lib" directory, if you can't find all jar. You can download from the link.

Open the Java Client, add the below code.

private static void printProduct(Product product) throws MalformedURLException, SolrServerException, IOException {
        //Ip address is hard corded, where the Solr server is installed
        SolrServer server = new CommonsHttpSolrServer("http://10.177.252.178:8080/solr");
        SolrInputDocument doc = new SolrInputDocument();
        doc.addField("id", product.getId());
        doc.addField("title", product.getTitle());
        doc.addField("category", product.getCategoryRef().getName());
        doc.addField("productby", product.getProductBy());
        doc.addField("price", product.getPrice());
        doc.addField("description", product.getDescription());
        String features = product.getFeatures().replaceAll(";", " ");
        doc.addField("features", features);
        System.out.println("Content Indexing Started for Id " + product.getId());
        server.add(doc);
        server.commit();
        System.out.println("Content Indexing Completed for Id " + product.getId());
    }

Run the java client, all the records will get indexed into solr server. Now we can see on Solr admin homepage for collection1 schema 40 doc are added.

Oracle ADF Essentials - Faster and Simpler Java-based Application Development - Now Free

noreply@blogger.com (Deepak Siddappa) — Wed, 26 Sep 2012 06:26:00 +0000

Oracle ADF Essentials is an end-to-end Java EE framework that simplifies application development by providing out-of-the-box infrastructure services and a visual and declarative development experience. Oracle ADF Essentials is free to develop and deploy.

More detail go through the link.

Deploy BC4J/EJB application to GlassFish Server

noreply@blogger.com (Deepak Siddappa) — Thu, 20 Sep 2012 14:02:00 +0000

Now deploying the ADF Faces application to the Glassfish server has become easy, users can directly deploy the application from JDeveloper itself. Deploying the ADF Faces application to the Glassfish server directly runs with Oracle JDeveloper 11.1.2.3.0 onwards.

Note:- If application has model part then first configure JNDI DataSource, In my previous article I have explained how to "Configure JNDI DataSource for OracleDB in GlassFish Server".

Implementation Steps for BC4J Application:-

Create a fusion web application.
Goto the ViewController project, right click and select project properties. In Project properties wizard select Deployment and edit the WAR deployment profile.
In Platform selection choose Default Platform as "Glassfish 3.1".
Next go to Application, right click and select project properties. In Project properties wizard select Deployment and edit the EAR deployment profile and in Platform selection choose Default Platform as "Glassfish 3.1".
Open AppModule.xml file and select Configurations tab.
Edit AppModuleLocal and modify the DataSource Name from "java:comp/env/jdbc/OracleDS" to "jdbc/OracleDS"
Create Application Server Connection to Glassfish server.
Select application, deploy the EAR file directly to the Glassfish server.

Note: - Above Default Platform determines the platform-specific behavior when packaging the archive for deployment to an Application Server.

Implementation Steps for EJB/JPA Application:-

Create a fusion web application.
Goto the Model project, right click and select project properties. In Project properties wizard select Deployment and edit the JAR deployment profile and in Platform selection choose Default Platform as "Glassfish 3.1".
Goto the ViewController project, right click and select project properties. In Project properties wizard select Deployment and edit the WAR deployment profile and in Platform selection choose Default Platform as "Glassfish 3.1".
Next go to Application, right click and select project properties. In Project properties wizard select Deployment and edit the EAR deployment profile and in Platform selection choose Default Platform as "Glassfish 3.1".
Open persistence.xml file and select Model->Persistence Unit->Connection tab.
In General selection, in JTA DataSource modify "java:/app/jdbc/jdbc/OracleDS" to "jdbc/OracleDS"
In JTA Properties selection, in JTA DataSource Property modify "java:/app/jdbc/jdbc/OracleDS" to "jdbc/OracleDS"
Application like EJB which requires jndi lookup's, we have to change the initial context factory class name. Open the DataControls.dcx file, In ejb-definition tag modify the initial-context-factory class name from "weblogic.jndi.WLInitialContextFactory" to "com.sun.enterprise.naming.SerialInitContextFactory"
Create Application Server Connection to Glassfish server.
Select application, deploy the EAR file directly to the Glassfish server.

EJB DataControl - JPA Single Table Inheritance

noreply@blogger.com (Deepak Siddappa) — Tue, 04 Sep 2012 09:39:00 +0000

JPA supports three types of inheritance, In this article will try "single table inheritance using EJB datacontrol". For more information on JPA inheritance go through the link.

In single table inheritance, a single table is used to store all of the instances of the entire inheritance hierarchy. The table will have a column for every attribute of every class in the hierarchy. A discriminator column is used to determine which class the particular row belongs to, each class in the hierarchy defines its own unique discriminator value.

Table Structure: -

Model Diagram:-

In the above example the discriminator column (SEX) is added to the table to distinguish between the Men and Women instances.

You can download the sample workspace from here
[Runs with Oracle JDeveloper 11.1.2.2.0 + HR Schema]
Note: - You can find the sql file in application JPASingleTableApp/etc/ folder

Implementation Steps:-

Lets create a Fusion Web Application with Entities based on Person, edit the Person.java entity and remove the menAttr, womenAttr attributes. Add the below annotation in Person entity.

@Table(name="PERSON")
@Inheritance(strategy=InheritanceType.SINGLE_TABLE)
@DiscriminatorColumn(name="SEX", discriminatorType=DiscriminatorType.STRING,length=1)

Create an entity Men by extending the Person and add the below code.

@Entity
@Table(name = "PERSON")
@DiscriminatorValue("M")
@NamedQueries( { @NamedQuery(name = "Men.findAll", query = "select o from Men o") })
public class Men extends Person implements Serializable {
    @Column(name = "MEN_ATTR")
    private String menAttr;

    public Men() {
    }

    public String getMenAttr() {
        return menAttr;
    }

    public void setMenAttr(String menAttr) {
        this.menAttr = menAttr;
    }
}

Create an entity Women by extending the Person and add the below code.

@Entity
@Table(name = "PERSON")
@DiscriminatorValue("W")
@NamedQueries( { @NamedQuery(name = "Women.findAll", query = "select o from Women o") })
public class Women extends Person implements Serializable {
    @Column(name = "WOMEN_ATTR")
    private String womenAttr;

    public Women() {
    }

    public String getWomenAttr() {
        return womenAttr;
    }

    public void setWomenAttr(String womenAttr) {
        this.womenAttr = womenAttr;
    }
}

Next create a Session Bean and data control for the Session Bean and in ViewController project create a jspx page and drop menFindAll, womenFindAll as separate Table->ADF Read only Table. Run the jspx page and web page will be displayed as shown in below image, table bound to menFindAll should display only men records and table bound to womenFindAll should display only women records.

Configure JNDI DataSource for OracleDB in GlassFish Server

noreply@blogger.com (Deepak Siddappa) — Thu, 30 Aug 2012 10:36:00 +0000

In this article will see how to "Configure JNDI DataSource for Oracle in GlassFish 3.2 Server".

Login to Glassfish admin console in browser window, Once its open, in the left-hand side panel under Resources, click on JDBC and then JDBC Connection Pools. In the right hand-side click on new button will open the "New JDBC Connection Pool" window, enter the details as shown in below image.

Note: To store, organize, and retrieve data, most applications use relational databases. Java EE applications access relational databases through the JDBC API. Before an application can access a database, it must get a connection. JDBC resources provide applications with a means to connect to a database.

Clicking on Next button will display as shown in below image.

In same "New JDBC Connection Pool" window, in Additional Property section add the properties details as shown in below image.

Click on ping to test if the pool is created successfully. If not successful, check all the properties again.

Now under Resources, click on JDBC and then JDBC Resources. In the right hand-side click on new button will open the "New JDBC Resource" window, enter the details as shown in below image.

How many rows Modified/Added in ADF Table

noreply@blogger.com (Deepak Siddappa) — Tue, 07 Aug 2012 14:12:00 +0000

I was reading through OTN Discussion Forums where I found one topic "How many rows were Modified/Added in ADF Table by the user". Jobinesh has written article on "Displaying Transaction Log When User Commits a Transaction" which explains how to get the entity status, above example overrides EntityImpl::doDML(int operation, TransactionEvent e) method to track the status of entities.

I was trying to get Modified/Added rows in EJB DataControl but above suggested solution can't be implemented, because application module in not supported in EJB. So in this article I'm trying to get the entity status in backing bean using BC4J, in my next article I will try to explain on how to achieve the same scenario using EJB.

Results page looks like below.

You can download the sample workspace from here
[Runs with Oracle JDeveloper 11.1.2.2.0 + HR Schema]

Implementation Steps:

Create Fusion Web Application with business components from tables based Employees table, open Employees.xml and select Java tab. Generate EmployeesImpl and add the below code in create method to generate sequence number for employee id using SequenceImpl class.

/**
 * Add attribute defaulting logic in this method.
 * @param attributeList list of attribute names/values to initialize the row
 */
protected void create(AttributeList attributeList) {
	super.create(attributeList);
	SequenceImpl seq = new SequenceImpl("EMPLOYEES_SEQ", getDBTransaction());
	Number seqNextval = seq.getSequenceNumber();
	setEmployeeId(seqNextval);
}

Open the EmployeesView and select Java tab, generate EmployeesViewImpl class.

In ViewController project, create index.jspx page and backingbean as "IndexBean" with scope as "ViewScope". Open the IndexBean and copy the below method code.

private RichTable empTable;
private List selectedEmpArray = new ArrayList();
private int modifiedRows = 0;
private int newRows = 0;

public IndexBean() {
}

public void setEmpTable(RichTable empTable) {
	this.empTable = empTable;
}

public RichTable getEmpTable() {
	return empTable;
}

public void setModifiedRows(int modifiedRows) {
	this.modifiedRows = modifiedRows;
}

public int getModifiedRows() {
	return modifiedRows;
}

public void setNewRows(int newRows) {
	this.newRows = newRows;
}

public int getNewRows() {
	return newRows;
}

/**
 * Get the selected rowKey
 * Add the rowKey to selectedEmpArray arrayList
 * @param selectionEvent
 */
public void empSelectionEvent(SelectionEvent selectionEvent) {
	RowKeySet empRKS = selectionEvent.getAddedSet();
	if (empRKS.size() > 0) {
		Iterator empRKSIterator = empRKS.iterator();
		while (empRKSIterator.hasNext()) {
			Key key = (Key)((List)empRKSIterator.next()).get(0);
                        //Add the key if not existed in selectedEmpArray
			if (!selectedEmpArray.contains(key)) {
				selectedEmpArray.add(key);
			}
		}
	}
}

public BindingContainer getBindings() {
	return BindingContext.getCurrent().getCurrentBindingsEntry();
}

/**
 * While loop the selectedEmpArray
 * Get the entity status for the rowKeys
 * @param actionEvent
 */
public void fetchModifiedRows(ActionEvent actionEvent) {
	if (selectedEmpArray.size() > 0) {
		//Resetting the row counts
		this.setModifiedRows(0);
		this.setNewRows(0);

		DCBindingContainer dcBindings = (DCBindingContainer)getBindings();
		DCIteratorBinding EmpsDCIterBinding = dcBindings.findIteratorBinding("EmployeesView1Iterator");
		RowSetIterator EmpsRSIter = EmpsDCIterBinding.getRowSetIterator();
		ViewObject vo = EmpsDCIterBinding.getViewObject();

		Iterator selectedEmpsIter = selectedEmpArray.iterator();
		while (selectedEmpsIter.hasNext()) {
			Row currentRow = EmpsRSIter.getRow((Key)selectedEmpsIter.next());
			EmpsRSIter.setCurrentRow(currentRow);

			ViewRowImpl myRow = (ViewRowImpl)vo.getCurrentRow();
			EntityImpl entityImpl = (EntityImpl)myRow.getEntity(0);
			if (EntityImpl.STATUS_MODIFIED == entityImpl.getEntityState()) {
				this.setModifiedRows((this.getModifiedRows() + 1));
			} else if (EntityImpl.STATUS_NEW == entityImpl.getEntityState()) {
				this.setNewRows((this.getNewRows() + 1));
			}
		}
	}
	//Commit the transaction
	commitAction();
}

public String commitAction() {
	BindingContainer bindings = getBindings();
	OperationBinding operationBinding = bindings.getOperationBinding("Commit");
	Object result = operationBinding.execute();
	if (!operationBinding.getErrors().isEmpty()) {
		return null;
	}
	return null;
}

/**
 * CreateInsert new row and get rowKey for the added row
 * Add the rowKey to the selectedEmpArray arrayList
 * @param actionEvent
 */
public void createNewRow(ActionEvent actionEvent) {
	BindingContainer bindings = getBindings();
	OperationBinding oper = bindings.getOperationBinding("CreateInsert");
	oper.execute();

	DCBindingContainer dcBindings = (DCBindingContainer)BindingContext.getCurrent().getCurrentBindingsEntry();
	DCIteratorBinding EmpsIter = dcBindings.findIteratorBinding("EmployeesView1Iterator");
	EmployeesViewImpl eImpl = (EmployeesViewImpl)EmpsIter.getViewObject();
        //Add the key if not existed in selectedEmpArray
	if (!selectedEmpArray.contains(eImpl.getCurrentRow().getKey())) {
		selectedEmpArray.add(eImpl.getCurrentRow().getKey());
	}
}

Note:- Here createInsert is model driven component, when user clicks on the Create button the selectionListener will not be executed for the first time. So in the above createNewRow method, the rowKey value will be added to selectedEmpArray.

Open index.jspx page.

From datacontrol palette drag and drop EmployeesView1->Table as ADF Table with rowSelection as multiple.
Surround the table with panel collection and add toolbar in that.
Bind the empolyees table as binding="#{viewScope.IndexBean.empTable}"
Set the SelectionListener as "#{viewScope.IndexBean.empSelectionEvent}"
Go to Bindings tab and Create Action Binding, Data Collection as EmployeesView1 and Operation as CreateInsert.
From component palette drop af:commandButton and set actionListener as "#{viewScope.IndexBean.createNewRow}".
Go to Bindings tab and Create Action Binding, Data Collection as AppModuleDataControl and Operation as Commit.
From component palette drop af:commandButton and set actionListener as #{viewScope.IndexBean.fetchModifiedRows}, disabled as "#{!bindings.Commit.enabled}", partialSubmit as "true".
Add af:outputLabel and value as "No of Rows Modified - #{viewScope.IndexBean.modifiedRows}", partialTriggers to commit button.
Add af:outputLabel and value as "No of Rows Newly added - #{viewScope.IndexBean.newRows}", partialTriggers to commit button.

Bean Data Control - Create Simple Search Form

noreply@blogger.com (Deepak Siddappa) — Thu, 12 Jul 2012 17:22:00 +0000

In Oracle ADF, search form can be created with BC4J/EJB model using "View Criteria/Named Criteria" by dropping "af:query" component in view layer. Here in this article, I'm trying to build simple search form based on bean data control.

The Results page look like below.

Enter the Department Id in search form and click search button will filter results.

You can download the sample workspace from here
[Runs with Oracle JDeveloper 11.1.2.0.0 (11g R2) + HR Schema]

Implementation Steps

Create Fusion Web application, in model project create Employees java class. Open Employees.java and add the below code.

public class Employees {
    private Integer employeeId;
    private String firstName;
    private String lastName;
    private String email;
    private String phoneNo;
    private Date hireDate;
    private String jobId;
    private Integer salary;
    private Integer departmentId;

    public Employees() {
        super();
    }

    public Employees(int employeeId, String firstName, String lastName, String email, String phoneNo, Date hireDate,
                     String jobId, int salary, int departmentId) {
        this.setEmployeeId(employeeId);
        this.setFirstName(firstName);
        this.setLastName(lastName);
        this.setEmail(email);
        this.setPhoneNo(phoneNo);
        this.setHireDate(hireDate);
        this.setJobId(jobId);
        this.setSalary(salary);
        this.setDepartmentId(departmentId);
    }

    public void setEmployeeId(Integer employeeId) {
        this.employeeId = employeeId;
    }

    public Integer getEmployeeId() {
        return employeeId;
    }

    public void setFirstName(String firstName) {
        this.firstName = firstName;
    }

    public String getFirstName() {
        return firstName;
    }

    public void setLastName(String lastName) {
        this.lastName = lastName;
    }

    public String getLastName() {
        return lastName;
    }

    public void setEmail(String email) {
        this.email = email;
    }

    public String getEmail() {
        return email;
    }

    public void setPhoneNo(String phoneNo) {
        this.phoneNo = phoneNo;
    }

    public String getPhoneNo() {
        return phoneNo;
    }

    public void setHireDate(Date hireDate) {
        this.hireDate = hireDate;
    }

    public Date getHireDate() {
        return hireDate;
    }

    public void setJobId(String jobId) {
        this.jobId = jobId;
    }

    public String getJobId() {
        return jobId;
    }

    public void setSalary(Integer salary) {
        this.salary = salary;
    }

    public Integer getSalary() {
        return salary;
    }

    public void setDepartmentId(Integer departmentId) {
        this.departmentId = departmentId;
    }

    public Integer getDepartmentId() {
        return departmentId;
    }
}

Create PopulateData java class, open PopulateData.java and add the below code.

public class PopulateData {
    private static List allEmployees;
    static {
        allEmployees = new ArrayList();
        allEmployees.add(new Employees(100, "Steven", "King", "SKING", "515.123.4567", new Date(), "AD_PRES", 24000,
                                       20));
        allEmployees.add(new Employees(101, "Neena ", "Kochhar", "NKOCHHAR", "515.123.4568", new Date(), "AD_VP",
                                       17000, 90));
        allEmployees.add(new Employees(102, "Lex", "De Haan", "AHUNOLD", "515.423.4567", new Date(), "IT_PROG", 15000,
                                       90));
        allEmployees.add(new Employees(103, "Alexander", "Hunold", "AHUNOLD", "515.423.4567", new Date(), "IT_PROG",
                                       10000, 20));
        allEmployees.add(new Employees(104, "Bruce", "Ernst", "BERNST", "515.423.4568", new Date(), "IT_PROG", 5000,
                                       50));
        allEmployees.add(new Employees(105, "David", "Austin", "DAUSTIN", "515.423.4569", new Date(), "IT_PROG", 7000,
                                       30));
        allEmployees.add(new Employees(106, "Valli", "Pataballa", "VPATABAL", "515.423.4560", new Date(), "IT_PROG",
                                       8000, 50));
        allEmployees.add(new Employees(107, "Diana", "Lorentz", "DLORENTZ", "515.423.5567", new Date(), "IT_PROG",
                                       9000, 50));
        allEmployees.add(new Employees(108, "Nancy", "Greenberg", "NGREENBE", "515.124.4569", new Date(), "FI_MGR",
                                       10000, 100));
        allEmployees.add(new Employees(109, "Daniel", "Faviet", "DFAVIET", "515.124.4169", new Date(), "FI_ACCOUNT",
                                       13000, 100));
        allEmployees.add(new Employees(110, "John", "Chen", "JCHEN", "515.124.4269", new Date(), "FI_ACCOUNT", 14000,
                                       100));
        allEmployees.add(new Employees(111, "Ismael", "Sciarra", "ISCIARRA", "515.124.4369 ", new Date(), "FI_ACCOUNT",
                                       12000, 60));
        allEmployees.add(new Employees(112, "Jose Manuel", "Urman", "JMURMAN", "515.124.4469", new Date(),
                                       "FI_ACCOUNT", 4000, 60));
        allEmployees.add(new Employees(112, "Jose Manuel", "Urman", "JMURMAN", "515.124.4469", new Date(),
                                       "FI_ACCOUNT", 7800, 60));
        allEmployees.add(new Employees(113, "Luis", "Popp", "LPOPP", "515.124.4567", new Date(), "FI_ACCOUNT", 6900,
                                       70));
        allEmployees.add(new Employees(114, "Den", "Raphaely", "DRAPHEAL", "515.127.4561", new Date(), "PU_MAN", 11000,
                                       90));
    }

    public PopulateData() {
        super();
    }

    public static List getAllEmployees() {
        return allEmployees;
    }
}

Create EmployeeServicejava class, open EmployeeService.java and add the below code. Create data control from EmployeeService Bean class.

public List filterByDeptId(Integer departmentId) {
        try {
            List allEmployees = PopulateData.getAllEmployees();
            if (departmentId != null) {
                List filteredEmployees = new ArrayList();
                for (Employees e : allEmployees) {
                    if (e.getDepartmentId() == departmentId) {
                        filteredEmployees.add(e);
                    }
                }
                return filteredEmployees;
            } else {
                return allEmployees;
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
        return null;
}

public List getAllEmployees() {
    return PopulateData.getAllEmployees();
}

In ViewController project, create jspx page and from data control palette

Drop filterByDeptId as ADF Method Parameter
Drop filterByDeptId->Employees->Table as ADF Read-only Table

How to add a new row at the end of the ADF Table

noreply@blogger.com (Deepak Siddappa) — Mon, 02 Jul 2012 13:48:00 +0000

I was reading through OTN Discussion Forums where I found one topic "How to add a new row at the end of the ADF Table", I found couple of articles which explains how to insert new rows to the end of ADF Table. Here is the list below.

Here is one more way to insert new rows to the end of ADF table by overriding the view object's(ViewImpl) insertRow() method.

/**
 * This method will overrides the view object's insertRow()
 * First create a new row
 * Removes the row from the collection and then retain it for insertion into another location.
 * Navigates to the last row in the row set.
 * Navigates to next row
 * Inserts the same row to the row set
 * @param row
 */
@Override
public void insertRow(Row row) {
 super.insertRow(row);
 row.removeAndRetain();
 last();
 next();
 getDefaultRowSet().insertRow(row);
}

You can download the sample workspace from here
[Runs with Oracle JDeveloper 11.1.2.0.0 (11g R2) + HR Schema]

Run the index.jspx page and navigate the departments records, now click on Create button. Notice in employee table new row is added to end of the ADF Table.

Get JPA Entity Attributes programmatically in managed bean

noreply@blogger.com (Deepak Siddappa) — Tue, 26 Jun 2012 06:26:00 +0000

Sometimes it is necessary to get database table field column names for further functional process in applications. In one my previous article I have explained one of the use case - Configure Comparison of Row Objects at Run Time, here application module(BC4J) is used to access the ViewObject attributes.

In EJB data control doesn't create any application module or neither have access to application module Api's directly. When the ViewObject is accessed based on the Iterator a dummy object is created using DCDataVo Api. DCDataVo provides little leverage to access certain model layer functionality, so that all Adapter Data Control can use the DCDataVo api to extend to build custom features.

You can download the sample workspace from here
[Runs with Oracle JDeveloper 11.1.2.0.0 (11g R2) + HR Schema]

Here in the below code JPA entity attributes are accessed in managed bean using DCDataVo api.

/**
 * This method will get the View Object based on Iterator
 * Reads the entity attributes(column names)
 * @param actionEvent
 */
public void compareAttributes(ActionEvent actionEvent) {
 DCBindingContainer dcBindings = (DCBindingContainer)BindingContext.getCurrent().getCurrentBindingsEntry();
 DCIteratorBinding deptIter = dcBindings.findIteratorBinding("employeesFindAllIterator");
 ViewObject vo = deptIter.getViewObject();
 int count = 0;
 AttributeDef[] attrDefs = vo.getAttributeDefs();
 for (AttributeDef attrDef : attrDefs) {
  byte attrKind = attrDefs[count].getAttributeKind();
  //Condition to exclude the fk attributes
  if (attrKind == 1) {
   System.out.println(attrDef.getName());
   count++;
  }
 }
}

Displaying the Employee entity attributes.