15 Oracle JCA Adapter for JDE Edwards World

Learn how to use the Oracle JCA Adapter for JDE Edwards World, and provides both design time and runtime configuration information, along with a brief conceptual overview.The JDE World System is an ERP (Enterprise Resource Planning) product running on IBM minicomputers. The JD Edwards World Adapter uses a new JDBC-driver based connection to the IBM system and enables SOA integration users to interact with JDE World system as a typical database.

For complete information on the JD Edwards World System, see the Oracle JD Edwards World documentation page.

15.1 JD Edwards World System and JDE Edwards World Adapter Concepts

J.D. Edwards World System enables integration with Enterprise systems through its interoperability framework. The Oracle JD Edwards World Adapter uses the Adapter framework and leverages various integration access methods to provide the greatest amount of flexibility and functionality.

JDE Edwards World System is a database-based integration: the J.D.Edwards application is intrinsically a database. Its reports and any information extraction from it are based on SQL queries. Similarly, write interactions with JDE Edwards World System are based on inserts into special tables. The special tables are called z-tables and are used to temporarily store data that you have imported from an external source (a flat file, spreadsheet, or another type of file). The JD Edwards World System processes this data and imports it into real database tables. The Z-tables help to ensure that the format and process of importing data are as consistent as possible.

Z-files contain all the information needed to process a transaction in the JD Edwards System and there is an associated batch processing program for each Z-file.

Z-files correspond to different types of transactions, such as sales orders and addresses. The JD Edwards World System documentation documents these different types of files and their use within the JD Edwards World System.

The JD Edwards World Adapter exposes the underlying JD Edwards World System database tables through the filter of an integration by doing the following:

  • Exposing only integration points, that is, alternative descriptive names of tables/columns. The JD Edwards World Adapter does not expose the "real" names of the JD Edwards World tables.

  • Providing a powerful UI that enables you to find the correct integration touch points

  • Providing a JDBC driver which ensures that only certain trusted callers are allowed to insert data into a limited set of tables.

The information in the JD Edwards World system is in tables in a format unusable to a Database Adapter. Numbers are stored without the decimal place, dates are in a certain format, and connections must be made with "translate binary=true" (AS/400 DB2 specific).

For the purposes of the JD Edwards World Adapter, these formats are handled by the JD Edwards World JDBC driver, which also handles most of the typical runtime Adapter functions such as environment setup and data translation. Thus, the JDBC driver provides a means of communication between the JD Edwards World Adapter and the JD Edwards World system Z-tables.

15.2 JD Edwards World Adapter Features

The JD Edwards World Adapter Features includes the following.

  • JDE World Create Connection Template. Through the Configuration Wizard, the Adapter provides the use of connection templates to assist in connecting to the JD Edwards World System.

  • JDE World Custom Connection Parameters. Through the Configuration Wizard, the JD Edwards World Adapter provides the use of connection parameters specific to JDE World System.

  • Operation determined by table selected. The JD Edwards World Adapter enables the user to choose an operation that is determined by the table that is selected.

  • Select Table Browser. This functionality enables you to browse JD Edwards World Z-tables, as an aide and prerequisite to your using the JD Edwards Adapter to perform a Select against the Z-tables.

  • JD Edwards World System Z-tables grouped by business module. To assist you in determining which tables you want to perform inserts and selects against, the JD Edwards World Adapter provides JD Edwards World System business module groupings of Z-tables. These business modules have descriptive names that are clearly indicative of their use in the Enterprise.

  • The JD Edwards World Adapter exposes only those Z-tables that are to be used as integrations endpoints. It does not expose Z-tables that are not integration endpoints.

  • The JD Edwards World Adapter provides connection pooling support.

  • Z-table Insert Support. Inserts to JD Edwards World System Z-tables require that the SQL connections obtained by the JDE World JCA adapter have permission to execute insert statements.

    Again, the Z-tables against which the JD World System Adapter provides you the ability to perform operations are staging tables: that is, they are data interfaces to import/export data to and from J D Edwards. External Applications always interface with the Z-tables from where you can move data into real JDEdwards World System tables using batch programming and other interfaces on the back-end JD Edwards World System.Different transactions in different functional areas have their own defined Z-tables and configurations to move them into real JD Edwards World tables. Refer to each of the vertical (Financial, Manufacturing, Human Resources) sets of JD Edwards World documentation, where you can find information about processing options that enable you to move data from their respective Z-tables.

  • No Polling Support. There is no polling support for the JD Edwards World Adapter.

  • No Transaction Support. Though many adapters generally support XA transactions, the JDEdwards World Adapter does not. This is partly because JDE World systems are non-transactional. Journalling is typically not enabled on the AS/400 DB2 database underlying the JD Edwards World System, meaning that not only are XA transactions not possible, but starting and committing a local transaction is also not supported.

    Also, there are only two database options available within the JD Edwards World Adapter: select and insert. Select does not need to be transactional. Insert is also to a Z-table only, and is always associated with a non-transactional RPG call.

