Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• 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
    • Design-Time and Run-time Connection Information
    • Properties of the oc4j-ra.xml File
    • Advanced Properties of the oc4j-ra.xml File
  • 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
    • Using a Microsoft SQL Server Database
    • Using an IBM DB2 Database
    • Using a Sybase Database
    • Using an InterSystems Caché Database
    • Using a MySQL 4 Database
    • Summary of Third-Party and Oracle Lite Database Connection Information
  • 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 OracleAS 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
  • TIMESTAMP Datatype Is Not Supported for a Microsoft SQL Server Database
  • Handling a Database Adapter Fault
  • Table Not Found: SQL Exception
  • Switching from a Development Database to a Production 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
  • ORA-17157: 4K/32K Driver Limit with CLOBs and BLOBs
  • MERGE Sometimes Does UPDATE Instead of INSERT, or Vice Versa
  • Message Loss with the MERGE Invoke Operation
  • 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
  • Problems Importing Object Tables
  • Relationships Not Autogenerated When Tables Are Imported Separately
  • Primary Key Is Not Saved
  • Table Column Name Is a Java Keyword
  • Catching a Database Exception
  • Connection Settings Error: Too Many Transactions
  • ORA-01747: invalid user.table.column, table.column, or column specification, When Using SELECT FOR UPDATE
• 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
• Troubleshooting the Oracle Application Server Adapter for Java Message Service (JMS)
• Summary

Index