Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

What's New in This Guide for Release 11.1.1.9

Part I Introduction and Concepts

1 Introduction to Oracle JCA Adapters

• 1.1 Features of Oracle JCA Adapters
• 1.2 Types of Oracle JCA Adapters
  • 1.2.1 Oracle Technology Adapters
    • 1.2.1.1 Architecture
    • 1.2.1.2 Design-Time Components
    • 1.2.1.3 Run-Time Components
    • 1.2.1.4 Deployment
  • 1.2.2 Legacy Adapters
    • 1.2.2.1 Architecture
    • 1.2.2.2 Design-Time Components
    • 1.2.2.3 Run-Time Components
    • 1.2.2.4 Deployment
  • 1.2.3 Packaged-Application Adapters
    • 1.2.3.1 Architecture
    • 1.2.3.2 Design-Time Components
    • 1.2.3.3 Run-Time Components
    • 1.2.3.4 Deployment
  • 1.2.4 Oracle Adapter for Oracle Applications
• 1.3 Types of Oracle JCA Adapters Adapter Services
  • 1.3.1 Request-Response (Outbound Interaction) Service
  • 1.3.2 Event Notification (Inbound Interaction) Service
  • 1.3.3 Metadata Service

2 ADAPTER Life-Cycle Management

• 2.1 Installing Oracle JCA Adapters
• 2.2 Starting and Stopping Oracle JCA Adapters
• 2.3 Defining Adapter Interface by Importing an Existing WSDL
  • 2.3.1 Adapter Configuration Wizard for Oracle MQ Series Adapter, Oracle JMS Adapter and the Oracle AQ Adapter
    • 2.3.1.1 Example of Use of Callbacks
• 2.4 Configuring Message Header Properties for Oracle JCA Adapters
• 2.5 Physically Deploying Oracle JCA Adapters
  • 2.5.1 The RAR Deployment Descriptor File and the weblogic-ra.xml Template File
• 2.6 Creating an Application Server Connection for Oracle JCA Adapters
• 2.7 Deploying Oracle JCA Adapter Applications from JDeveloper
  • 2.7.1 Deploying an Application Profile for the SOA Project and the Application
• 2.8 Manually Deploying an Adapter RAR File that Does Not Have a Jar File Associated With It
  • 2.8.1 Example of Manual Deployment
• 2.9 Handling the Deployment Plan When Working on a Remote Oracle SOA Server
• 2.10 Migrating Repositories from Different Environments
• 2.11 How Oracle JCA Adapters Ensure No Message Loss
  • 2.11.1 XA Transaction Support
  • 2.11.2 Local Transactions and Global (XA) Transactions
    • 2.11.2.1 Adapter Support of Local Transactions
    • 2.11.2.2 Adapter Support of Global Transactions
  • 2.11.3 Basic Concepts of Transactions and Adapters
    • 2.11.3.1 Asynchronous Transaction Flow
    • 2.11.3.2 Synchronous Transaction Flow
  • 2.11.4 Inbound Transactions
  • 2.11.5 Outbound Transactions
• 2.12 Composite Availability and Inbound Adapters
• 2.13 Singleton (Active/Passive) Inbound Endpoint Lifecycle Support Within Adapters
  • 2.13.1 Multiple Activations of the Same Adapter Endpoint
  • 2.13.2 Hot-Standby State
• 2.14 Correlation Support Within Adapters
  • 2.14.1 CorrelationID of Receive Message Not Matching Invoke: Log Error Message
    • 2.14.1.1 Rejecting Nonmatching Native Correlation IDs
• 2.15 Setting Payload Size Threshold
  • 2.15.1 Payload Native Size
    • 2.15.1.1 Setting the Payload Threshold
    • 2.15.1.2 Limitations on Payload Size Enforcement
• 2.16 Streaming Large Payload
• 2.17 Batching and Debatching Support
• 2.18 Adding an Adapter Connection Factory
  • 2.18.1 Creating a Data Source
  • 2.18.2 Creating a Connection Pool
• 2.19 Adding or Updating an Adapter Connection Factory
  • 2.19.1 Modify the JCA File
  • 2.19.2 Use a Config Plan
  • 2.19.3 Use the Web Logic Server Console to Create a New Connection
• 2.20 Recommended Setting for Data Sources Used by Oracle JCA Adapters
• 2.21 Error Handling
  • 2.21.1 Handling Rejected Messages
    • 2.21.1.1 Configuring Rejection Handlers
    • 2.21.1.2 Checking for Rejected Messages
  • 2.21.2 Inbound Interaction Error Handling
    • 2.21.2.1 Message Error Rejection Handlers
    • 2.21.2.2 Inbound Retryable Errors
    • 2.21.2.3 Inbound Non-Retryable Errors
  • 2.21.3 Outbound Adapter Interaction Error Handling
    • 2.21.3.1 Retryable Errors for Outbound Adapter Error Handling
    • 2.21.3.2 Non-Retryable Errors for Outbound Interaction Handling
• 2.22 Testing Applications
• 2.23 Setting the Trace Level of Oracle JCA Adapters
  • 2.23.1 How to Set the Trace Level of Oracle JCA Adapters
• 2.24 Viewing Adapter Logs
• 2.25 Adapter Diagnosability Dumps
• 2.26 Creating a Custom Adapter
  • 2.26.1 Configuring a Custom Adapter
    • 2.26.1.1 Custom Adapter Screen Flow
  • 2.26.2 Frequently Asked Questions about Adapters
    • 2.26.2.1 Why are My Applications Timing Out?
    • 2.26.2.2 How do Transactional and Non-Transactional Adapters Differ?
    • 2.26.2.3 What Happened to My Application's Rejected Messages? Can One Do Anything With Them?
• 2.27 Advanced Topic: Using the Execution Context ID Across Technologies
  • 2.27.1 Placing the ECid
  • 2.27.2 Configuring Composite Services/References
  • 2.27.3 Simple Database/File/JMS Example