15.3 Configuring the JD Edwards World Adapter

There are several preparatory configuration steps involved with the JD Edwards World Adapter. Prior to deploying the Adapter, you must provide both runtime and designtime configuration.

15.3.1 Configuring Connection Pooling for the JDEdwards World Adapter

A JCA connector must provide pooling support. With the Database Adapter, SQL connections are obtained from a Data source. In this way, pooling requirements are delegated to the underlying JDBC driver and its DataSource implementation.

Because the JD Edwards World JCA Adapter is based on the Oracle Database Adapter, the process for configuring pooling support for the JD Edwards World Adapter is similar to that of providing pooling support for the Oracle Database Adapter.

To provide connection pooling for the JD Edwards World Adapter:

  1. Ensure that the Oracle WebLogic Server is installed on a build which contains the JD Edwards World Adapter. Next, search for and find the JD Edwards World Adapter on the Search Panel on the WebLogic Console.

    Enter the name of the Adapter in the Search field. The Search Panel displays the search results, JDEdwards World Adapter, with its type AppDeployment, See Figure 15-1.

    Figure 15-1 Searching for the JDEdwards World Adapter on the WebLogic Console

    Description of Figure 15-1 follows
    Description of "Figure 15-1 Searching for the JDEdwards World Adapter on the WebLogic Console"
  2. The JDEdwards World Adapter is an optional Adapter, thus its initial JDeveloper state is Installed, not Active. You must make the JDEdwards World Adapter state active. To make the state Active:

    1. Select the Targets tab on the WebLogic Console

    2. Select the Servers to which to deploy the Adapter. Click Save.

      Figure 15-2 Selecting a Server on the WebLogic Console

      Description of Figure 15-2 follows
      Description of "Figure 15-2 Selecting a Server on the WebLogic Console"
  3. You must obtain the jt400.jar file from Sourceforge (the jt400.jar file is called JTOpen 7.9 at that location.) JTOpen is the open source version of the IBM Toolbox for Java Licensed Program Product (LPP).

    Place the jt400.jar file under <middleware_home>/user_projects/domains/WLS_SOA/lib/

  4. To verify that the Adapter is active, select the Control tab. You might need to manually activate it. To do so, select the checkbox next to JDBCWorldAdapter and choose Start.

    Figure 15-3 Verifying the JD Edwards World Adapter is in Active Status

    Description of Figure 15-3 follows
    Description of "Figure 15-3 Verifying the JD Edwards World Adapter is in Active Status"
  5. The next step is to create a data source connection by proceeding to Data Sources -->Services on the WebLogic Console and selecting Generic Data Source:

    Figure 15-4 Choosing a Generic Data Source

    Description of Figure 15-4 follows
    Description of "Figure 15-4 Choosing a Generic Data Source"
  6. Supply the name jdbc/JDEWorldDataSource. This represents the term to which the default JCA eis/JDEWorld/JDEWorldDemo instance is referring. Use database type Other.

    Figure 15-5 Defining the JDBC Data Source JDEWorldDataSource

    Description of Figure 15-5 follows
    Description of "Figure 15-5 Defining the JDBC Data Source JDEWorldDataSource"
  7. Within the Transactions tab, disable XA by ensuring that Supports Global Transactions is not selected. See Figure 15-6.

    Figure 15-6 Ensuring Supports Global Transactions is Not Selected on the WebLogic Transactions Tab

    Description of Figure 15-6 follows
    Description of "Figure 15-6 Ensuring Supports Global Transactions is Not Selected on the WebLogic Transactions Tab"
  8. Proceed to the Connection Pool page to configure the Connection Pool information. See Figure 15-7.

    The Connection Pool URL should resemble the following. Be sure to also specify three settings (User, ServerName, and JDEWEnvironment) as properties on the Connection Pool page, even though all three appear either in the connection URL already or were entered when you configured the data source:

    jdbc:jdew://JDED;JDEWEnvironment=QA92;JDEWTableNomenclature=OBJN_OBJT;JDEWColumnNomenclature=FDFT_FDFN;translate binary=true;date format=mdy;prompt=false;auto commit=true;
    
    user=BPELTEST
    serverName=JDED2.us.mydomain.com
    JDEWEnvironment=A93BPELTEST
    JDEWTableNomenclature=OBJN_OBJT
    JDEWColumnNomenclature=FDFT_FDFN

    Figure 15-7 Configuring the Connection Pool URL on the WebLogic Console

    Description of Figure 15-7 follows
    Description of "Figure 15-7 Configuring the Connection Pool URL on the WebLogic Console"
  9. Select Advanced and set Connection Reserved Timeout to 180. This value is required because creating a connection can take three minutes the first time the Adapter connects using the Connection Pool.

    Figure 15-8 Setting the Connection Reserved Timeout Value

    Description of Figure 15-8 follows
    Description of "Figure 15-8 Setting the Connection Reserved Timeout Value"
  10. Next, select the Control tab to manually control each instance of the JDBC Data Source.

    Figure 15-9 Using the Control Tab to Manually Manage Each Instance of the Deployed Data Source

    Description of Figure 15-9 follows
    Description of "Figure 15-9 Using the Control Tab to Manually Manage Each Instance of the Deployed Data Source"

