Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documentation
• Conventions

1 Introduction to Oracle Adapters for Files, FTP, Databases, and Enterprise Messaging

• Overview of Oracle BPEL Process Manager Technology Adapters
• Summary

2 Oracle Application Server Adapter for Files/FTP

• Introduction to the File and FTP Adapters
• File and FTP Adapter Features
• File and FTP Adapter Architecture
• File and FTP Adapter Integration with Oracle BPEL Process Manager
• File and FTP Adapter Concepts
• File Adapter Read File Concepts
• Inbound Operation
• Inbound File Directory Specifications
• File Matching and Batch Processing
• File Polling
• File Processing
• Postprocessing
• Native Data Translation
• Error Handling
• Guaranteed Delivery and Recovery from Server Failures
• Inbound Service Name WSDL File
• Inbound Header WSDL File
• Synchronous File Reading Capabilities
• File Adapter Write File Concepts
• Outbound Operation
• Outbound File Directory Creation
• Native Data Translation
• Error Handling
• Outbound Service Name WSDL File
• Outbound Header WSDL File
• FTP Adapter for Get File Concepts
• FTP Adapter for Put File Concepts
• Using Secure FTP with the FTP Adapter
• Secure FTP Overview
• Installing and Configuring OpenSSL
• Installing and Configuring vsftpd
• Creating an Oracle Wallet
• Setting Up the FTP Adapter
• Use Cases for the File and FTP Adapters
• File Adapter Use Cases
• File Reading
• Message Debatching
• Reading Delimited Content Files
• Reading Positional (Fixed Length) Content Files
• File Writing
• FTP Adapter Use Case
• Summary

3 Oracle Application Server Adapter for Advanced Queuing

• Introduction to the AQ Adapter
• AQ Adapter Features
• Enqueue-Specific Features (Message Production)
• Dequeue and Enqueue Features
• Supported ADT Payload Types
• Native Format Builder Wizard
• Use Cases for the AQ Adapter
• Adapter Configuration Wizard Walkthrough
• Generated WSDL file
• Dequeuing and Enqueuing Object and ADT Payloads
• Dequeuing One Column of the Object/ADT Payload
• Processing Large Numbers of Messages
• Using Correlation ID for Filtering Messages During Dequeue
• Enqueuing and Dequeuing from Multisubscriber Queues
• Rule-Based Subscription for Multiconsumer Queues
• Using AQ Headers in a BPEL Process
• Header Variables in JDeveloper BPEL Designer
• Configuring a Message Rejection Handler for Data Errors
• Summary

4 Oracle Application Server Adapter for Databases

• Introduction to the Database Adapter
• Database Adapter Features
• Design Overview
• Database Adapter Concepts
• Relational-to-XML Mapping
• Relational Types to XML Schema Types
• Mapping Any Relational Schema to Any XML Schema
• SQL Operations as Web Services
• DML Operations
• Polling Strategies
• Use Cases for the Database Adapter
• The Adapter Configuration Wizard
• Starting the Adapter Configuration Wizard
• Connecting to a Database
• Selecting the Operation Type
• Selecting and Importing Tables
• Defining Primary Keys
• Creating Relationships
• What Happens When Relationships Are Created or Removed
• Different Types of One-to-One Mappings
• Creating the Object Model
• Defining a WHERE Clause
• Choosing an After-Read Strategy
• Delete the Rows that Were Read
• Update a Field in the Table (Logical Delete)
• Update a Sequencing Table
• Internal Processes at Design Time
• Importing Tables
• Creating Relationships
• Generating Design-Time Artifacts
• Advanced Configuration
• The OracleAS TopLink Mapping Workbench Project
• Deleting a Descriptor
• Returning Partial Objects When Querying
• Renaming a Mapping
• Configuring Offline Database Tables
• Relational-to-XML Mappings (toplink_mappings.xml)
• The Service Definition (WSDL)
• DBWriteInteractionSpec
• DBReadInteractionSpec
• DBActivationSpec
• XML Schema Definition (XSD)
• Deployment
• Location of the oc4j-ra.xml File
• Advanced Properties
• Performance
• Outbound Write: Should You Use Merge, Write, or Insert?
• The OracleAS TopLink Cache: When Should You Use It?
• Existence Checking
• Inbound (Polling): maxRaiseSize
• Inbound (Polling): Choosing a Polling Strategy
• Relationship Reading (Batch Attribute and Joined Attribute Reading)
• Connection Pooling
• Inbound Distributed Polling
• Third-Party Database Support
• Design Time
• Notes on Using SQL Server
• Notes on Using Oracle Olite
• Run Time
• Stored Procedure and Function Support
• Design Time: Using the Adapter Configuration Wizard
• Using Top-Level Standalone APIs
• Using Packaged APIs and Overloading
• Design Time: WSDL and XSD Generation
• The WSDL–XSD Relationship
• Supported Primitive Datatypes
• Generated XSD Attributes
• User-Defined Types
• Complex User-Defined Types
• Object Type Inheritance
• Object References
• Referencing Types in Other Schemas
• Run Time: Before Stored Procedure Invocation
• Value Binding
• Datatype Conversions
• Run Time: After Stored Procedure Invocation
• Datatype Conversions
• Null Values
• Function Return Values
• Advanced Topics
• Support for REF CURSOR
• Support for PL/SQL Boolean, PL/SQL Record, and PL/SQL Table Types
• Default Clauses in Wrapper Procedures
• Use Case for Creating and Configuring a Stored Procedure in JDeveloper BPEL Designer
• Creating a Stored Procedure
• Creating a Database Connection
• Creating a Workspace and a Greeting Process
• Creating a Partner Link
• Creating an Invoke Activity
• Creating an Initial Assign Activity
• Creating a Second Assign Activity
• Validating, Compiling, and Deploying the Greeting Process
• Running the Greeting Process
• Summary