3 Adapter Integration with Oracle Application Server Components

• 3.1 Adapter Integration with Oracle WebLogic Server
  • 3.1.1 Oracle WebLogic Server Overview
  • 3.1.2 Oracle WebLogic Server Integration with Adapters
    • 3.1.2.1 Design Time
    • 3.1.2.2 Run Time
• 3.2 Adapter Integration with Oracle Fusion Middleware
  • 3.2.1 Oracle BPEL Process Manager Overview
  • 3.2.2 Oracle Mediator Overview
  • 3.2.3 Oracle Fusion Middleware Integration with Adapters
    • 3.2.3.1 Design Time
    • 3.2.3.2 Run Time
    • 3.2.3.3 End-to-End Testing
    • 3.2.3.4 Oracle BPEL PM Integration with Outbound Interaction
    • 3.2.3.5 Oracle BPEL PM Integration with Inbound Interaction
    • 3.2.3.6 Use Case: Integration with Oracle BPEL Process Manager
  • 3.2.4 Oracle SOA Composite Integration with Adapters
    • 3.2.4.1 Oracle SOA Composite Overview
    • 3.2.4.2 Adapters Integration With Oracle SOA Composite
• 3.3 Monitoring Oracle JCA Adapters

4 Oracle JCA Adapter for Files/FTP

• 4.1 Introduction to Oracle File and FTP Adapters
  • 4.1.1 Oracle File and FTP Adapters Architecture
  • 4.1.2 Oracle File and FTP Adapters Integration with Oracle BPEL PM
  • 4.1.3 Oracle File and FTP Adapters Integration with Mediator
  • 4.1.4 Oracle File and FTP Adapters Integration with SOA Composite
• 4.2 Oracle File and FTP Adapters Features
  • 4.2.1 File Formats
  • 4.2.2 FTP Servers
  • 4.2.3 Inbound and Outbound Interactions
  • 4.2.4 File Debatching
  • 4.2.5 File ChunkedRead
  • 4.2.6 File Sorting
  • 4.2.7 Dynamic Outbound Directory and File Name Specification
  • 4.2.8 Security
  • 4.2.9 Nontransactional
  • 4.2.10 Proxy Support
  • 4.2.11 No Payload Support
  • 4.2.12 Large Payload Support
  • 4.2.13 File-Based Triggers
  • 4.2.14 Pre-Processing and Post-Processing of Files
    • 4.2.14.1 Mechanism For Pre-Processing and Post-Processing of Files
    • 4.2.14.2 Configuring a Pipeline
    • 4.2.14.3 Using a Re-Entrant Valve For Processing Zip Files
    • 4.2.14.4 Configuring Batch Notification Handler
  • 4.2.15 Error Handling
    • 4.2.15.1 Sending a Malformed XML File to a Local File System Folder
  • 4.2.16 Threading Model
    • 4.2.16.1 Default Threading Model
    • 4.2.16.2 Modified Threading Model
  • 4.2.17 Performance Tuning
  • 4.2.18 High Availability
  • 4.2.19 Multiple Directories
  • 4.2.20 Append Mode
  • 4.2.21 Recursive Processing of Files Within Directories in Oracle FTP Adapter
  • 4.2.22 Securing Enterprise Information System Credentials
• 4.3 Oracle File and FTP Adapter Concepts
  • 4.3.1 Oracle File Adapter Read File Concepts
    • 4.3.1.1 Inbound Operation
    • 4.3.1.2 Inbound File Directory Specifications
    • 4.3.1.3 File Matching and Batch Processing
    • 4.3.1.4 File Polling
    • 4.3.1.5 Postprocessing
    • 4.3.1.6 Native Data Translation
    • 4.3.1.7 Inbound Service
    • 4.3.1.8 Inbound Headers
  • 4.3.2 Oracle File Adapter Write File Concepts
    • 4.3.2.1 Outbound Operation
    • 4.3.2.2 Outbound File Directory Creation
    • 4.3.2.3 Native Data Translation
    • 4.3.2.4 Outbound Service Files
    • 4.3.2.5 Outbound Headers
  • 4.3.3 Oracle File Adapter Synchronous Read Concepts
  • 4.3.4 Oracle File Adapter File Listing Concepts
    • 4.3.4.1 Listing Operation
    • 4.3.4.2 File Directory Specifications
    • 4.3.4.3 File Matching
  • 4.3.5 Oracle FTP Adapter Get File Concepts
  • 4.3.6 Oracle FTP Adapter Put File Concepts
  • 4.3.7 Oracle FTP Adapter Synchronous Get File Concepts
  • 4.3.8 Oracle FTP Adapter File Listing Concepts
• 4.4 Configuring Oracle File and FTP Adapters
  • 4.4.1 Configuring the Credentials for Accessing a Remote FTP Server
  • 4.4.2 Configuring Oracle File and FTP Adapters for High Availability
    • 4.4.2.1 Prerequisites for High Availability
    • 4.4.2.2 High Availability in Inbound Operations
    • 4.4.2.3 High Availability in Outbound Operations
  • 4.4.3 Using Secure FTP with the Oracle FTP Adapter
    • 4.4.3.1 Secure FTP Overview
    • 4.4.3.2 Installing and Configuring FTP Over SSL on Solaris and Linux
    • 4.4.3.3 Installing and Configuring FTP Over SSL on Windows
  • 4.4.4 Using SFTP with Oracle FTP Adapter
    • 4.4.4.1 SFTP Overview
    • 4.4.4.2 Install and Configure OpenSSH for Windows
    • 4.4.4.3 Set Up Oracle FTP Adapter for SFTP
  • 4.4.5 Configuring Oracle FTP Adapter for HTTP Proxy
    • 4.4.5.1 Configuring for Plain FTP Mode
    • 4.4.5.2 Configuring for SFTP Mode