15.4 JD Edwards Word Adapter Configuration Wizard Flow: Insert Operation

You can use the JD Edwards Adapter Configuration Wizard to configure the JD Edwards Adapter to perform an insert operation to the JDEdwards World Z-tables.

  1. Launch the JDE World Adapter Configuration Wizard by dragging and dropping it onto a composite or BPEL process in the Reference section of the JDeveloper design view. The JD Edwards World Adapter Configuration Wizard Welcome Screen appears.
  2. Use the Service Connection screen to establish a service connection. Edit an existing connection by browsing to that connection or supply new connection information on this page. Click Next.
  3. The JDEWorld Adapter Configuration Wizard Select Table screen is displayed. This screen enables you to select either one of two operations you can perform against JD Edwards World z-tables: Z-table Insert or Select. In this example, Z-table Insert has been selected. Click Next.

    Figure 15-10 JDE World Adapter Configuration Wizard Select Table Screen

    Description of Figure 15-10 follows
    Description of "Figure 15-10 JDE World Adapter Configuration Wizard Select Table Screen"
  4. The Service Connection page opens, enabling you to select the root database for this service's query.

    To do this, you must have a basic understanding of the Z-Tables against which you want to perform the operation and the root database table. It also helps to understand the JD Edwards World System business module against which you are performing insertions or making queries.

    This page enables you to import Z-tables by clicking the Import Tables button at the bottom of the page. When you select a Z-Table from this list, you are selecting a table that is the root database for the operation.You can also remove Z-tables you have added.

    To do so:

    • Select the Import Tables button to import Z-tables, and select the table you want as the root database table, or

    • After importing, you can remove tables. To remove a table from the list, select the appropriate tables, then select the Remove Tables button to remove Z-Tables from the list of ones you want imported.

    • Select Next.

    Figure 15-11 Selecting the Root Database Table

    Description of Figure 15-11 follows
    Description of "Figure 15-11 Selecting the Root Database Table"
  5. The JD Edwards World Adapter Configuration Wizard displays the Relationships screen.This screen provides a list of relationships that are available from the root database.

    You can define new relationships by clicking the Create button, which is shown at the bottom of the screen and enables you to provide a table that can be reachable from the root database. Next to the Create button is the Remove button, which enables you to remove a table from being reachable from the root database table.

    You can also rename a relationship table by clicking it in rename it. You can also just move to the next screen.

    After you have optionally completed creation or removal, or not performed either of these, as in the example, select Next.

    Figure 15-12 The JDEWorld Adapter Configuration Wizard Relationships Screen

    Description of Figure 15-12 follows
    Description of "Figure 15-12 The JDEWorld Adapter Configuration Wizard Relationships Screen"
  6. The JDEWorld Adapter Configuration Wizard Attribute Filtering Screen appears. This shows the attribute filter that is created from the imported table definitions, including any relationships that you may have defined.

    You can also uncheck any attributes you want to exclude from the database queries you perform. Note that you cannot exclude primary key attributes. Select Select All to select all attributes or Deselect All to deselect all attributes.

    Select Next.

    Figure 15-13 The JDEWorld Adapter Configuration Wizard Attribute Filtering Screen

    Description of Figure 15-13 follows
    Description of "Figure 15-13 The JDEWorld Adapter Configuration Wizard Attribute Filtering Screen"
  7. The JDE World Adapter Configuration Wizard Advanced Options Screen appears. On this page, the JDBC Options Query Timeout option is provided. You can either change this value from its default, 0, or select Next to accept the default value.

    Figure 15-14 The JDE World Adapter Configuration Wizard Advanced Options Screen

    Description of Figure 15-14 follows
    Description of "Figure 15-14 The JDE World Adapter Configuration Wizard Advanced Options Screen"
  8. The JDE World Adapter Configuration Wizard JCA Endpoint Properties Screen appears.

    In the Auto-Retries section, specify the value for auto-retry in case of an operation time out. This value is used if there is a connection-related fault, and the Invoke activity can be automatically retried a limited number of times. You can specify the following values in the fields in this section:

    • To retry indefinitely, type unlimited in the Attempts field.

    • Interval is the delay between retries.

    • Backoff Factor: x enables you to wait for increasing periods of time between retries. 9 attempts with a starting interval of 1 and a back off of 2 leads to retries after 1, 2, 4, 8, 16, 32, 64, 128, and 256 (28) seconds.

    • Max Interval is the number of intervals of delays between retries.

    Figure 15-15 JDE World Adapter Configuration Wizard JCA Endpoint Properties

    Description of Figure 15-15 follows
    Description of "Figure 15-15 JDE World Adapter Configuration Wizard JCA Endpoint Properties"

