Table of Contents
- Title and Copyright Information
- Preface
-
Part I Introduction and Concepts
- 1 Introduction to Oracle JCA Adapters
-
2
Adapter Framework
- Installing Oracle JCA Adapters
- Starting and Stopping Oracle JCA Adapters
- Defining Adapter Interface by Importing an Existing WSDL
- Configuring Message Header Properties for Oracle JCA Adapters
- Physically Deploying Oracle JCA Adapters
- Creating an Application Server Connection for Oracle JCA Adapters
- Deploying Oracle JCA Adapter Applications from JDeveloper
- Manually Deploying an Adapter RAR File that Does Not Have a Jar File Associated With It
- Handling the Deployment Plan When Working on a Remote Oracle SOA Server
- Migrating Repositories from Different Environments
- Message Ordering
- How Oracle JCA Adapters Ensure No Message Loss
- Composite Availability and Inbound Adapters
- Singleton (Active/Passive) Inbound Endpoint Lifecycle Support Within Adapters
- Correlation Support Within Adapters
- Setting Payload Size Threshold
- Streaming Large Payload
- Batching and Debatching Support
- Adding an Adapter Connection Factory
- Adding or Updating an Adapter Connection Factory
- Recommended Settings for Data Sources Used by Oracle JCA Adapters
-
Error Handling
- Handling Rejected Messages
- Inbound Interaction Error Handling
- Outbound Adapter Interaction Error Handling
- Integrating JCA adapters with Oracle Web Services Manager to Protect Sensitive Data in Audit Trails
- Testing Applications
- Setting the Trace Level of Oracle JCA Adapters
- Viewing Adapter Logs
- Adapter Diagnosability Dumps
- Creating a Custom Adapter
- Advanced Topic: Using the Execution Context ID Across Technologies
- 3 Adapter Integration with Oracle Application Server Components
-
4
Native Format Builder Wizard
- Creating Native Schema Files with the Native Format Builder Wizard
-
Native Schema Constructs
- Understanding Native Schema Constructs
-
Using Native Schema Constructs
- Defining Fixed-Length Data
- Defining Terminated Data
- Defining Surrounded Data
- Defining Lists
-
Defining Arrays
- All Cells Separated by the Same Mark, but the Last Cell Terminated by a Different Mark (Bounded)
- All Cells Separated by the Same Mark, Including the Last Cell (Unbounded)
- Cells Not Separated by Any Mark, but the Last Cell Terminated by a Mark (Bounded)
- The Number of Cells Being Read from the Native Data
- Explicit Array Length
- Conditional Processing
- Defining Dates
- Using Variables
- Defining Prefixes and Suffixes
- Defining Skipping Data
- Defining fixed and default Values
- Defining write
- Defining LookAhead
- Defining Complex Look Ahead Strategies for Conditional Processing of Record Using Regular Expressions
- Defining outboundHeader
- Defining Complex Condition in conditionValue
- Defining Complex Condition in choiceCondition
- Defining dataLines
- Defining Date Formats with Time Zone
- Implementing Validation During Translation
- Processing Files with BOM
- Multi-Byte Translation for Inbound and Outbound Native Data
- SOSI Support
- Translator XPath Functions
-
Use Cases for the Native Format Builder
- Defining the Schema for a Delimited File Structure
- Defining the Schema for a Fixed Length File Structure
- Defining the Schema for a Complex File Structure
- Removing or Adding Namespaces to XML with No Namespace
- Defining the Choice Condition Schema for a Complex File Structure
- Defining Choice Condition With LookAhead for a Complex File Structure
- Defining Array Type Schema for a Complex File Structure
- Defining the Schema for a DTD File Structure
- Defining the Schema for a COBOL Copybook File Structure
- Command Line Tool for Testing NXSD Translator
-
Part II Oracle Technology Adapters
-
5
Oracle JCA Adapter for Files/FTP
- Introduction to Oracle File and FTP Adapters
-
Oracle File and FTP Adapters Features
- File Formats
- FTP Servers
- Inbound and Outbound Interactions
- File Debatching
- File Chunked Read
- File Sorting
- Dynamic Outbound Directory and File Name Specification
- Security
- Nontransactional
- Proxy Support
- No Payload Support
- Large Payload Support
- File-Based Triggers
- Pre-Processing and Post-Processing of Files
- Error Handling
- Threading Model
- Performance Tuning
- High Availability
- Multiple Directories
- Append Mode
- Recursive Processing of Files Within Directories in Oracle FTP Adapter
- Securing Enterprise Information System Credentials
-
Oracle File and FTP Adapter Concepts
- Oracle File Adapter Read File Concepts
-
Oracle File Adapter Write File Concepts
- Outbound Operation
-
Outbound File Directory Creation
- Specifying Outbound Physical or Logical Directory Paths in Oracle BPEL PM
- Specifying Outbound Physical or Logical Directory Paths in Mediator
- Specifying a Dynamic Outbound Directory Name
- Specifying the Outbound File Naming Convention
- Specifying a Dynamic Outbound File Name
- Batching Multiple Outbound Messages
- Native Data Translation
- Outbound Service Files
- Outbound Headers
- Oracle File Adapter Synchronous Read Concepts
- Oracle File Adapter File Listing Concepts
- Oracle FTP Adapter Get File Concepts
- Oracle FTP Adapter Put File Concepts
- Oracle FTP Adapter Synchronous Get File Concepts
- Oracle FTP Adapter File Listing Concepts
- File and FTP Adapter Extensions
-
Configuring Oracle File and FTP Adapters
- Configuring the Credentials for Accessing a Remote FTP Server
- Configuring Oracle File and FTP Adapters for High Availability
- Using Secure FTP with the Oracle FTP Adapter
-
Using SFTP with the Oracle FTP Adapter
- SFTP Overview
- Install and Configure OpenSSH for Windows
-
Set Up Oracle FTP Adapter for SFTP
- Configuring Oracle FTP Adapter for Password Authentication
- Configuring Oracle FTP Adapter for Public Key Authentication
- Configuring OpenSSH for Public-Key Authentication
- Configuring Oracle FTP Adapter for Public Key Authentication with OpenSSH Running Inside a Firewall
- Configuring Oracle FTP Adapter for Public Key Authentication with OpenSSH Running Outside a Firewall
- Configuring for WINSSHD Servers
- Enabling FIPS Compliance in Oracle File and FTP Adapters
- Configuring Oracle FTP Adapter for HTTP Proxy
- Configuring File and FTP Adapters for High Availability
-
Oracle File and FTP Adapters Use Cases
-
Oracle File Adapter XML Debatching
- Prerequisites
- Splitting an Input XML Document that Contains Repeating Element
- Designing the SOA Composite
- Creating the Inbound Oracle File Adapter Service
- Creating the Outbound Oracle File Adapter Service
- Wiring Services and Activities
- Deploying with JDeveloper
- Monitoring Using the Oracle Fusion Middleware Control Console
- Flat Structure for Oracle BPEL PM
- Flat Structure for Mediator
- Oracle File Adapter Scalable DOM
- Oracle File Adapter Chunked Read
- Oracle File Adapter Read File As Attachments
- Oracle File Adapter File Listing
- Oracle File Adapter Complex Structure
- Oracle FTP Adapter Debatching
- Oracle FTP Adapter Dynamic Synchronous Read
-
Copying, Moving, and Deleting Files
- Moving a File from a Local Directory on the File System to Another Local Directory
- Copying a File from a Local Directory on the File System to Another Local Directory
- Deleting a File from a Local File System Directory
- Moving a File from One Remote Directory to Another Remote Directory on the Same FTP Server
- Moving a File from a Local Directory on the File System to a Remote Directory on the FTP Server
- Moving a File from a Remote Directory on the FTP Server to a Local Directory on the File System
- Moving a File from One FTP Server to another FTP Server
- Creating a Synchronous BPEL Composite using File Adapter
- Changing the Sequencing Strategy for FILE/FTP Adapter
- Controlling the Order in which Files Are Processed
-
Extending FTP Adapter
- Use Case: FTP Adapter Extension of FTP Client Login
- Use Case: Configuring the FTP Adapter to Handle Response from MLSD Command
- Use Case: Extend the Listing Operation to Send MLSD Commands Rather Than the LIST Commands
- Use Case: Extend the Store Operation to Send Additional Proprietary FTP Commands to FTP Server Running on the MVS Platform
- Additional Configuration Parameters, Implementations, Interfaces and Schema
- FtpListResponseParser Interface
- FtpTimestampParser Interface
- ftpmapping Schema
-
Oracle File Adapter XML Debatching
-
6
Oracle JCA Adapter for Sockets
- Introduction to Oracle Socket Adapter
- Oracle Socket Adapter Features
- Oracle Socket Adapter Concepts
-
Configuring Oracle Socket Adapter
- Modifying the weblogic-ra.xml File
- Modeling a Handshake
- Designing an XSL File Using the XSL Mapper Tool
- Specifying a TCP Port in a Configuration Plan For an Oracle Socket Adapter
- Enabling Oracle Socket Adapter to Accept Multiple Requests
- Java Script Support
- Oracle Socket Adapter NIO Support
- SSL Support for the Socket Adapter
- Cluster Support for Socket Adapter
-
Oracle Socket Adapter Use Cases
- Oracle Socket Adapter Hello World
- Flight Information Display System
-
7
Oracle JCA Adapter for AQ
- Introduction to the Oracle AQ Adapter
-
Oracle AQ Adapter Features
- Enqueue-Specific Features (Message Production)
- Dequeue and Enqueue Features
- Synchronous Request-Response
- Synchronous Dequeue
- Supported ADT Payload Types
- Native Format Builder Wizard
- Normalized Message Support
- Is DOM 2 Compliant
- Is Message-Size Aware
- Multiple Receiver Threads
- DequeueTimeout Property
- Control Dequeue Timeout and Multiple Inbound Polling Threads
- Stream Payload Support
- Oracle AQ Adapter Inbound Retries
- Error Handling Support
- Performance Tuning
- Oracle AQ Adapter Deployment
-
Oracle AQ Adapter Use Cases
- Generic Use Cases
-
Oracle AQ Adapter ADT Queue
- Prerequisites
- Creating an Application and a SOA Project
- Creating an Inbound Oracle AQ Adapter
- Creating an Outbound Oracle AQ Adapter
- Wiring Services and Activities
- Configuring Routing Service
- Configuring the Data Sources in the Oracle WebLogic Server Administration Console
- Deploying with JDeveloper
- Monitoring Using the Oracle Fusion Middleware Control Console
-
Oracle AQ Adapter RAW Queue
- Prerequisites
- Creating an Application and a SOA Project
- Creating an Inbound Adapter Service
- Creating an Outbound Adapter Service
- Wiring Services and Activities
- Configuring the Data Sources in the Oracle WebLogic Server Administration Console
- Deploying with JDeveloper
- Monitoring Using the Oracle Fusion Middleware Control Console
-
8
Oracle JCA Adapter for JMS
- Introduction to the Oracle JMS Adapter
- Oracle JMS Adapter Features
- Oracle JMS Adapter Concepts
-
Oracle JMS Adapter Use Cases
- Configuring Oracle JMS Adapter
- Configuring the Oracle JMS Adapter with TIBCO JMS
- Configuring Oracle JMS Adapter with IBM WebSphere MQ JMS
- Configuring Oracle JMS Adapter with Active MQ JMS
- WebLogic Server JMS Text Message
- Accessing Queues and Topics from WLS JMS Server in a Remote Oracle WebLogic Server Domain
- Synchronous/Asynchronous Request Reply Interaction Pattern
- AQ JMS Text Message
- Accessing Queues and Topics Created in 11g from the OC4J 10.1.3.4 Server
- Configuring the 11G Server or Later Server to Access Queues Present in 10.1.3.X OC4J
- Accessing Distributed Destinations (Queues and Topics) on the WebLogic Server JMS
- Configuring Oracle JMS Adapter with IBM WebSphere Default JMS Provider
- Configuring Request-Reply in the JMS Adapter
- Using the WLS JMS Unit-Of-Order with the JMS Adapter
- JMS Synchronous Consume
-
9
Oracle JCA Adapter for Database
- Introduction to the Oracle Database Adapter
-
Complete Walkthrough of the Database Adapter Configuration Wizard
- Creating an Application and a SOA Project
- Defining an Oracle Database Adapter
- Connecting to a Database
- Selecting the Operation Type
- Selecting and Importing Tables
- Defining Primary Keys
- Creating Relationships
- Creating the Attribute Filter
- Defining a WHERE Clause
- Choosing an After-Read Strategy
- Specifying Polling Options
- Specifying Advanced Options
- Entering the SQL String for the Pure SQL Operation
-
Oracle Database Adapter Features
- Transaction Support
- Pure SQL - XML Type Support
- Row Set Support Using a Strongly or Weakly Typed XSD
- Proxy Authentication Support
- Streaming Large Payload
- Schema Validation
- High Availability
-
Scalability
-
Distributed Polling First Best Practice: SELECT FOR UPDATE (SKIP LOCKED)
- SKIP LOCKED in Depth
- On a Non-Oracle Database
- Configuring PollingInterval, MaxTransactionSize, and ActivationInstances in Depth
- Partition Field
- activationInstances
- Indexing and Null Values
- Disabling Skip Locking
- MarkReservedValue and Skip Locking
- SequencingPollingStrategy (Last Read or Last Updated)
- Distributed Polling Second Best Practice: Tuning on a Single Node First
-
Distributed Polling First Best Practice: SELECT FOR UPDATE (SKIP LOCKED)
- Performance Tuning
- detectOmissions Feature
- OutputCompletedXml Feature
- QueryTimeout for Inbound and Outbound Transactions
- Doing Synchronous Post to BPEL (Allow In-Order Delivery)
- Oracle Database Adapter Concepts
- Database Adapter Deployment
-
JDBC Driver and Database Connection Configuration
- Creating a Database Connection Using a Native or Bundled Oracle WebLogic Server JDBC Driver
- Creating a Database Connection Using a Third-Party JDBC Driver
- Summary of Third-Party JDBC Driver and Database Connection Information
- Location of JDBC Driver JAR Files and Setting the Class Path
- Stored Procedure and Function Support
-
Oracle Database Adapter Use Cases
-
Use Cases for Oracle Database Adapter - Stored Procedures
-
Creating and Configuring a Stored Procedure in JDeveloper BPEL Designer
- Prerequisites
- Creating an Application and a SOA Composite
- Creating the Outbound Oracle Database Adapter Service
- Add an Invoke Activity
- Change the Message Part of the Request Message
- Change the Message Part of the Response Message
- Add a Assign Activity for the Input Variable
- Add an Assign Activity for the Output Variable
- Deploying with JDeveloper
- Creating a DataSource in Oracle WebLogic Server Administration Console
- Monitoring Using the Oracle Fusion Middleware Control Console
-
File To Stored Procedure Use Case
- Prerequisites
- Creating an Application and a SOA Project
- Creating the Outbound Oracle Database Adapter Service
- Creating an Invoke Activity
- Creating the Inbound File Adapter Service
- Adding a Receive Activity
- Adding an Assign Activity
- Wiring Services and Activities
- Deploying with JDeveloper
- Creating a Data Source
- Adding a Connection-Instance
- Testing Using the File Adapter Service and SQL*Plus
- Monitoring Using the Oracle Fusion Middleware Control Console
-
Creating and Configuring a Stored Procedure in JDeveloper BPEL Designer
-
Database Adapter/Coherence Integration
- Inserts/Updates to a Database
-
Database Adapter/Coherence Integration Architecture
- Using Coherence Database Adapter Integration with WebLogic Server 10.3.5
- Current Design of the Database Adapter (No Coherence Cache)
- Read-Write Coherence Cache Database Adapter Integration
- Read Coherence Cache Database Adapter Integration
- Enabling No Cache Using the Operations Type Screen
- Enabling Read-Write Caching Using the Operation Type Screen
- Enabling Read Caching Using the Operation Type Screen
- XA Transactions, Read-Write and Read Operations with Coherence/Database Adapter Integration
- Coherence Cache Lifecycle and Configuration
- Query by Example
- Modifying the or-mappings.xml File for UTF16 Character Data Insertions
-
Use Cases for Oracle Database Adapter - Stored Procedures
-
10
Oracle JCA Adapter for MQ Series
- MQ Series Message Queuing Concepts
- Introduction to Native Oracle MQ Series Adapter
- Oracle MQ Series Adapter Features
-
Oracle MQ Series Adapter Concepts
-
Messaging Scenarios
- Enqueue Message
- Dequeue Message
- Asynchronous Request-Response (Oracle BPEL PM As Client)
- Synchronous Request-Response (Oracle BPEL PM As Server)
- Asynchronous Request-Response (Oracle BPEL PM As Server)
- Synchronous Request-Response (Mediator As Server)
- Synchronous Request-Response (Oracle BPEL PM As Client)
- Synchronous Request-Response (Oracle Mediator as Client)
- Asynchronous Request-Response (Oracle Mediator As Client)
- Outbound Dequeue Scenario
- Message Properties
- Correlation Schemas
- Distribution List Support
- Report Messages
- Message Delivery Failure Options
- Message Segmentation
- Integration with CICS
- Using the MQ Series Client Channel Definition Table Feature
- Large Payload Support
- Attachment Support
-
Messaging Scenarios
-
Configuring the Oracle MQ Series Adapter
- Adding jar Files to the Oracle MQ Series Adapter Classpath: MQ Series 7.5, 8, and 9
- Adding JNDI Entry
- Enabling Binding Mode for Connections
-
Selective Dequeue of Messages Using Message Selectors
- Message Selector in the MQ Adapter Configuration Wizard
-
Using Message Selectors with MQ
- Message Selector Syntax: Literals
- Message Selector Identifiers
- Message Selector Expressions
- Message Selector Operators
- Message Selector Comparison
- Message Selector Arithmetic
- Message Selector Advanced Operators
- Message Selector Example
- Message Selector Use Case: One BPEL Process Receiving Selective Messages from a MQ Queue using Message Selector
- Usage with Sample Messages
- Two BPEL Processes Receiving Messages from the Same MQ Queue. Both Processes Have Defined Mutually Exclusive Message Selectors
- Creating the Message Selectors for the Two BPEL Process Use Case
- Usage with Sample Messages for Two BPEL Process Use Case
-
Oracle MQ Series Adapter Use Cases
- Dequeue Enqueue
- Inbound Synchronous Request-Reply
- Inbound-Outbound Synchronous Request-Reply
-
Asynchronous-Request-Reply
- Prerequisites
- Designing the SOA Composite
- Creating an Inbound Adapter Service
- Creating an Asynchronous Outbound Request Reply Adapter Service Outbound
- Creating Another Outbound Adapter Service
- Wiring Services and Activities
- Deploying with JDeveloper
- Monitoring Using the Oracle Fusion Middleware Control Console
- Outbound Dequeue
- Configuring a Backout Queue
- CCDT Use Cases
- Reading Single or Multiple RFH2 Rules and Formatting Header Version 2 Headers
- Processing Messages as Attachment
-
11
Oracle JCA Adapter for UMS
- UMS and UMS Adapter Concepts
- Oracle UMS Adapter Features
-
Configuring the Oracle UMS Adapter
- Configuring the Email Driver for the UMS Adapter - Outbound Connectivity
- Configuring the Email Driver for UMS Adapter - Inbound Connectivity
- Configuring the Email Driver for the UMS Adapter - Google OAuth 2.0
- Configuring the Email Driver for the UMS Adapter - Microsoft Azure AD OAuth 2.0
- Configuring the User Messaging XMPP Driver
- Configuring the User Messaging SMPP Driver
- Configuring the HTTP Proxy for Firewall traversal
- Designing the Adapter Service and the BPEL Process for Inbound Connectivity
- Designing the Adapter Service and the BPEL Process for Outbound Connectivity
-
12
Oracle JCA Adapter for LDAP
- LDAP Concepts
- LDAP Adapter Configurations
- Oracle LDAP Adapter Features
-
13
Oracle JCA Adapter for Microsoft Message Queueing
- Oracle JCA Adapter for MSMQ Concepts and Features
- MSMQ Adapter Configuration Wizard Flow
- MSMQ Use Cases
- 14 Oracle JCA Adapter for Coherence
- 15 Oracle JCA Adapter for JD Edwards World
-
16
Oracle JCA Adapter for Siebel
- Introduction to Oracle JCA Adapter for Siebel
- Oracle JCA Adapter for Siebel Concepts
- Oracle JCA Adapter for Siebel Features
- Design-time and Runtime Functionality of the Oracle JCA Adapter for Siebel
- Configuring Oracle JCA Adapter for Siebel
- Deploying with JDeveloper
- Activating Oracle JCA Adapter for Siebel
- Configuring Connection Pooling for Oracle JCA Adapter for Siebel
- Oracle JCA Adapter for Siebel Artifacts
-
17
Oracle JCA Adapter Tuning Guide
- Oracle JCA Adapter Framework Performance and Tuning
- JMS Adapter
- AQ Adapter
- File/FTP adapter
- Database Adapter
- 18 Apache Kafka Adapter
-
5
Oracle JCA Adapter for Files/FTP
-
A
Oracle JCA Adapter Properties
- JCA Endpoint Properties in the Adapter Configuration Wizard
- Generic Oracle JCA Adapter Properties
- Generic Oracle JCA Adapter Binding Properties
- Oracle AQ Adapter Properties
- Coherence Adapter Properties
- Oracle Database Adapter Properties
- Oracle File and FTP Adapters Properties
- Oracle JMS Adapter Properties
- LDAP Adapter Properties
- Oracle MQ Series Adapter Properties
- MSMQ JCA Adapter Properties
- Oracle Socket Adapter Properties
- UMS JCA Adapter Properties
- B Oracle JCA Adapter Valves
- C Oracle MQ Series Adapter Supported Encodings