• 4.5 Oracle File and FTP Adapters Use Cases
  • 4.5.1 Oracle File Adapter XML Debatching
    • 4.5.1.1 Prerequisites
    • 4.5.1.2 Designing the SOA Composite
    • 4.5.1.3 Creating the Inbound Oracle File Adapter Service
    • 4.5.1.4 Creating the Outbound File Adapter Service
    • 4.5.1.5 Wiring Services and Activities
    • 4.5.1.6 Deploying with JDeveloper
    • 4.5.1.7 Monitoring Using Oracle Enterprise Manager Fusion Middleware Control Console (Fusion Middleware Control Console)
  • 4.5.2 Flat Structure for Oracle BPEL PM
    • 4.5.2.1 Prerequisites
    • 4.5.2.2 Designing the SOA Composite
    • 4.5.2.3 Creating the Inbound Oracle File Adapter Service
    • 4.5.2.4 Creating the Outbound Oracle File Adapter Service
    • 4.5.2.5 Wiring Services and Activities
    • 4.5.2.6 Deploying with JDeveloper
    • 4.5.2.7 Monitoring Using Oracle Fusion Middleware Control Console
  • 4.5.3 Flat Structure for Mediator
    • 4.5.3.1 Prerequisites
    • 4.5.3.2 Creating a Mediator Application and Project
    • 4.5.3.3 Importing the Schema Definition (.XSD) Files
    • 4.5.3.4 Creating the Inbound Oracle File Adapter Service
    • 4.5.3.5 Creating the Outbound Oracle FTP Adapter Service
    • 4.5.3.6 Wiring Services
    • 4.5.3.7 Creating the Routing Rule
    • 4.5.3.8 Deploying with JDeveloper
    • 4.5.3.9 Run-Time Task
  • 4.5.4 Oracle File Adapter Scalable DOM
    • 4.5.4.1 Prerequisites
    • 4.5.4.2 Designing the SOA Composite
    • 4.5.4.3 Creating the Inbound Oracle File Adapter Service
    • 4.5.4.4 Creating the Outbound Oracle File Adapter Service
    • 4.5.4.5 Wiring Services and Activities
    • 4.5.4.6 Deploying with JDeveloper
    • 4.5.4.7 Monitoring Using Fusion Middleware Control Console
  • 4.5.5 Oracle File Adapter ChunkedRead
    • 4.5.5.1 Prerequisites
    • 4.5.5.2 Designing the SOA Composite
    • 4.5.5.3 Creating the Inbound Oracle File Adapter Service
    • 4.5.5.4 Creating the Outbound Oracle File Adapter Service
    • 4.5.5.5 Wiring Services and Activities
    • 4.5.5.6 Deploying with JDeveloper
    • 4.5.5.7 Monitoring Using Fusion Middleware Control Console
  • 4.5.6 Oracle File Adapter Read File As Attachments
    • 4.5.6.1 Prerequisites
    • 4.5.6.2 Designing the SOA Composite
    • 4.5.6.3 Creating the Inbound Oracle File Adapter Service
    • 4.5.6.4 Creating the Outbound Oracle File Adapter Service
    • 4.5.6.5 Wiring Services and Activities
    • 4.5.6.6 Deploying with JDeveloper
    • 4.5.6.7 Monitoring Using Fusion Middleware Control Console
  • 4.5.7 Oracle File Adapter File Listing
    • 4.5.7.1 Prerequisites
    • 4.5.7.2 Designing the SOA Composite
    • 4.5.7.3 Creating the Outbound Oracle File Adapter Service
    • 4.5.7.4 Wiring Services and Activities
    • 4.5.7.5 Deploying with JDeveloper
    • 4.5.7.6 Monitoring Using Fusion Middleware Control Console
  • 4.5.8 Oracle File Adapter Complex Structure
    • 4.5.8.1 Prerequisites
    • 4.5.8.2 Designing the SOA Composite
    • 4.5.8.3 Creating the Inbound Oracle File Adapter Service
    • 4.5.8.4 Creating the Outbound Oracle File Adapter Service
    • 4.5.8.5 Wiring Services and Activities
    • 4.5.8.6 Deploying with JDeveloper
    • 4.5.8.7 Monitoring Using Fusion Middleware Control Console
  • 4.5.9 Oracle FTP Adapter Debatching
    • 4.5.9.1 Prerequisites
    • 4.5.9.2 Designing the SOA Composite
    • 4.5.9.3 Creating the Inbound Oracle FTP Adapter Service
    • 4.5.9.4 Creating the Outbound Oracle FTP Adapter Service
    • 4.5.9.5 Wiring Services and Activities
    • 4.5.9.6 Deploying with JDeveloper
    • 4.5.9.7 Monitoring Using Fusion Middleware Control Console
  • 4.5.10 Oracle FTP Adapter Dynamic Synchronous Read
    • 4.5.10.1 Prerequisites
    • 4.5.10.2 Designing the SOA Composite
    • 4.5.10.3 Creating the Inbound Oracle File Adapter Service
    • 4.5.10.4 Creating the Outbound Oracle FTP Adapter Service
    • 4.5.10.5 Wiring Services and Activities
    • 4.5.10.6 Deploying with JDeveloper
    • 4.5.10.7 Monitoring Using Fusion Middleware Control Console
  • 4.5.11 Copying, Moving, and Deleting Files
    • 4.5.11.1 Moving a File from a Local Directory on the File System to Another Local Directory
    • 4.5.11.2 Copying a File from a Local Directory on the File System to Another Local Directory
    • 4.5.11.3 Deleting a File from a Local File System Directory
    • 4.5.11.4 Using a Large CSV Source File
    • 4.5.11.5 Moving a File from One Remote Directory to Another Remote Directory on the Same FTP Server
    • 4.5.11.6 Moving a File from a Local Directory on the File System to a Remote Directory on the FTP Server
    • 4.5.11.7 Moving a File from a Remote Directory on the FTP Server to a Local Directory on the File System
    • 4.5.11.8 Moving a File from One FTP Server to another FTP Server
  • 4.5.12 Creating a Synchronous BPEL Composite using File Adapter
    • 4.5.12.1 Changing the Connection Factory JNDI Dynamically in Ftp Adapter
    • 4.5.12.2 Retrieving the Details of the File from an Outbound Write Operation
  • 4.5.13 Changing the Sequencing Strategy for FILE/Ftp Adapter
  • 4.5.14 Creating a Synchronous BPEL Composite using the File Adapter
  • 4.5.15 Controlling the Order in which Files Are Processed

