Skip Headers
Oracle® Fusion Middleware Desktop Integration Developer's Guide for Oracle Application Development Framework
11g Release 1 (11.1.1.7.0)

Part Number E10139-06
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

2 Introduction to the ADF Desktop Integration Sample Application

This chapter provides an overview of the Summit sample application for ADF Desktop Integration. The Summit sample application for ADF Desktop Integration contains several Microsoft Excel workbooks that are integrated with the demo's Fusion web application.

This chapter includes the following sections:

2.1 Introduction to Summit Sample Application for ADF Desktop Integration

The Summit sample application for ADF Desktop Integration is a set of sample demonstrations that illustrate the main capabilities from ADF Desktop Integration. Each of the samples contain specific features that can also be identified on the developer's guide. All of the samples use the same underlying database schema which makes it very easy for accessing the source code, and also to experience the runtime behavior in a standalone way.

Set up the development environment before you set up and run the Summit sample application for ADF Desktop Integration. After setting up the development environment, you can download the sample application.

2.2 Setting Up and Executing the Summit Sample Application for ADF Desktop Integration

Set up the development environment as described in Chapter 3, "Setting Up Your Development Environment", so that you can run the Summit sample application for ADF Desktop Integration.

After you have set up the development environment, download the Summit sample application for ADF Desktop Integration from OTN. For more information, see the instructions at http://www.oracle.com/technetwork/developer-tools/jdev/index-098948.html.

Note:

If you have an old version of ADF Desktop Integration installed on the system, upgrade ADF Desktop Integration as described in Section 3.6, "Upgrading ADF Desktop Integration."

To run the Summit sample application for ADF Desktop Integration:

  1. Open the SummitADFdi.jws file in JDeveloper.

    This file is located in the Summit_ADFDI directory.

  2. In the Application Navigator, click and expand the Model project.

  3. Open Model.jpx file in the Model > Application Sources > oracle.summitdi.model.

  4. Expand the Connection group in the General tab, and click the Add icon to create a database connection.

  5. In the Create Database Connection dialog, add the following connection information shown in Table 2-1 for your environment.

    Table 2-1 Database Connection Properties for the Summit Sample Application for ADF Desktop Integration

    Property Description

    Username

    summit_adf

    Password

    summit_adf

    Host Name

    The host name for your database. For example:

    localhost

    JDBC Port

    The port for your database. For example:

    1521

    SID

    The SID of your database. For example:

    ORCL or XE


    Click Test Connection to verify the connection, and then click OK to close the dialog.

  6. Save the Model.jpx file.

  7. Right-click Model and choose Rebuild Model.jpr.

  8. Open the DataControls.dcx file in the SamplesFeed project > Application Sources > oracle.summit.

  9. In the Source tab, edit the SchemaLocation attribute of the Definition element, and enter the location of the samplesFeed.xsd file as its value.

    By default, the file is located in the <Summit_HOME>/SamplesFeed/src/schema/ directory, where Summit_HOME is the root directory that stores the source files for the Summit sample application for ADF Desktop Integration.

    For example:

    <Source>
      <Definition xmlns="http://xmlns.oracle.com/adfm/adapter/url/xml"
        ConnectionName="SamplesFeed" Source=""
        SchemaLocation="file:/D:/Oracle/Applications/Summit_
                        ADFdi/SamplesFeed/src/schema/samplesFeed.xsd"
        RootElement="feed"/>
    </Source>
    
  10. In the Application Resources pane, select the SamplesFeed URL connection from Connections > URL.

  11. Right-click SamplesFeed, and select Properties.

  12. In the Edit URL Connection dialog, edit the value of URL Endpoint and enter the location of the ListOfSamples.xml file.

    By default, the file is located in the <Summit_HOME>/SamplesFeed/src/xml/ directory, where Summit_HOME is the root directory that stores the source files for the Summit sample application for ADF Desktop Integration.

  13. Click Test Connection to verify the connection, and then click OK to close the dialog.

  14. Expand the ViewController project and choose Web content > index.jspx.

  15. Right-click index.jspx and choose Run.

2.3 Overview of the Fusion Web Application in the Summit Sample Application for ADF Desktop Integration

The Fusion web application in the Summit sample application for ADF Desktop Integration enables end users to download the integrated Excel workbooks.

2.3.1 Log on to the Fusion Web Application in the Summit Sample Application for ADF Desktop Integration

When the end user runs the Summit sample application for ADF Desktop Integration in JDeveloper, the default browser opens the sample application home page.

Figure 2-1 Home page of Summit Sample Application for ADF Desktop Integration

Fusion Web Application login page

2.3.2 Downloading Integrated Excel Workbooks

The Summit sample application for ADF Desktop Integration provides various integrated Excel workbooks to meet different requirements. End users can navigate and download different workbooks using the slider control, or from the Available Demos dropdown list.

Table 2-2 lists the menu options and the downloaded integrated Excel workbooks.

Table 2-2 Integrated Excel Workbooks of Summit sample application for ADF Desktop Integration

Menu Option Description

Editable Table Sample

Downloads EditCusotmers.xlsx workbook.

Navigation Form Sample

Downloads EditWarehouses.xlsx workbook.

Editable Table with Web Picker

Downloads EditableCusotmerSearch.xlsx workbook.

Form and Table Quick Location Change

Downloads WarehouseLocations.xlsx workbook.


2.4 Overview of the Integrated Excel Workbooks in the Summit Sample Application for ADF Desktop Integration

The Summit sample application for ADF Desktop Integration provides the EditCustomers.xlsx, EditWarehouses.xlsx, EditCustomerSearch.xlsx, and WarehouseLocations.xlsx integrated Excel workbooks.

The EditCustomers.xlsx workbook enable end users to:

The EditWarehouses.xlsx workbook enable end users to:

The EditCustomerSearch.xlsx workbook enable end users to:

The WarehouseLocations.xlsx workbook enable end users to:

Subsequent sections in this chapter provide more information about the functionality in the workbooks along with cross-references to implementation details.

2.4.1 Log on to the Fusion Web Application from an Integrated Excel Workbook

At runtime, the integrated Excel workbooks in the Summit sample application for ADF Desktop Integration render an Excel ribbon tab that allows end users to log on to the Fusion web application. Figure 2-2 shows the runtime Warehouses tab in the Ribbon of the EditWarehouses.xlsx workbook.

Figure 2-2 Runtime Warehouses Tab

Runtime Warehouses tab

2.4.2 Downloading Data Rows

Some workbooks, such as EditCustomers.xlsx workbook, use an ADF Table component to host information downloaded from the Fusion web application. This component allows end users to edit rows and upload modified rows to the Fusion web application.

The following sections provide information about how to implement the download functionality:

2.4.3 Modify Customers and Warehouses Information in the Workbooks

The EditCustomers.xlsx and EditWarehouses.xlsx workbooks enable end users to edit customers and warehouses information that the ADF Table component and form components downloads from the Fusion web application. Columns in the runtime ADF Table component that have an UpdateComponent property configured permit end users to modify values and upload the changes to the Fusion web application. For example, end users can modify the values that appear in the Name, Phone, and Address columns in EditCustomers.xlsx.

Other columns, such as Status and Changed, appear in the ADF Table component to provide status information about upload operations and changed columns.

The following sections provide information about how to implement this functionality:

2.4.4 Upload Modified Information to the Fusion Web Application

The integrated workbooks allow end users to upload modified data in the ADF Table component to the Fusion web application. An action set is configured for the runtime Upload button that invokes the ADF Table component's Upload action. For information about implementing this functionality, see Section 7.8, "Configuring an ADF Component to Upload Changes from an ADF Table Component."