5 Oracle Application Server Adapter for Java Message Service

• Introduction to the JMS Adapter
• JMS Adapter Features
• Use Cases for the JMS Adapter
• Concepts
• Using the Adapter Configuration Wizard to Configure a JMS Adapter
• Generated WSDL File
• oc4j-ra.xml file
• Produce Message Procedure
• Configuring for OJMS
• Configuring for OC4J JMS
• Configuring for TIBCO JMS
• Direct Connection
• Configuring for IBM Websphere JMS
• Summary

6 Native Format Builder Wizard

• Creating Native Schema Files with the Native Format Builder Wizard
• Supported Formats
• Delimited (such as CSV files)
• Fixed Length (Positional)
• DTD
• COBOL Copybook
• Native Format Builder Wizard Windows
• Understanding Native Schema
• Use Cases for the Native Format Builder
• Defining a Comma-Separated Value File Structure
• Defining a * Separated Value File Structure
• Defining a Fixed Length Structure
• Defining a More Complex Structure - Invoice
• Using the Native Format Translator for removing or adding namespaces to XML with no namespace
• COBOL Copybook
• Native Schema Constructs
• Defining Fixed Length Data
• Defining Terminated Data
• Defining Surrounded Data
• Defining Lists
• Defining Arrays
• Conditional Processing
• Defining Dates
• Using Variables
• Native Schema Constructs
• Summary

A Troubleshooting and Workarounds

• Troubleshooting the Oracle Application Server Adapter for Databases
• Could Not Create OracleAS TopLink Session Exception
• Could Not Find Adapter for eis/DB/my_connection
• Changes Through TopLink Mapping Workbench
• Redeploying from the Command Line
• Cannot Change Customers_table.xsd
• No Target Foreign Keys Error
• No Primary Key Exception
• dateTime Conversion Exceptions
• Issues with Oracle DATE
• Handling a Database Adapter Fault
• BPEL Process Does Not Run Against Another Database
• Only One Employee Per Department Appears
• Outbound SELECT on a CHAR(X) or NCHAR Column Returns No Rows
• ORA-00932: Inconsistent Datatypes Exception Querying CLOBs
• Merge Sometimes Does UPDATE Instead of INSERT, or Vice Versa
• Integrity Violation Occurs with Delete or DeletePollingStrategy
• Some Queried Rows Appear Twice or Not at All in the Query Result
• Importing a Same-Named Table, with Same Schema Name, but Different Databases
• Problems Creating a Relationship Manually for a Composite Primary Key
• Must Fully Specify Relationships Involving Composite Primary Keys
• Database Adapter Throws an Exception When Using a BFILE
• During Design-Time, Wizard Does Not Allow Deletion of a Table
• Changes to JDeveloper Project Are Made Even If Wizard Is Cancelled
• Problems Removing a Relationship, Then Adding a New Relationship with the Same Name
• Problems Importing Third-Party Database Tables with Unsupported Database Types
• Problems Importing Object Tables
• Relationships Not Autogenerated When Tables Are Imported Separately
• Primary Key Is Not Saved
• Table Column Name Is a Java Keyword
• Troubleshooting the Oracle Application Server Adapter for Databases When Using Stored Procedures
• Design Time: Unsupported or Undefined Parameter Types
• Design Time: Referencing User-Defined Types in Other Schemas
• Run Time: Parameter Mismatches
• Run Time: Stored Procedure Not Defined in the Database
• Troubleshooting the Oracle Application Server Adapter for Files/FTP
• Changing Logical Names with the Adapter Configuration Wizard
• Creating File Names with Spaces with the Native Format Builder Wizard
• Common User Errors
• Troubleshooting the Oracle Application Server Adapter for Advanced Queuing
• Inbound Errors
• JNDI Lookup Failed
• During Initialization, I/O Exception: Network Adapter Did Not Establish the Connection
• Incorrect Username/Password
• Queue Not Found
• User Does Not Have DBMS_AQIN Privileges, Which Are Required by the AQ Java API
• Translation Error
• Subscriber Already Exists When Using MessageRuleSelector
• Outbound Errors
• JNDI Lookup Failed
• I/O Exception: Network Adapter Could Not Establish the Connection
• Queue Not Found
• Incorrect Username/Password
• User Does Not Have DBMS_AQIN Privileges, Which Are Required by the AQ Java API
• Translation Error
• JDeveloper BPEL Designer Errors
• Translation Error
• Other Problems
• Summary

Index