5 Oracle JCA Adapter for Sockets

• 5.1 Introduction to Oracle Socket Adapter
  • 5.1.1 Oracle Socket Adapter Architecture
  • 5.1.2 Oracle Socket Adapter Integration with Mediator
  • 5.1.3 Oracle Socket Adapter Integration with Oracle BPEL PM
  • 5.1.4 Oracle Socket Adapter Integration with SOA Composite
• 5.2 Oracle Socket Adapter Features
• 5.3 Oracle Socket Adapter Concepts
  • 5.3.1 Communication Modes
    • 5.3.1.1 Inbound Synchronous Request/Response
    • 5.3.1.2 Outbound Synchronous Request/Response
    • 5.3.1.3 Inbound Receive
    • 5.3.1.4 Outbound Invoke
  • 5.3.2 Mechanisms for Defining Protocols
    • 5.3.2.1 Protocol with Handshake Mechanism Using Style Sheet
    • 5.3.2.2 Protocol with Handshake Mechanism Using Custom Java Code
    • 5.3.2.3 Protocol Without Handshake Mechanism
  • 5.3.3 Character Encoding and Byte Order
  • 5.3.4 Performance Tuning
    • 5.3.4.1 Configuring Oracle Socket Adapter Connection Pooling
• 5.4 Configuring Oracle Socket Adapter
  • 5.4.1 Modifying the weblogic-ra.xml File
  • 5.4.2 Modeling a Handshake
    • 5.4.2.1 Modeling an Outbound Handshake
    • 5.4.2.2 Modeling an Inbound Handshake
  • 5.4.3 Designing an XSL File Using the XSL Mapper Tool
    • 5.4.3.1 Designing XSL for Inbound Synchronous Request/Reply
    • 5.4.3.2 Designing XSL for Outbound Synchronous Request/Reply
  • 5.4.4 Specifying a TCP Port in a Configuration Plan For an Oracle Socket Adapter
• 5.5 Oracle Socket Adapter Use Cases
  • 5.5.1 Oracle Socket Adapter Hello World
    • 5.5.1.1 Prerequisites
    • 5.5.1.2 Designing the SOA Composite
    • 5.5.1.3 Creating the Inbound Oracle Socket Adapter Service
    • 5.5.1.4 Creating the Outbound Oracle Socket Adapter Service
    • 5.5.1.5 Wiring Services and Activities
    • 5.5.1.6 Deploying with JDeveloper
    • 5.5.1.7 Monitoring Using the Oracle Enterprise Manager Fusion Middleware Control Console (Fusion Middleware Control Console)
  • 5.5.2 Flight Information Display System
    • 5.5.2.1 Prerequisites
    • 5.5.2.2 Designing the SOA Composite
    • 5.5.2.3 Creating the Inbound Oracle Socket Adapter Service
    • 5.5.2.4 Creating Outbound Oracle Socket Adapter Services
    • 5.5.2.5 Wiring Services and Activities
    • 5.5.2.6 Deploying with JDeveloper
    • 5.5.2.7 Monitoring Using the Fusion Middleware Control Console

6 Native Format Builder Wizard

• 6.1 Creating Native Schema Files with the Native Format Builder Wizard
  • 6.1.1 Supported File Formats
    • 6.1.1.1 Delimited
    • 6.1.1.2 Fixed Length (Positional)
    • 6.1.1.3 Complex Type
    • 6.1.1.4 DTD
    • 6.1.1.5 COBOL Copybook
  • 6.1.2 Editing Native Schema Files
• 6.2 Native Schema Constructs
  • 6.2.1 Understanding Native Schema Constructs
  • 6.2.2 Using Native Schema Constructs
    • 6.2.2.1 Defining Fixed-Length Data
    • 6.2.2.2 Defining Terminated Data
    • 6.2.2.3 Defining Surrounded Data
    • 6.2.2.4 Defining Lists
    • 6.2.2.5 Defining Arrays
    • 6.2.2.6 Conditional Processing
    • 6.2.2.7 Defining Dates
    • 6.2.2.8 Using Variables
    • 6.2.2.9 Defining Prefixes and Suffixes
    • 6.2.2.10 Defining Skipping Data
    • 6.2.2.11 Defining fixed and default Values
    • 6.2.2.12 Defining write
    • 6.2.2.13 Defining LookAhead
    • 6.2.2.14 Defining Complex lookAhead Strategies for Conditional Processing of Record using RegEx Expressions
    • 6.2.2.15 Defining outboundHeader
    • 6.2.2.16 Defining Complex Condition in conditionValue
    • 6.2.2.17 Defining Complex Condition in choiceCondition
    • 6.2.2.18 Defining dataLines
    • 6.2.2.19 Defining Date Formats with Time Zone
    • 6.2.2.20 Implementing Validation During Translation
    • 6.2.2.21 Processing Files with BOM
  • 6.2.3 Multi-Byte Translation
    • 6.2.3.1 Specifying Padded Data
    • 6.2.3.2 Specifying a Prefix or a Suffix
    • 6.2.3.3 Translator Behavior
    • 6.2.3.4 SOSI Support
    • 6.2.3.5 Outbound Translation Behavior
• 6.3 Translator XPath Functions
  • 6.3.1 Terminologies
  • 6.3.2 Translator XPath Functions
    • 6.3.2.1 doTranslateFromNative Function
    • 6.3.2.2 doTranslateToNative Function
    • 6.3.2.3 doStreamingTranslate Function
    • 6.3.2.4 Batching Transformation Features
