Contents

List of Examples

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Introduction

• Database Adapter Overview
• Database Adapter System Requirements
• Hardware Requirements
• Software Requirements

2 Installation and Configuration

• Installing the Database Adapter
• Preinstallation Tasks
• Installation Tasks
• Verification Test
• Installing Multiple Database Adapters in the Same Oracle Home
• Configuring the Database Adapter
• Using the Application Parameter
• Database Adapter Ini File Settings
• hub.ini Parameters
• adapter.ini Parameters
• Uninstalling the Database Adapter

3 Design-Time and Run-Time Concepts

• Database Adapter Design-Time Concepts
• Importing Database Tables and Objects
• Importing Oracle Objects and Advanced Queuing Payloads
• Returned In Arguments
• Deploying PL/SQL Code
• Database Adapter Run-Time Concepts
• How the Database Adapter Works
• Database Sender
• Database Receiver
• Starting the Database Adapter
• Log File of Database Adapter
• Stopping the Database Adapter

4 Sample Use Cases

• Case One: Publish and Subscribe
• Design-Time Steps
• Run-Time Steps
• Related Files
• Case Two: Invoke and Implement
• Synchronous Invoke and Implement
• Design-Time Steps
• Run-Time Steps
• Related Files for Synchronous Invoke Implement
• Asynchronous Invoke and Implement
• Design-Time Steps
• Run-Time Steps
• Related Files for Asynchronous Invoke and Implement

A Frequently Asked Questions

• What should I enter on the Database User Configuration screen during installation?
• How do I secure my passwords?
• Is it possible to edit the database configuration settings created during installation?
• How can I specify a listener port other than 1521?
• If we manually deploy the PL/SQL code, where is the code, exported through iStudio, saved?
• What is the Returned IN Args feature in iStudio and how do I use it?
• How do I deploy PL/SQL code to use with the Database adapter?
• Can database messages contain arrays of arrays?
• When I run start, I do not view anything happening - no log files are created and I don't view any messages in the console - how do I get back to the command prompt?
• Why do I get errors when trying to load PL/SQL code generated through iStudio?
• What are the steps to prepare a Database adapter that publishes events?
• What are the steps to prepare a Database adapter that invokes procedures?
• What are the steps to prepare a Database adapter that subscribes to events?
• What are the steps to prepare a Database adapter that implements procedures?
• How can I deliver a message to a specific partition of the publishing adapter?
• What SQL Data Types are Supported and Not Supported in iStudio?
• My Database adapter is not starting. What could be the reason?
• Database adapter not publishing messages.
• Database adapter not subscribing to messages.

Index