15.5 JD Edwards World Adapter: Select Operation

The JDEWorld Adapter provides the ability to perform a select, or query from a JD Edwards World Z-table. You can configure this operation using the JD Edwards World Adapter Configuration Wizard.

  1. On the Select Table screen, choose the Select Operation Type, and select Next.

    Figure 15-16 JD Edwards World Adapter Select Table Screen

    Description of Figure 15-16 follows
    Description of "Figure 15-16 JD Edwards World Adapter Select Table Screen"

    Here, Select has been chosen.

    Figure 15-17 JDE World Adapter Configuration Wizard with Select Operation Chosen

    Description of Figure 15-17 follows
    Description of "Figure 15-17 JDE World Adapter Configuration Wizard with Select Operation Chosen"
  2. The Service Connection page opens, enabling you to select the root database for this service's query. To do this, you must have a basic understanding of the Z-Tables against which you want to perform the operation and the root database table. It also helps to understand the JD Edwards World System business module against which you are performing insertions or making queries.

    This page enables you to import Z-tables by selecting the Import Tables button at the bottom of the page. When you select a Z-Table from this list, you are selecting a table that is the root database for the operation.

    You can also remove Z-tables you have added. To do so:

    • Click the Import Tables button to import Z-tables, and select the table you want as the root database table, or

    • After importing tables, you can remove them. To remove a table from the list, select the appropriate tables, then select the Remove Tables button to remove Z-Tables from the list of ones you want imported.

    • Click Next.

    Figure 15-18 JDE World Adapter Configuration Wizard Service Connection Screen

    Description of Figure 15-18 follows
    Description of "Figure 15-18 JDE World Adapter Configuration Wizard Service Connection Screen"
  3. The JD Edwards World Adapter System Browser appears. Here you can browse for tables you want to import.

    Figure 15-19 The JDE World System Browser

    Description of Figure 15-19 follows
    Description of "Figure 15-19 The JDE World System Browser"
  4. Click on a system table to select a system table in the JDE World System Browser.

    Figure 15-20 Selecting a System Table in the JDE World System Browser

    Description of Figure 15-20 follows
    Description of "Figure 15-20 Selecting a System Table in the JDE World System Browser"
  5. Once you have selected a system table, you can expand the table's node in the display and search for columns within tables. Click OK to select what you have chosen for importing.

    Figure 15-21 Using the JDE World System Browser to Display Column and Type Information

    Description of Figure 15-21 follows
    Description of "Figure 15-21 Using the JDE World System Browser to Display Column and Type Information"
  6. Once you have selected root database tables for importing, the Service Connection screen reappears, and asks you to choose a table for this service's querying. Select the root database table, and click Next to import it. You can also click the Remove Tables button to remove tables from your prospective Import list that you do not wish to import,

    Figure 15-22 JDE World Adapter Configuration Wizard Service Connection Screen with Tables Ready for Import

    Description of Figure 15-22 follows
    Description of "Figure 15-22 JDE World Adapter Configuration Wizard Service Connection Screen with Tables Ready for Import"
  7. The Define Primary Keys Screen appears if you must define a primary key. The screen gives you the opportunity to define a Primary Key. The Adapter must be able to uniquely identify a given row. As it states, the ROWID option is only configurable with Oracle databases, a single table, and polling, insert, and select operations only. The screen supplies additional information about defining primary keys. To use this screen, select a Primary Key candidate or candidates and click Next.

    Figure 15-23 The JDE Adapter Configuration Wizard Define Primary Keys Screen

    Description of Figure 15-23 follows
    Description of "Figure 15-23 The JDE Adapter Configuration Wizard Define Primary Keys Screen"
  8. If you selected a table and chose Import, the JDE Edwards World Adapter uses the table as the root table for your query operation and the JDE World Adapter Configuration Wizard Relationships screen appears.

    This screen shows the relationships that are reachable from the root database table you have indicated on the previous screen. If there are no reachable relationships between tables, the screen says "No reachable relationships."

    To use this screen:

    • Define a new relationship by selecting the Create button, or

    • Select Remove to remove a relationship.

    • To rename a relationship, select the relationship and click Rename.

    When you have finished defining, renaming or removing a relationship, or if you have no relationships to create or modify, select Next.

    Figure 15-24 The JDE World Adapter Configuration Wizard Relationships Screen

    Description of Figure 15-24 follows
    Description of "Figure 15-24 The JDE World Adapter Configuration Wizard Relationships Screen"
  9. The JD Edwards World Adapter Configuration Wizard Attribute Filtering screen appears. See Figure 15-25.

    You can use this screen to exclude any attributes from your database queries. To do so:

    • Uncheck any attributes you do not want to use in your queries.

    • Use the Select All button at the bottom of the screen to select all attributes.

    • Use the Deselect All button to deselect attributes.

    • Click Next.

    Figure 15-25 The JD Edwards World Adapter Configuration Wizard Attribute Filtering Screen

    Description of Figure 15-25 follows
    Description of "Figure 15-25 The JD Edwards World Adapter Configuration Wizard Attribute Filtering Screen"
  10. The JD Edwards World Adapter Configuration Wizard Define Selection Criteria Screen appears, where you can define the Selection Criteria for this JD Edwards World Adapter reference. See Figure 15-26
    • Enter the parameters in the field at the top and/or select the Add button to add additional SQL criteria.

      Figure 15-26 The JDE World Adapter Configuration Wizard Define Selection Criteria Screen

      Description of Figure 15-26 follows
      Description of "Figure 15-26 The JDE World Adapter Configuration Wizard Define Selection Criteria Screen"
    • Select Edit to use the SQL Expression Builder to create or modify the SQL Expression. See Figure 15-27 for an example of the screen.

      Figure 15-27 The Expression Builder

      Description of Figure 15-27 follows
      Description of "Figure 15-27 The Expression Builder "
    • To define your own custom Select SQL, modify the pre-generated SQL string in the Expression Builder, and click OK to use the modified SQL.

    • Back on the Define Selection Criteria Screen, select Use Outer Joins to return a Single Result Set for both Master and Detail Tables to use an advanced feature that influences how many total statements are used when querying against multiple related tables. The safest method is to use the default (1 per table), and this feature attempts 1 in total, by performing an outer join on all related tables into a single result set.

  11. The JD Edwards World Adapter Configuration Wizard Advanced Options screen appears. See Figure 15-28.

    On this screen, you can enter new values for either or both of the JDBC options provided, or select Next to accept the default values of 0.

    • Query Timeout - enables you to configure a timeout value on the Select operation.

    • Max Rows - the maximum number of rows to return from the Select operation.

    • Click Next when finished.

    Figure 15-28 The JDEdwards World Adapter Configuration Wizard Adapter Advanced Options Screen

    Description of Figure 15-28 follows
    Description of "Figure 15-28 The JDEdwards World Adapter Configuration Wizard Adapter Advanced Options Screen"
  12. The JDE World Adapter Configuration JCA Endpoint Properties Screen appears. See Figure 15-29. On this screen, you can specify Adapter framework-level properties.

    To use the recommended values, select Next. These properties include:

    • Attempts-The number of retries. This defaults to 4.

    • Interval(s)-The delay, or interval, between retries. This value defaults to 1.

    • Backoff factor:x- Enables you to wait for increasing periods of time between retries. For example, 9 attempts with a starting interval of 1 and a back off of 2 leads to retries after 1, 2, 4, 8, 16, 32, 64, 128, and 256 (28) seconds. This value defaults to 2.

    • Max Interval- The maximum interval for retries. This value defaults to 120 seconds.

    Figure 15-29 Oracle JDEdwards World Adapter Configuration Wizard JCA Endpoint Properties Screen

    Description of Figure 15-29 follows
    Description of "Figure 15-29 Oracle JDEdwards World Adapter Configuration Wizard JCA Endpoint Properties Screen"
  13. The JDEdwards World Adapter Finish Screen appears. You have finished defining the JD Edwards World Adapter.

