Table of Contents
- Title and Copyright Information
- Preface
-
Part I Introduction and Concepts
- 1 Introduction to Oracle JCA Adapters
-
2
Adapter Framework
- 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.4 Configuring Message Header Properties for Oracle JCA Adapters
- 2.5 Physically Deploying Oracle JCA Adapters
- 2.6 Creating an Application Server Connection for Oracle JCA Adapters
- 2.7 Deploying Oracle JCA Adapter Applications from JDeveloper
- 2.8 Manually Deploying an Adapter RAR File that Does Not Have a Jar File Associated With It
- 2.9 Handling the Deployment Plan When Working on a Remote Oracle SOA Server
- 2.10 Migrating Repositories from Different Environments
- 2.11 Message Ordering
- 2.12 How Oracle JCA Adapters Ensure No Message Loss
- 2.13 Composite Availability and Inbound Adapters
- 2.14 Singleton (Active/Passive) Inbound Endpoint Lifecycle Support Within Adapters
- 2.15 Correlation Support Within Adapters
- 2.16 Setting Payload Size Threshold
- 2.17 Streaming Large Payload
- 2.18 Batching and Debatching Support
- 2.19 Adding an Adapter Connection Factory
- 2.20 Adding or Updating an Adapter Connection Factory
- 2.21 Recommended Settings for Data Sources Used by Oracle JCA Adapters
-
2.22
Error Handling
- 2.22.1 Handling Rejected Messages
- 2.22.2 Inbound Interaction Error Handling
- 2.22.3 Outbound Adapter Interaction Error Handling
- 2.23 Integrating JCA adapters with Oracle Web Services Manager to Protect Sensitive Data in Audit Trails
- 2.24 Testing Applications
- 2.25 Setting the Trace Level of Oracle JCA Adapters
- 2.26 Viewing Adapter Logs
- 2.27 Adapter Diagnosability Dumps
- 2.28 Creating a Custom Adapter
- 2.29 Advanced Topic: Using the Execution Context ID Across Technologies
- 3 Adapter Integration with Oracle Application Server Components
-
4
Native Format Builder Wizard
- 4.1 Creating Native Schema Files with the Native Format Builder Wizard
-
4.2
Native Schema Constructs
- 4.2.1 Understanding Native Schema Constructs
-
4.2.2
Using Native Schema Constructs
- 4.2.2.1 Defining Fixed-Length Data
- 4.2.2.2 Defining Terminated Data
- 4.2.2.3 Defining Surrounded Data
- 4.2.2.4 Defining Lists
-
4.2.2.5
Defining Arrays
- 4.2.2.5.1 All Cells Separated by the Same Mark, but the Last Cell Terminated by a Different Mark (Bounded)
- 4.2.2.5.2 All Cells Separated by the Same Mark, Including the Last Cell (Unbounded)
- 4.2.2.5.3 Cells Not Separated by Any Mark, but the Last Cell Terminated by a Mark (Bounded)
- 4.2.2.5.4 The Number of Cells Being Read from the Native Data
- 4.2.2.5.5 Explicit Array Length
- 4.2.2.6 Conditional Processing
- 4.2.2.7 Defining Dates
- 4.2.2.8 Using Variables
- 4.2.2.9 Defining Prefixes and Suffixes
- 4.2.2.10 Defining Skipping Data
- 4.2.2.11 Defining fixed and default Values
- 4.2.2.12 Defining write
- 4.2.2.13 Defining LookAhead
- 4.2.2.14 Defining Complex Look Ahead Strategies for Conditional Processing of Record Using Regular Expressions
- 4.2.2.15 Defining outboundHeader
- 4.2.2.16 Defining Complex Condition in conditionValue
- 4.2.2.17 Defining Complex Condition in choiceCondition
- 4.2.2.18 Defining dataLines
- 4.2.2.19 Defining Date Formats with Time Zone
- 4.2.2.20 Implementing Validation During Translation
- 4.2.2.21 Processing Files with BOM
-
4.2.3
Multi-Byte Translation for Inbound and Outbound Native Data
- 4.2.3.1 The Initial Problem
- 4.2.3.2 Solution
- 4.2.3.3 Specifying Padded Data
- 4.2.3.4 Specifying a Prefix or a Suffix
- 4.2.3.5 Translator Behavior with Multi-Stream Data
- 4.2.3.6 Outbound Translation Behavior
-
4.2.3.7
Examples
- 4.2.3.7.1 Base 64 Binary Padded Data
- 4.2.3.7.2 Binary
- 4.2.3.7.3 Shift JIS Encoding
- 4.2.3.7.4 Identifier Length Example
- 4.2.3.7.5 Identifier Example base64BInary
- 4.2.3.7.6 Identifier-Padded Data with SJIS
- 4.2.3.7.7 Identifier-Padded Binary
- 4.2.3.7.8 Padded Multibyte Binary Element
- 4.2.3.7.9 Padded Multi-Byte Decimal
- 4.2.4 SOSI Support
- 4.3 Translator XPath Functions
-
4.4
Use Cases for the Native Format Builder
- 4.4.1 Defining the Schema for a Delimited File Structure
- 4.4.2 Defining the Schema for a Fixed Length File Structure
- 4.4.3 Defining the Schema for a Complex File Structure
- 4.4.4 Removing or Adding Namespaces to XML with No Namespace
- 4.4.5 Defining the Choice Condition Schema for a Complex File Structure
- 4.4.6 Defining Choice Condition With LookAhead for a Complex File Structure
- 4.4.7 Defining Array Type Schema for a Complex File Structure
- 4.4.8 Defining the Schema for a DTD File Structure
- 4.4.9 Defining the Schema for a COBOL Copybook File Structure
-
4.5
Command Line Tool for Testing NXSD Translator
- 4.5.1 Running the Test Tool
- 4.5.2 Using the Native Format Builder to Perform MFL Conversion
- 4.5.3 Multi-Character Streaming Support
- 4.5.4 Shared Delimiters
-
Part II Oracle Technology Adapters
-
5
Oracle JCA Adapter for Files/FTP
- 5.1 Introduction to Oracle File and FTP Adapters
-
5.2
Oracle File and FTP Adapters Features
- 5.2.1 File Formats
- 5.2.2 FTP Servers
- 5.2.3 Inbound and Outbound Interactions
- 5.2.4 File Debatching
- 5.2.5 File Chunked Read
- 5.2.6 File Sorting
- 5.2.7 Dynamic Outbound Directory and File Name Specification
- 5.2.8 Security
- 5.2.9 Nontransactional
- 5.2.10 Proxy Support
- 5.2.11 No Payload Support
- 5.2.12 Large Payload Support
- 5.2.13 File-Based Triggers
- 5.2.14 Pre-Processing and Post-Processing of Files
- 5.2.15 Error Handling
- 5.2.16 Threading Model
- 5.2.17 Performance Tuning
- 5.2.18 High Availability
- 5.2.19 Multiple Directories
- 5.2.20 Append Mode
- 5.2.21 Recursive Processing of Files Within Directories in Oracle FTP Adapter
- 5.2.22 Securing Enterprise Information System Credentials
-
5.3
Oracle File and FTP Adapter Concepts
- 5.3.1 Oracle File Adapter Read File Concepts
-
5.3.2
Oracle File Adapter Write File Concepts
- 5.3.2.1 Outbound Operation
-
5.3.2.2
Outbound File Directory Creation
- 5.3.2.2.1 Specifying Outbound Physical or Logical Directory Paths in Oracle BPEL PM
- 5.3.2.2.2 Specifying Outbound Physical or Logical Directory Paths in Mediator
- 5.3.2.2.3 Specifying a Dynamic Outbound Directory Name
- 5.3.2.2.4 Specifying the Outbound File Naming Convention
- 5.3.2.2.5 Specifying a Dynamic Outbound File Name
- 5.3.2.2.6 Batching Multiple Outbound Messages
- 5.3.2.3 Native Data Translation
- 5.3.2.4 Outbound Service Files
- 5.3.2.5 Outbound Headers
- 5.3.3 Oracle File Adapter Synchronous Read Concepts
- 5.3.4 Oracle File Adapter File Listing Concepts
- 5.3.5 Oracle FTP Adapter Get File Concepts
- 5.3.6 Oracle FTP Adapter Put File Concepts
- 5.3.7 Oracle FTP Adapter Synchronous Get File Concepts
- 5.3.8 Oracle FTP Adapter File Listing Concepts
- 5.3.9 File and FTP Adapter Extensions
-
5.4
Configuring Oracle File and FTP Adapters
- 5.4.1 Configuring the Credentials for Accessing a Remote FTP Server
- 5.4.2 Configuring Oracle File and FTP Adapters for High Availability
-
5.4.3
Using Secure FTP with the Oracle FTP Adapter
- 5.4.3.1 Secure FTP Overview
- 5.4.3.2 Installing and Configuring FTP Over SSL on Solaris and Linux
-
5.4.3.3
Installing and Configuring FTP Over SSL on Windows
- 5.4.3.3.1 Installing OpenSSL
- 5.4.3.3.2 Generating OpenSSL Server Key and Certificate
- 5.4.3.3.3 Importing the Server Key and Certificate Into FileZilla Server
- 5.4.3.3.4 Converting the Server Key From PEM to PKCS12 Format
- 5.4.3.3.5 Configuring Oracle FTP Adapter Deployment Descriptor to Use the New Key
-
5.4.4
Using SFTP with the Oracle FTP Adapter
- 5.4.4.1 SFTP Overview
- 5.4.4.2 Install and Configure OpenSSH for Windows
-
5.4.4.3
Set Up Oracle FTP Adapter for SFTP
- 5.4.4.3.1 Configuring Oracle FTP Adapter for Password Authentication
- 5.4.4.3.2 Configuring Oracle FTP Adapter for Public Key Authentication
- 5.4.4.3.3 Configuring OpenSSH for Public-Key Authentication
- 5.4.4.3.4 Configuring Oracle FTP Adapter for Public Key Authentication with OpenSSH Running Inside a Firewall
- 5.4.4.3.5 Configuring Oracle FTP Adapter for Public Key Authentication with OpenSSH Running Outside a Firewall
- 5.4.4.3.6 Configuring for WINSSHD Servers
- 5.4.5 Enabling FIPS Compliance in Oracle File and FTP Adapters
- 5.4.6 Configuring Oracle FTP Adapter for HTTP Proxy
- 5.4.7 Configuring File and FTP Adapters for High Availability
-
5.5
Oracle File and FTP Adapters Use Cases
-
5.5.1
Oracle File Adapter XML Debatching
- 5.5.1.1 Prerequisites
- 5.5.1.2 Splitting an Input XML Document that Contains Repeating Element
- 5.5.1.3 Designing the SOA Composite
- 5.5.1.4 Creating the Inbound Oracle File Adapter Service
- 5.5.1.5 Creating the Outbound File Adapter Service
- 5.5.1.6 Wiring Services and Activities
- 5.5.1.7 Deploying with JDeveloper
- 5.5.1.8 Monitoring Using the Oracle Fusion Middleware Control Console
-
5.5.2
Flat Structure for Oracle BPEL PM
- 5.5.2.1 Prerequisites
- 5.5.2.2 Designing the SOA Composite
- 5.5.2.3 Creating the Inbound Oracle File Adapter Service
- 5.5.2.4 Creating the Outbound Oracle File Adapter Service
- 5.5.2.5 Wiring Services and Activities
- 5.5.2.6 Deploying with JDeveloper
- 5.5.2.7 Monitoring Using the Oracle Fusion Middleware Control Console
-
5.5.3
Flat Structure for Mediator
- 5.5.3.1 Prerequisites
- 5.5.3.2 Creating a Mediator Application and Project
- 5.5.3.3 Importing the Schema Definition (.XSD) Files
- 5.5.3.4 Creating the Inbound Oracle File Adapter Service
- 5.5.3.5 Creating the Outbound Oracle FTP Adapter Service
- 5.5.3.6 Wiring Services
- 5.5.3.7 Creating the Routing Rule
- 5.5.3.8 Deploying with JDeveloper
- 5.5.3.9 Runtime Task
-
5.5.4
Oracle File Adapter Scalable DOM
- 5.5.4.1 Prerequisites
- 5.5.4.2 Designing the SOA Composite
- 5.5.4.3 Creating the Inbound Oracle File Adapter Service
- 5.5.4.4 Creating the Outbound Oracle File Adapter Service
- 5.5.4.5 Wiring Services and Activities
- 5.5.4.6 Deploying with JDeveloper
- 5.5.4.7 Monitoring Using the Oracle Fusion Middleware Control Console
-
5.5.5
Oracle File Adapter Chunked Read
- 5.5.5.1 Prerequisites
- 5.5.5.2 Designing the SOA Composite
- 5.5.5.3 Creating the Inbound Oracle File Adapter Service
- 5.5.5.4 Creating the Outbound Oracle File Adapter Service
- 5.5.5.5 Wiring Services and Activities
- 5.5.5.6 Deploying with JDeveloper
- 5.5.5.7 Monitoring Using the Oracle Fusion Middleware Control Console
-
5.5.6
Oracle File Adapter Read File As Attachments
- 5.5.6.1 Prerequisites
- 5.5.6.2 Designing the SOA Composite
- 5.5.6.3 Creating the Inbound Oracle File Adapter Service
- 5.5.6.4 Creating the Outbound Oracle File Adapter Service
- 5.5.6.5 Wiring Services and Activities
- 5.5.6.6 Deploying with JDeveloper
- 5.5.6.7 Monitoring Using the Oracle Fusion Middleware Control Console
- 5.5.7 Oracle File Adapter File Listing
-
5.5.8
Oracle File Adapter Complex Structure
- 5.5.8.1 Prerequisites
- 5.5.8.2 Designing the SOA Composite
- 5.5.8.3 Creating the Inbound Oracle File Adapter Service
- 5.5.8.4 Creating the Outbound Oracle File Adapter Service
- 5.5.8.5 Wiring Services and Activities
- 5.5.8.6 Deploying with JDeveloper
- 5.5.8.7 Monitoring Using the Oracle Fusion Middleware Control Console
-
5.5.9
Oracle FTP Adapter Debatching
- 5.5.9.1 Prerequisites
- 5.5.9.2 Designing the SOA Composite
- 5.5.9.3 Creating the Inbound Oracle FTP Adapter Service
- 5.5.9.4 Creating the Outbound Oracle FTP Adapter Service
- 5.5.9.5 Wiring Services and Activities
- 5.5.9.6 Deploying with JDeveloper
- 5.5.9.7 Monitoring Using the Oracle Fusion Middleware Control Console
-
5.5.10
Oracle FTP Adapter Dynamic Synchronous Read
- 5.5.10.1 Prerequisites
- 5.5.10.2 Designing the SOA Composite
- 5.5.10.3 Creating the Inbound Oracle File Adapter Service
- 5.5.10.4 Creating the Outbound Oracle FTP Adapter Service
- 5.5.10.5 Wiring Services and Activities
- 5.5.10.6 Deploying with JDeveloper
- 5.5.10.7 Monitoring Using the Oracle Fusion Middleware Control Console
-
5.5.11
Copying, Moving, and Deleting Files
- 5.5.11.1 Moving a File from a Local Directory on the File System to Another Local Directory
- 5.5.11.2 Copying a File from a Local Directory on the File System to Another Local Directory
- 5.5.11.3 Deleting a File from a Local File System Directory
- 5.5.11.4 Using a Large CSV Source File
- 5.5.11.5 Moving a File from One Remote Directory to Another Remote Directory on the Same FTP Server
- 5.5.11.6 Moving a File from a Local Directory on the File System to a Remote Directory on the FTP Server
- 5.5.11.7 Moving a File from a Remote Directory on the FTP Server to a Local Directory on the File System
- 5.5.11.8 Moving a File from One FTP Server to another FTP Server
- 5.5.12 Creating a Synchronous BPEL Composite using File Adapter
- 5.5.13 Changing the Sequencing Strategy for FILE/FTP Adapter
- 5.5.14 Controlling the Order in which Files Are Processed
-
5.5.15
Extending FTP Adapter
- 5.5.15.1 Use Case: FTP Adapter Extension of FTP Client Login
- 5.5.15.2 Use Case: Configuring the FTP Adapter to Handle Response from MLSD Command
- 5.5.15.3 Use Case: Extend the Listing Operation to Send MLSD Commands Rather Than the LIST Commands
- 5.5.15.4 Use Case: Extend the Store Operation to Send Additional Proprietary FTP Commands to FTP Server Running on the MVS Platform
- 5.5.15.5 Additional Configuration Parameters, Implementations, Interfaces and Schema
- 5.5.15.6 FtpListResponseParser Interface
- 5.5.15.7 FtpTimestampParser Interface
- 5.5.15.8 ftpmapping Schema
-
5.5.1
Oracle File Adapter XML Debatching
-
6
Oracle JCA Adapter for Sockets
- 6.1 Introduction to Oracle Socket Adapter
- 6.2 Oracle Socket Adapter Features
- 6.3 Oracle Socket Adapter Concepts
-
6.4
Configuring Oracle Socket Adapter
- 6.4.1 Modifying the weblogic-ra.xml File
- 6.4.2 Modeling a Handshake
- 6.4.3 Designing an XSL File Using the XSL Mapper Tool
- 6.4.4 Specifying a TCP Port in a Configuration Plan For an Oracle Socket Adapter
- 6.4.5 Enabling Oracle Socket Adapter to Accept Multiple Requests
- 6.4.6 Java Script Support
- 6.4.7 Socket Adapter NIO Support
- 6.4.8 SSL Support for the Socket Adapter
-
6.5
Oracle Socket Adapter Use Cases
-
6.5.1
Oracle Socket Adapter Hello World
- 6.5.1.1 Prerequisites
- 6.5.1.2 Designing the SOA Composite
- 6.5.1.3 Creating the Inbound Oracle Socket Adapter Service
- 6.5.1.4 Creating the Outbound Oracle Socket Adapter Service
- 6.5.1.5 Wiring Services and Activities
- 6.5.1.6 Deploying with JDeveloper
- 6.5.1.7 Monitoring Using the Oracle Fusion Middleware Control Console
-
6.5.2
Flight Information Display System
- 6.5.2.1 Prerequisites
- 6.5.2.2 Designing the SOA Composite
- 6.5.2.3 Creating the Inbound Oracle Socket Adapter Service
- 6.5.2.4 Creating Outbound Oracle Socket Adapter Services
- 6.5.2.5 Wiring Services and Activities
- 6.5.2.6 Deploying with JDeveloper
- 6.5.2.7 Monitoring Using the Oracle Fusion Middleware Control Console
- 6.5.3 Cluster Support for Socket Adapter
-
6.5.1
Oracle Socket Adapter Hello World
-
7
Oracle JCA Adapter for AQ
- 7.1 Introduction to the Oracle AQ Adapter
-
7.2
Oracle AQ Adapter Features
- 7.2.1 Enqueue-Specific Features (Message Production)
- 7.2.2 Dequeue and Enqueue Features
- 7.2.3 Synchronous Request-Response
- 7.2.4 Synchronous Dequeue
- 7.2.5 Supported ADT Payload Types
- 7.2.6 Native Format Builder Wizard
- 7.2.7 Normalized Message Support
- 7.2.8 Is DOM 2 Compliant
- 7.2.9 Is Message-Size Aware
- 7.2.10 Multiple Receiver Threads
- 7.2.11 DequeueTimeout Property
- 7.2.12 Control Dequeue Timeout and Multiple Inbound Polling Threads
- 7.2.13 Stream Payload Support
- 7.2.14 Oracle AQ Adapter Inbound Retries
- 7.2.15 Error Handling Support
- 7.2.16 Performance Tuning
- 7.3 Oracle AQ Adapter Deployment
-
7.4
Oracle AQ Adapter Use Cases
-
7.4.1
Generic Use Cases
- 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.4.1 Prerequisites
- 7.4.1.4.2 Creating an Application and a SOA Project
- 7.4.1.4.3 Defining an Oracle AQ Adapter Service
- 7.4.1.4.4 Wiring Services and Activities
- 7.4.1.4.5 Deploying with JDeveloper
- 7.4.1.4.6 Monitoring Using the Oracle Fusion Middleware Control Console
- 7.4.1.4.7 Generated WSDL and JCA Files
- 7.4.1.5 Using Correlation ID for Filtering Messages During Dequeue
- 7.4.1.6 Enqueuing and Dequeuing from Multisubscriber Queues
- 7.4.1.7 Using Message Selector Rule for Filtering Messages During Dequeue
-
7.4.2
Oracle AQ Adapter ADT Queue
- 7.4.2.1 Prerequisites
- 7.4.2.2 Creating an Application and a 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 Oracle 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 a 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 Oracle Fusion Middleware Control Console
-
7.4.1
Generic Use Cases
-
8
Oracle JCA Adapter for JMS
- 8.1 Introduction to the Oracle JMS Adapter
- 8.2 Oracle JMS Adapter Features
- 8.3 Oracle JMS Adapter Concepts
-
8.4
Oracle JMS Adapter Use Cases
- 8.4.1 Configuring Oracle JMS Adapter
-
8.4.2
Configuring the Oracle JMS Adapter with TIBCO JMS
- 8.4.2.1 Using Preconfigured Tibco Connection Factory for non-SSL Connections
- 8.4.2.2 Using Dynamically Created Tibco Connection Factory for non-SSL Connections
- 8.4.2.3 Using a Preconfigured Tibco Connection Factory for SSL Connections
- 8.4.2.4 Using Dynamically Created Tibco Connection Factory for SSL Connections
- 8.4.3 Configuring Oracle JMS Adapter with IBM WebSphere MQ JMS
- 8.4.4 Configuring Oracle JMS Adapter with Active MQ JMS
-
8.4.5
WebLogic Server JMS Text Message
- 8.4.5.1 Prerequisites
- 8.4.5.2 Creating an Application Server Connection
- 8.4.5.3 Creating an Application and a 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 Oracle Fusion Middleware Control Console
- 8.4.6 Accessing Queues and Topics from WLS JMS Server in a Remote Oracle WebLogic Server Domain
- 8.4.7 Synchronous/Asynchronous Request Reply Interaction Pattern
-
8.4.8
AQ JMS Text Message
- 8.4.8.1 Prerequisites
- 8.4.8.2 Creating an Application Server Connection
- 8.4.8.3 Creating an Application and a 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 Oracle 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 or Later Server to Access Queues Present in 10.1.3.X OC4J
- 8.4.11 Accessing Distributed Destinations (Queues and Topics) on the WebLogic Server JMS
- 8.4.12 Configuring Oracle JMS Adapter with IBM WebSphere Default JMS Provider
- 8.4.13 Configuring Request-Reply in the JMS Adapter
- 8.4.14 Using the WLS JMS Unit-Of-Order with the JMS Adapter
- 8.4.15 JMS Synchronous Consume
-
9
Oracle JCA Adapter for Database
- 9.1 Introduction to the Oracle Database Adapter
-
9.2
Complete Walkthrough of the Database Adapter Configuration Wizard
- 9.2.1 Creating an Application and a 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.8 Creating the Attribute Filter
- 9.2.9 Defining a WHERE Clause
- 9.2.10 Choosing an After-Read Strategy
- 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.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.1.1 SKIP LOCKED in Depth
- 9.3.8.1.2 On a Non-Oracle Database
- 9.3.8.1.3 Configuring PollingInterval, MaxTransactionSize, and ActivationInstances in Depth
- 9.3.8.1.4 Partition Field
- 9.3.8.1.5 activationInstances
- 9.3.8.1.6 Indexing and Null Values
- 9.3.8.1.7 Disabling Skip Locking
- 9.3.8.1.8 MarkReservedValue and Skip Locking
- 9.3.8.1.9 SequencingPollingStrategy (Last Read or Last Updated)
- 9.3.8.2 Distributed Polling Second Best Practice: Tuning on a Single Node First
-
9.3.8.1
Distributed Polling First Best Practice: SELECT FOR UPDATE (SKIP LOCKED)
- 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.5 Database Adapter Deployment
-
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.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.2 Supported Third-Party Databases
-
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.5 Run Time: After Stored Procedure Invocation
- 9.7.6 Run Time: Common Third-Party Database Functionality
- 9.7.7 Advanced Topics
-
9.8
Oracle Database Adapter Use Cases
-
9.8.1
Use Cases for Oracle Database Adapter - Stored Procedures
-
9.8.1.1
Creating and Configuring a Stored Procedure in JDeveloper BPEL Designer
- 9.8.1.1.1 Prerequisites
- 9.8.1.1.2 Creating an Application and a SOA Composite
- 9.8.1.1.3 Creating the Outbound Oracle Database Adapter Service
- 9.8.1.1.4 Add an Invoke Activity
- 9.8.1.1.5 Change the Message Part of the Request Message
- 9.8.1.1.6 Change the Message Part of the Response Message
- 9.8.1.1.7 Add a Assign Activity for the Input Variable
- 9.8.1.1.8 Add an Assign Activity for the Output Variable
- 9.8.1.1.9 Deploying with JDeveloper
- 9.8.1.1.10 Creating a DataSource in Oracle WebLogic Server Administration Console
- 9.8.1.1.11 Monitoring Using the Oracle Fusion Middleware Control Console
-
9.8.1.2
File To Stored Procedure Use Case
- 9.8.1.2.1 Prerequisites
- 9.8.1.2.2 Creating an Application and a SOA Project
- 9.8.1.2.3 Creating the Outbound Oracle Database Adapter Service
- 9.8.1.2.4 Creating an Invoke Activity
- 9.8.1.2.5 Creating the Inbound File Adapter Service
- 9.8.1.2.6 Adding a Receive Activity
- 9.8.1.2.7 Adding an Assign Activity
- 9.8.1.2.8 Wiring Services and Activities
- 9.8.1.2.9 Deploying with JDeveloper
- 9.8.1.2.10 Creating a Data Source
- 9.8.1.2.11 Adding a Connection-Instance
- 9.8.1.2.12 Testing Using the File Adapter Service and SQL*Plus
- 9.8.1.2.13 Monitoring Using the Oracle Fusion Middleware Control Console
-
9.8.1.1
Creating and Configuring a Stored Procedure in JDeveloper BPEL Designer
-
9.8.2
Database Adapter/Coherence Integration
- 9.8.2.1 Inserts/Updates to a Database
-
9.8.2.2
Database Adapter/Coherence Integration Architecture
- 9.8.2.2.1 Using Coherence Database Adapter Integration with WebLogic Server 10.3.5
- 9.8.2.2.2 Current Design of the Database Adapter (No Coherence Cache)
- 9.8.2.2.3 Read-Write Coherence Cache Database Adapter Integration
- 9.8.2.2.4 Read Coherence Cache Database Adapter Integration
- 9.8.2.2.5 Enabling No Cache Using the Operations Type Screen
- 9.8.2.2.6 Enabling Read-Write Caching Using the Operation Type Screen
- 9.8.2.2.7 Enabling Read Caching Using the Operation Type Screen
- 9.8.2.2.8 XA Transactions, Read-Write and Read Operations with Coherence/Database Adapter Integration
- 9.8.2.2.9 Coherence Cache Lifecycle and Configuration
- 9.8.2.3 Query by Example
- 9.8.2.4 Modifying the or-mappings.xml File for UTF16 Character Data Insertions
-
9.8.1
Use Cases for Oracle Database Adapter - Stored Procedures
-
10
Oracle JCA Adapter for MQ Series
- 10.1 MQ Series Message Queuing Concepts
- 10.2 Introduction to Native Oracle MQ Series Adapter
- 10.3 Oracle MQ Series Adapter Features
-
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.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 Using the MQ Series Client Channel Definition Table Feature
- 10.4.10 Large Payload Support
- 10.4.11 Attachment Support
-
10.4.1
Messaging Scenarios
-
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.5.4
Selective Dequeue of Messages Using Message Selectors
- 10.5.4.1 Message Selector in the MQ Adapter Configuration Wizard
-
10.5.4.2
Using Message Selectors with MQ
- 10.5.4.2.1 Message Selector Syntax: Literals
- 10.5.4.2.2 Message Selector Identifiers
- 10.5.4.2.3 Message Selector Expressions
- 10.5.4.2.4 Message Selector Operators
- 10.5.4.2.5 Message Selector Comparison
- 10.5.4.2.6 Message Selector Arithmetic
- 10.5.4.2.7 Message Selector Advanced Operators
- 10.5.4.2.8 Message Selector Example
- 10.5.4.2.9 Message Selector Use Case: One BPEL Process Receiving Selective Messages from a MQ Queue using Message Selector
- 10.5.4.2.10 Usage with Sample Messages
- 10.5.4.2.11 Two BPEL Processes Receiving Messages from the Same MQ Queue. Both Processes Have Defined Mutually Exclusive Message Selectors
- 10.5.4.2.12 Creating the Message Selectors for the Two BPEL Process Use Case
- 10.5.4.2.13 Usage with Sample Messages for Two BPEL Process Use Case
-
10.6
Oracle MQ Series Adapter Use Cases
- 10.6.1 Dequeue Enqueue
- 10.6.2 Inbound Synchronous Request-Reply
- 10.6.3 Inbound-Outbound Synchronous Request-Reply
-
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 Oracle Fusion Middleware Control Console
- 10.6.5 Outbound Dequeue
- 10.6.6 Configuring a Backout Queue
- 10.6.7 CCDT Use Cases
- 10.6.8 Reading Single or Multiple RFH2 Rules and Formatting Header Version 2 Headers
- 10.6.9 Processing Messages as Attachment
-
11
Oracle JCA Adapter for UMS
-
11.1
UMS and UMS Adapter Concepts
- 11.1.1 User Messaging Service
- 11.1.2 Oracle UMS Adapter Architecture
- 11.1.3 UMS Adapter Message Concepts
- 11.1.4 Transaction Support
- 11.2 Oracle UMS Adapter Features
-
11.3
Configuring the Oracle UMS Adapter
- 11.3.1 Configuring the Email Driver for the UMS Adapter - Outbound Connectivity
- 11.3.2 Configuring the Email Driver for UMS Adapter - Inbound Connectivity
- 11.3.3 Configuring the Email Driver for the UMS Adapter - Google OAuth 2.0
- 11.3.4 Configuring the Email Driver for the UMS Adapter - Microsoft Azure AD OAuth 2.0
- 11.3.5 Configuring the User Messaging XMPP Driver
- 11.3.6 Configuring the User Messaging SMPP Driver
- 11.3.7 Configuring the HTTP Proxy for Firewall traversal
- 11.3.8 Designing the Adapter Service and the BPEL Process for Inbound Connectivity
- 11.3.9 Designing the Adapter Service and the BPEL Process for Outbound Connectivity
-
11.1
UMS and UMS Adapter Concepts
-
12
Oracle JCA Adapter for LDAP
- 12.1 LDAP Concepts
- 12.2 LDAP Adapter Configurations
-
12.3
Oracle LDAP Adapter Features
- 12.3.1 Configuring the LDAP Adapter
- 12.3.2 JNDI Connection Pool Properties for the LDAP Adapter
- 12.3.3 Outbound Operations
- 12.3.4 Inbound LDAP Adapter Features
- 12.3.5 Logging
- 12.3.6 Security
- 12.3.7 LDAP over SSL
- 12.3.8 Payload Size Threshold
- 12.3.9 High Availability
- 12.3.10 LDAP Adapter Exception Handling
-
13
Oracle JCA Adapter for Microsoft Message Queueing
- 13.1 Oracle JCA Adapter for MSMQ Concepts and Features
- 13.2 MSMQ Adapter Configuration Wizard Flow
- 13.3 MSMQ Use Cases
-
14
Oracle JCA Adapter for Coherence
- 14.1 Oracle Coherence and Oracle JCA Coherence Adapter Concepts
- 14.2 Configuring the Coherence Adapter
- 14.3 Querying Items in the Coherence Cache
- 14.4 Defining Messages for Put, Get and Query Operations if XML is Chosen
- 14.5 Coherence Adapter Files and Artifacts
- 14.6 Tips for Using the Coherence Adapter
- 15 Oracle JCA Adapter for JD Edwards World
-
16
Oracle JCA Adapter for Siebel
- 16.1 Introduction to Oracle JCA Adapter for Siebel
- 16.2 Oracle JCA Adapter for Siebel Concepts
- 16.3 Oracle JCA Adapter for Siebel Features
- 16.4 Design-time and Runtime Functionality of the Oracle JCA Adapter for Siebel
- 16.5 Configuring Oracle JCA Adapter for Siebel
- 16.6 Deploying with JDeveloper
- 16.7 Activating Oracle JCA Adapter for Siebel
- 16.8 Configuring Connection Pooling for Oracle JCA Adapter for Siebel
- 16.9 Oracle JCA Adapter for Siebel Artifacts
-
17
Oracle JCA Adapter Tuning Guide
- 17.1 Oracle JCA Adapter Framework Performance and Tuning
- 17.2 JMS Adapter
- 17.3 AQ Adapter
- 17.4 File/FTP adapter
- 17.5 Database Adapter
-
5
Oracle JCA Adapter for Files/FTP
-
A
Oracle JCA Adapter Properties
- A.1 Generic Oracle JCA Adapter Properties
- A.2 Generic Oracle JCA Adapter Binding Properties
- A.3 Oracle AQ Adapter Properties
- A.4 Coherence Adapter Properties
- A.5 Oracle Database Adapter Properties
- A.6 Oracle File and FTP Adapters Properties
- A.7 Oracle JMS Adapter Properties
- A.8 LDAP Adapter Properties
- A.9 Oracle MQ Series Adapter Properties
- A.10 MSMQ JCA Adapter Properties
- A.11 Oracle Socket Adapter Properties
- A.12 UMS JCA Adapter Properties
- B Oracle JCA Adapter Valves
- C Oracle MQ Series Adapter Supported Encodings