• 6.4 Use Cases for the Native Format Builder
  • 6.4.1 Defining the Schema for a Delimited File Structure
    • 6.4.1.1 Defining a Asterisk (*) Separated Value File Structure
  • 6.4.2 Defining the Schema for a Fixed Length File Structure
  • 6.4.3 Defining the Schema for a Complex File Structure
  • 6.4.4 Removing or Adding Namespaces to XML with No Namespace
  • 6.4.5 Defining the Choice Condition Schema for a Complex File Structure
  • 6.4.6 Defining Choice Condition With LookAhead for a Complex File Structure
  • 6.4.7 Defining Array Type Schema for a Complex File Structure
  • 6.4.8 Defining the Schema for a DTD File Structure
  • 6.4.9 Defining the Schema for a COBOL Copybook File Structure
• 6.5 Command Line Tool for Testing NXSD Translator
  • 6.5.1 Prerequisites
  • 6.5.2 Running the Test Tool

Part II Message Adapters

7 Oracle JCA Adapter for AQ

• 7.1 Introduction to the Oracle AQ Adapter
  • 7.1.1 Oracle AQ Adapter Integration with Oracle BPEL Process Manager
  • 7.1.2 Oracle AQ Adapter Integration with Oracle Mediator
• 7.2 Oracle AQ Adapter Features
  • 7.2.1 Enqueue-Specific Features (Message Production)
  • 7.2.2 Dequeue and Enqueue Features
  • 7.2.3 Supported ADT Payload Types
  • 7.2.4 Native Format Builder Wizard
  • 7.2.5 Normalized Message Support
  • 7.2.6 Is DOM 2 Compliant
  • 7.2.7 Is Message-Size Aware
  • 7.2.8 Multiple Receiver Threads
  • 7.2.9 DequeueTimeout Property
  • 7.2.10 Control Dequeue Timeout and Multiple Inbound Polling Threads
  • 7.2.11 Stream Payload Support
  • 7.2.12 Oracle AQ Adapter Inbound Retries
  • 7.2.13 Error Handling Support
  • 7.2.14 Performance Tuning
• 7.3 Deployment
• 7.4 Oracle AQ Adapter Use Cases
  • 7.4.1 Generic Use Case
    • 7.4.1.1 The Adapter Configuration Wizard Walkthrough
    • 7.4.1.2 Dequeuing and Enqueuing Object and ADT Payloads
    • 7.4.1.3 Dequeuing One Column of the Object Payload
    • 7.4.1.4 Configuring the Enqueue/Dequeue Operation Type
    • 7.4.1.5 Using Correlation ID for Filtering Messages During Dequeue
    • 7.4.1.6 Enqueuing and Dequeuing from Multisubscriber Queues
  • 7.4.2 Oracle AQ Adapter ADT Queue
    • 7.4.2.1 Meeting Prerequisites
    • 7.4.2.2 Creating an Application and an SOA Project
    • 7.4.2.3 Creating an Inbound Oracle AQ Adapter
    • 7.4.2.4 Creating an Outbound Oracle AQ Adapter
    • 7.4.2.5 Wiring Services and Activities
    • 7.4.2.6 Configuring Routing Service
    • 7.4.2.7 Configuring the Data Sources in the Oracle WebLogic Server Administration Console
    • 7.4.2.8 Deploying with JDeveloper
    • 7.4.2.9 Monitoring Using the Fusion Middleware Control Console
  • 7.4.3 Oracle AQ Adapter RAW Queue
    • 7.4.3.1 Prerequisites
    • 7.4.3.2 Creating an Application and an SOA Project
    • 7.4.3.3 Creating an Inbound Adapter Service
    • 7.4.3.4 Creating an Outbound Adapter Service
    • 7.4.3.5 Wiring Services and Activities
    • 7.4.3.6 Configuring the Data Sources in the Oracle WebLogic Server Administration Console
    • 7.4.3.7 Deploying with JDeveloper
    • 7.4.3.8 Monitoring Using the Fusion Middleware Control Console

8 Oracle JCA Adapter for JMS

• 8.1 Introduction to the Oracle JMS Adapter
  • 8.1.1 Oracle JMS Adapter Integration with Oracle BPEL Process Manager
  • 8.1.2 Oracle JMS Adapter Integration with Oracle Mediator
• 8.2 Oracle JMS Adapter Features
• 8.3 Oracle JMS Adapter Concepts
  • 8.3.1 Point-to-Point
  • 8.3.2 Publish/Subscribe
  • 8.3.3 Destination, Connection, Connection Factory, and Session
  • 8.3.4 Structure of a JMS Message
  • 8.3.5 Oracle JMS Adapter Header Properties