15.5.1 Configuration Files

The WSDL and .jca configuration files for each of the example configured JD Edwards Adapters, using the Addressbook tables in this chapter, follow for your reference.

15.5.1.1 Insert Operation Example WSDL and .jca File

The following example shows the WSDL file for the Insert operation example.

Example - WSDL File for Insert Operation

<wsdl:definitions
     name="jdeworldReference"
     targetNamespace="http://xmlns.oracle.com/pcbpel/
         adapter/jdeworld/JDEW_selectAll/Insert/jdeworldReference"
     xmlns:jca="http://xmlns.oracle.com/pcbpel/wsdl/jca/"
     xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/"
     xmlns:tns="http://xmlns.oracle.com/pcbpel/adapter/jdeworld/JDEW_selectAll/Insert/jdeworldReference"
     xmlns:plt="http://schemas.xmlsoap.org/ws/2003/05/partner-link/"
     xmlns:top="http://xmlns.oracle.com/pcbpel/adapter/
               db/top/jdeworldReference"
    >
  <plt:partnerLinkType name="jdeworldReference_plt" >
    <plt:role name="jdeworldReference_role" >
      <plt:portType name="tns:jdeworldReference_ptt" />
    </plt:role>
  </plt:partnerLinkType>
    <wsdl:types>
      <schema xmlns="http://www.w3.org/2001/XMLSchema" >
        <import namespace="http://xmlns.oracle.com/pcbpel/
            adapter/db/top/jdeworldReference" schemaLocation="../Schemas/jdeworldReference_table.xsd" />
      </schema>
    </wsdl:types>
    <wsdl:message name="F01018Z____Address_Book_Email_URL_Z_FileCollection_msg">
        <wsdl:part name="F01018Z____Address_Book_Email_URL_Z_FileCollection" element="top:F01018Z____Address_Book_Email_URL_Z_FileCollection"/>
    </wsdl:message>
    <wsdl:portType name="jdeworldReference_ptt">
        <wsdl:operation name="zFileInsert">
            <wsdl:input message="tns:F01018Z____Address_Book_Email_URL_Z_FileCollection_msg"/>
        </wsdl:operation>
    </wsdl:portType>
</wsdl:definitions>

The following example shows the .jca file for the Insert operation example.

Example - .jca File for Sample Insert Operation

<adapter-config name="jdeworldReference" adapter="jdeworld" 
    wsdlLocation="../WSDLs/jdeworldReference.wsdl" 
       xmlns="http://platform.integration.oracle/blocks/
                adapter/fw/metadata">
  <connection-factory UIConnectionName="JDEWConnection1" 
location="eis/JDEWorld/JDEWConnection1"/>
  <endpoint-interaction portType="jdeworldReference_ptt" operation="zFileInsert">
    <interaction-spec className="oracle.tip.adapter.jdeworld.
JDEWorldZTableInteractionSpec">
      <property name="DescriptorName" 
value="jdeworldReference.F01018Z____Address_Book_Email_URL_Z_File"/>
      <property name="MappingsMetaDataURL" value="jdeworldReference-or-
mappings.xml"/>
    </interaction-spec>
  </endpoint-interaction>
</adapter-config>
15.5.1.2 Select Operation Example WSDL and .jca File

The following example shows the WSDL file for the sample Select operation example.

Example - WSDL File for Sample Select Operation

<wsdl:definitions
     name="jd"
     targetNamespace="http://xmlns.oracle.com/pcbpel/
          adapter/jdeworld/JDEW_selectAll/JDED_select1/jd"
     xmlns:jca="http://xmlns.oracle.com/pcbpel/wsdl/jca/"
     xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/"
     xmlns:tns="http://xmlns.oracle.com/
          pcbpel/adapter/jdeworld/JDEW_selectAll/JDED_select1/jd"
     xmlns:plt="http://schemas.xmlsoap.org/ws/2003/05/partner-link/"
     xmlns:top="http://xmlns.oracle.com/pcbpel/adapter/db/top/jd"
    >
  <plt:partnerLinkType name="jd_plt" >
    <plt:role name="jd_role" >
      <plt:portType name="tns:jd_ptt" />
    </plt:role>
  </plt:partnerLinkType>
    <wsdl:types>
      <schema xmlns="http://www.w3.org/2001/XMLSchema" >
        <import namespace=
         "http://xmlns.oracle.com/pcbpel/adapter/db/top/jd"          schemaLocation="../Schemas/jd_table.xsd" />
      </schema>
    </wsdl:types>
    <wsdl:message name="jdSelect_inputParameters">
        <wsdl:part name="jdSelect_inputParameters" element="top:jdSelectInputParameters"/>
    </wsdl:message>
    <wsdl:message name=
           "F0101______Address_Book_MasterCollection_msg">
        <wsdl:part name=
        "F0101______Address_Book_MasterCollection" element="top:F0101______Address_Book_MasterCollection"/>
    </wsdl:message>
    <wsdl:portType name="jd_ptt">
        <wsdl:operation name="jdSelect">
            <wsdl:input message="tns:jdSelect_inputParameters"/>
            <wsdl:output message=
            "tns:F0101______Address_Book_MasterCollection_msg"/>
        </wsdl:operation>
    </wsdl:portType>
</wsdl:definitions>

The following example shows the .jca file for the sample Select operation

Example - .jca File for Sample Select Operation

<adapter-config name="jd" adapter="jdeworld" 
           wsdlLocation="../WSDLs/jd.wsdl" xmlns="http://platform.integration.oracle/blocks/
                adapter/fw/metadata">
  <connection-factory UIConnectionName="JDEWConnection1" location="eis/JDEWorld/JDEWConnection1"/>
  <endpoint-interaction portType="jd_ptt" operation="jdSelect">
    <interaction-spec className="oracle.tip.adapter.jdeworld.JDEWorldReadInteractionSpec">
      <property name="DescriptorName"
           value="jd.F0101______Address_Book_Master"/>
      <property name="QueryName" value="jdSelect"/>
      <property name="MappingsMetaDataURL" 
            value="jd-or-mappings.xml"/>
      <property name="ReturnSingleResultSet" value="false"/>
    </interaction-spec>
  </endpoint-interaction>
</adapter-config>