• 8.4 Oracle JMS Adapter Use Cases
  • 8.4.1 Configuring Oracle JMS Adapter
    • 8.4.1.1 Creating an Application and a SOA Project
    • 8.4.1.2 Using the Adapter Configuration Wizard to Configure Oracle JMS Adapter
    • 8.4.1.3 Generated Files
    • 8.4.1.4 weblogic-ra.xml file
    • 8.4.1.5 Produce Message Procedure
  • 8.4.2 Configuring Oracle JMS Adapter with TIBCO JMS
    • 8.4.2.1 NonDirect Connection
    • 8.4.2.2 Direct Connection
  • 8.4.3 Configuring Oracle JMS Adapter with IBM WebSphere MQ JMS
    • 8.4.3.1 Non-XA Data Sources
    • 8.4.3.2 XA Data Sources
  • 8.4.4 Configuring Oracle JMS Adapter with Active MQ JMS
  • 8.4.5 WLS JMS Text Message
    • 8.4.5.1 Meeting Prerequisites
    • 8.4.5.2 Creating an Application Server Connection
    • 8.4.5.3 Creating an Application and an SOA Project
    • 8.4.5.4 Creating an Inbound Adapter Service
    • 8.4.5.5 Creating an Outbound Adapter Service
    • 8.4.5.6 Wiring Services and Activities
    • 8.4.5.7 Deploying with JDeveloper
    • 8.4.5.8 Monitoring Using the Fusion Middleware Control Console
  • 8.4.6 Accessing Queues and Topics from WLS JMS Server in a Remote Oracle WebLogic Server Domain
    • 8.4.6.1 JMS Adapter Limitations When a Remote Server is Used
  • 8.4.7 Synchronous/Asynchronous Request Reply Interaction Pattern
    • 8.4.7.1 Synchronous Request Reply Pattern
    • 8.4.7.2 Asynchronous Request Reply Pattern
  • 8.4.8 AQ JMS Text Message
    • 8.4.8.1 Meeting Prerequisites
    • 8.4.8.2 Create an Application Server Connection
    • 8.4.8.3 Creating an Application and an SOA Project
    • 8.4.8.4 Creating an Inbound Adapter Service
    • 8.4.8.5 Creating an Outbound Adapter Service
    • 8.4.8.6 Wiring Services and Activities
    • 8.4.8.7 Deploying with JDeveloper
    • 8.4.8.8 Monitoring Using the Fusion Middleware Control Console
  • 8.4.9 Accessing Queues and Topics Created in 11g from the OC4J 10.1.3.4 Server
  • 8.4.10 Configuring the 11G Server to Access Queues Present in 10.1.3.X OC4J
    • 8.4.10.1 Copy Jar Files into the domains Folder of the Web Logic Server
    • 8.4.10.2 Add Connector factory in the weblogic-ra.xml File
  • 8.4.11 Accessing Distributed Destinations (Queues and Topics) on the WebLogic Server JMS
    • 8.4.11.1 Providing JMS Adapter Access to Distributed Topics
    • 8.4.11.2 The JMS Adapter with Distributed Queues and Distributed Topics
    • 8.4.11.3 One Copy of a Message Per Application (Default Behavior)
    • 8.4.11.4 One Copy Of a Message Per Adapter Endpoint
  • 8.4.12 Configuring Oracle JMS Adapter with IBM WebSphere Default JMS Provider
  • 8.4.13 Configuring Request-Reply in JMS Adapter
  • 8.4.14 Using the WLS JMS Unit-Of-Order with the JMS Adapter
    • 8.4.14.1 Getting a Unit of Order Property

9 Oracle JCA Adapter for Database

• 9.1 Introduction to the Oracle Database Adapter
  • 9.1.1 Functional Overview
    • 9.1.1.1 Oracle Database Adapter Integration with Oracle BPEL PM
  • 9.1.2 Design Overview
• 9.2 Complete Walkthrough of the Adapter Configuration Wizard
  • 9.2.1 Creating an Application and an SOA Project
  • 9.2.2 Defining an Oracle Database Adapter
  • 9.2.3 Connecting to a Database
  • 9.2.4 Selecting the Operation Type
  • 9.2.5 Selecting and Importing Tables
  • 9.2.6 Defining Primary Keys
  • 9.2.7 Creating Relationships
    • 9.2.7.1 What Happens When Relationships Are Created or Removed
    • 9.2.7.2 Different Types of One-to-One Mappings
    • 9.2.7.3 When Foreign Keys Are Primary Keys
  • 9.2.8 Creating the Attribute Filter
  • 9.2.9 Defining a WHERE Clause
  • 9.2.10 Choosing an After-Read Strategy
    • 9.2.10.1 Delete the Rows That Were Read
    • 9.2.10.2 Update a Field in the Table (Logical Delete)
    • 9.2.10.3 Update a Sequencing Table
    • 9.2.10.4 Update an External Sequencing Table on a Different Database
    • 9.2.10.5 Update a Sequencing File
  • 9.2.11 Specifying Polling Options
  • 9.2.12 Specifying Advanced Options
  • 9.2.13 Entering the SQL String for the Pure SQL Operation
• 9.3 Oracle Database Adapter Features
  • 9.3.1 Transaction Support
    • 9.3.1.1 Configuring Oracle Database Adapter for Global Transaction Participation
    • 9.3.1.2 Both Invokes in Same Global Transaction
    • 9.3.1.3 Failure Must Cause Rollback
    • 9.3.1.4 Transaction/XA Support
  • 9.3.2 Pure SQL - XML Type Support
  • 9.3.3 Row Set Support Using a Strongly or Weakly Typed XSD
  • 9.3.4 Proxy Authentication Support
  • 9.3.5 Streaming Large Payload
  • 9.3.6 Schema Validation
  • 9.3.7 High Availability
  • 9.3.8 Scalability
    • 9.3.8.1 Distributed Polling First Best Practice: SELECT FOR UPDATE (SKIP LOCKED)
    • 9.3.8.2 Distributed Polling Second Best Practice: Tuning on a Single Node First
  • 9.3.9 Performance Tuning
  • 9.3.10 detectOmissions Feature
  • 9.3.11 OutputCompletedXml Feature
  • 9.3.12 QueryTimeout for Inbound and Outbound Transactions
  • 9.3.13 Doing Synchronous Post to BPEL (Allow In-Order Delivery)
• 9.4 Oracle Database Adapter Concepts
  • 9.4.1 Relational-to-XML Mapping
    • 9.4.1.1 Relational Types to XML Schema Types
    • 9.4.1.2 Mapping Any Relational Schema to Any XML Schema
    • 9.4.1.3 Querying over Multiple Tables
  • 9.4.2 SQL Operations as Web Services
    • 9.4.2.1 DML Operations
    • 9.4.2.2 Polling Strategies
• 9.5 Deployment
  • 9.5.1 Deployment with Third Party Databases
• 9.6 JDBC Driver and Database Connection Configuration
  • 9.6.1 Creating a Database Connection Using a Native or Bundled Oracle WebLogic Server JDBC Driver
  • 9.6.2 Creating a Database Connection Using a Third-Party JDBC Driver
  • 9.6.3 Summary of Third-Party JDBC Driver and Database Connection Information
    • 9.6.3.1 Using a Microsoft SQL Server
    • 9.6.3.2 Using a Sybase Database
    • 9.6.3.3 Using an Informix Database
    • 9.6.3.4 Using an IBM DB2 Database
    • 9.6.3.5 Using a MySQL Database
  • 9.6.4 Location of JDBC Driver JAR Files and Setting the Class Path
• 9.7 Stored Procedure and Function Support
  • 9.7.1 Design Time: Using the Adapter Configuration Wizard
    • 9.7.1.1 Using Top-Level Standalone APIs
    • 9.7.1.2 Using Packaged APIs and Overloading
  • 9.7.2 Supported Third-Party Databases
    • 9.7.2.1 Terms Used
    • 9.7.2.2 Supported Third-Party Databases
    • 9.7.2.3 Creating Database Connections
  • 9.7.3 Design Time: Artifact Generation
    • 9.7.3.1 The WSDL–XSD Relationship
    • 9.7.3.2 JCA File
    • 9.7.3.3 Oracle Data Types
    • 9.7.3.4 Generated XSD Attributes
    • 9.7.3.5 User-Defined Types
    • 9.7.3.6 Complex User-Defined Types
    • 9.7.3.7 Object Type Inheritance
    • 9.7.3.8 Object References
    • 9.7.3.9 Referencing Types in Other Schemas
    • 9.7.3.10 XSD Pruning Optimization
  • 9.7.4 Run Time: Before Stored Procedure Invocation
    • 9.7.4.1 Value Binding
    • 9.7.4.2 Data Type Conversions
  • 9.7.5 Run Time: After Stored Procedure Invocation
    • 9.7.5.1 Data Type Conversions
    • 9.7.5.2 Null Values
    • 9.7.5.3 Function Return Values
  • 9.7.6 Run Time: Common Third-Party Database Functionality
    • 9.7.6.1 Processing ResultSets
    • 9.7.6.2 Returning an INTEGER Status Value
  • 9.7.7 Advanced Topics
    • 9.7.7.1 Row Set Support Using a Strongly Typed XSD
    • 9.7.7.2 Row Set Support Using a Weakly Typed XSD
    • 9.7.7.3 Support for PL/SQL Boolean, PL/SQL Record, and PL/SQL Table Types
• 9.8 Oracle Database Adapter Use Cases
  • 9.8.1 Use Cases for Oracle Database Adapter
  • 9.8.2 Use Cases for Oracle Database Adapter - Stored Procedures
    • 9.8.2.1 Creating and Configuring a Stored Procedure in JDeveloper BPEL Designer
    • 9.8.2.2 File To StoredProcedure Use Case
  • 9.8.3 Database Adapter/Coherence Integration
    • 9.8.3.1 Inserts/Updates to a Database
    • 9.8.3.2 Database Adapter/Coherence Integration Architecture

10 Oracle JCA Adapter for MQ Series

• 10.1 MQ Series Message Queuing Concepts
  • 10.1.1 MQ Series Concepts
• 10.2 Introduction to Native Oracle MQ Series Adapter
  • 10.2.1 The Need for Oracle MQ Series Adapter
  • 10.2.2 Oracle MQ Series Adapter Integration with Oracle BPEL Process Manager
  • 10.2.3 Oracle MQ Series Adapter Integration with Mediator
• 10.3 Oracle MQ Series Adapter Features
  • 10.3.1 RFH Version 2 (RFH2) Header
    • 10.3.1.1 Fixed Portion
    • 10.3.1.2 Variable Portion
  • 10.3.2 SSL Enabling
  • 10.3.3 XA Transactions
    • 10.3.3.1 XA Recovery
  • 10.3.4 High Availability
    • 10.3.4.1 Prerequisites for High Availability
    • 10.3.4.2 High Availability in Inbound/Outbound Operations
  • 10.3.5 Scalability
  • 10.3.6 Securing Enterprise Information System Credentials
  • 10.3.7 Fault Policy
  • 10.3.8 Inbound Rejection Handler
  • 10.3.9 Retry Mechanism
    • 10.3.9.1 JCA Inbound Retry Mechanism
    • 10.3.9.2 Message Backout Queue
  • 10.3.10 Performance Tuning
• 10.4 Oracle MQ Series Adapter Concepts
  • 10.4.1 Messaging Scenarios
    • 10.4.1.1 Enqueue Message
    • 10.4.1.2 Dequeue Message
    • 10.4.1.3 Asynchronous Request-Response (Oracle BPEL PM As Client)
    • 10.4.1.4 Synchronous Request-Response (Oracle BPEL PM As Server)
    • 10.4.1.5 Asynchronous Request-Response (Oracle BPEL PM As Server)
    • 10.4.1.6 Synchronous Request-Response (Mediator As Server)
    • 10.4.1.7 Synchronous Request-Response (Oracle BPEL PM As Client)
    • 10.4.1.8 Synchronous Request-Response (Oracle Mediator as Client)
    • 10.4.1.9 Asynchronous Request-Response (Oracle Mediator As Client)
    • 10.4.1.10 Outbound Dequeue Scenario
  • 10.4.2 Message Properties
    • 10.4.2.1 Messages Types
    • 10.4.2.2 Message Format
    • 10.4.2.3 Message Expiry
    • 10.4.2.4 Message Priority
    • 10.4.2.5 Message Persistence
  • 10.4.3 Correlation Schemas
  • 10.4.4 Distribution List Support
  • 10.4.5 Report Messages
  • 10.4.6 Message Delivery Failure Options
  • 10.4.7 Message Segmentation
  • 10.4.8 Integration with CICS
  • 10.4.9 Supported Encodings
  • 10.4.10 Using the MQ Series Client Channel Definition Table Feature
• 10.5 Configuring the Oracle MQ Series Adapter
  • 10.5.1 Adding jar Files to the Oracle MQ Series Adapter Classpath: MQ Series 6 and 7
  • 10.5.2 Adding JNDI Entry
  • 10.5.3 Enabling Binding Mode for Connections
• 10.6 Oracle MQ Series Adapter Use Cases
  • 10.6.1 Dequeue Enqueue
    • 10.6.1.1 Prerequisites
    • 10.6.1.2 Designing the SOA Composite
    • 10.6.1.3 Creating an Inbound Adapter Service
    • 10.6.1.4 Creating an Outbound Adapter Service
    • 10.6.1.5 Wiring Services and Activities
    • 10.6.1.6 Deploying with JDeveloper
    • 10.6.1.7 Monitoring Using the Oracle Enterprise Manager Fusion Middleware Control Console (Fusion Middleware Control Console)
  • 10.6.2 Inbound Synchronous Request-Reply
    • 10.6.2.1 Prerequisites
    • 10.6.2.2 Designing the SOA Composite
    • 10.6.2.3 Creating an Inbound Adapter Service
    • 10.6.2.4 Wiring Services and Activities
    • 10.6.2.5 Deploying with JDeveloper
    • 10.6.2.6 Monitoring Using the Fusion Middleware Control Console
  • 10.6.3 Inbound-Outbound Synchronous Request-Reply
    • 10.6.3.1 Prerequisites
    • 10.6.3.2 Designing the SOA Composite
    • 10.6.3.3 Creating an Inbound Adapter Service
    • 10.6.3.4 Creating an Outbound Adapter Service
    • 10.6.3.5 Wiring Services and Activities
    • 10.6.3.6 Deploying with JDeveloper
    • 10.6.3.7 Monitoring Using the Fusion Middleware Control Console
  • 10.6.4 Asynchronous-Request-Reply
    • 10.6.4.1 Prerequisites
    • 10.6.4.2 Designing the SOA Composite
    • 10.6.4.3 Creating an Inbound Adapter Service
    • 10.6.4.4 Creating an Asynchronous Outbound Request Reply Adapter Service Outbound
    • 10.6.4.5 Creating Another Outbound Adapter Service
    • 10.6.4.6 Wiring Services and Activities
    • 10.6.4.7 Deploying with JDeveloper
    • 10.6.4.8 Monitoring Using the Fusion Middleware Control Console
  • 10.6.5 Outbound Dequeue
    • 10.6.5.1 Prerequisites
    • 10.6.5.2 Designing the SOA Composite
    • 10.6.5.3 Creating an Outbound Dequeue Adapter Service
    • 10.6.5.4 Wiring Services and Activities
    • 10.6.5.5 Deploying with JDeveloper
    • 10.6.5.6 Monitoring Using the Fusion Middleware Control Console
  • 10.6.6 Configuring a Backout Queue
    • 10.6.6.1 Prerequisites
    • 10.6.6.2 Designing the SOA Composite
    • 10.6.6.3 Creating an Inbound Adapter Service
    • 10.6.6.4 Creating an Outbound Adapter Service
    • 10.6.6.5 Wiring Services and Activities
    • 10.6.6.6 Deploying with JDeveloper
    • 10.6.6.7 Monitoring Using the Fusion Middleware Control Console
  • 10.6.7 CCDT Use Cases
    • 10.6.7.1 Example Queue Manager Properties and CCDT Configuration
    • 10.6.7.2 Configuringa ConnectionFactoryJNDI
    • 10.6.7.3 Configuring the CCDTurl
    • 10.6.7.4 Configuring the QueueManagerName
  • 10.6.8 Reading Single or Multiple RFH2 Rules and Formatting Header Version 2 Headers
    • 10.6.8.1 Inbound and Outbound with Multiple RFH2 Headers on Both Sides
    • 10.6.8.2 Outbound Dequeue with Multiple RFH2 Headers

11 Oracle JCA Adapter for UMS

• 11.1 UMS and UMS Adapter Concepts
  • 11.1.1 Oracle UMS Adapter
• 11.2 Oracle UMS Adapter Features
  • 11.2.1 UMS Adapter Message Concepts
    • 11.2.1.1 Custom Java Callout
  • 11.2.2 UMS Adapter Error Handling and Transactions
    • 11.2.2.1 Using a JNDI Name Configured to Use XA With LRC Optimization
    • 11.2.2.2 Inbound Error Handling
    • 11.2.2.3 Outbound Error Handling
    • 11.2.2.4 Email Attachments
    • 11.2.2.5 Mail Attachment Handling
    • 11.2.2.6 UMS Adapter Inbound and Outbound Operations
  • 11.2.3 Configuring the Oracle UMS Adapter
    • 11.2.3.1 Configuring the Email Driver for the UMS Adapter - Outbound Connectivity
    • 11.2.3.2 Configuring the Email Driver for UMS Adapter - Inbound Connectivity
    • 11.2.3.3 Designing the Adapter Service and the BPEL Process for Inbound Connectivity
    • 11.2.3.4 Designing the Adapter Service and the BPEL Process for Outbound Connectivity
• 11.3 Sample
  • 11.3.1 Creating the Composite
  • 11.3.2 Creating the Inbound Oracle UMS Adapter Service
  • 11.3.3 Creating the Outbound UMS Adapter service
  • 11.3.4 Wiring Services and Activities
  • 11.3.5 Add a Receive Activity
  • 11.3.6 Obtaining Email Header Information
  • 11.3.7 UMS Adapter Configuration Changes for IBM WebSphere Server

A Oracle JCA Adapter Properties

• A.1 Oracle File and FTP Adapters Properties
• A.2 Oracle Socket Adapter Properties
• A.3 Oracle AQ Adapter Properties
• A.4 Oracle JMS Adapter Properties
• A.5 Oracle Database Adapter Properties
• A.6 Oracle MQ Series Adapter Properties
• A.7 Generic Oracle JCA Adapter Properties
• A.8 Generic Oracle Adapter Binding Properties

B Oracle JCA Adapter Valves

• B.1 A Simple Unzip Valve
• B.2 A Simple Decryption Valve That Uses Staging File
• B.3 A Valve for Encrypting Outbound Files
• B.4 An Unzip Valve for processing Multiple Files

Index