• User's Guide
  • Important Information
  • TIBCO Documentation and Support Services
  • Product Overview
  • Getting Started
    • Tables and Data Flow
    • TIBCO Business Studio Overview
    • Creating Database Tables
    • Creating a Project
    • Creating a Database Connection
    • Creating Adapter Configurations
    • Adding the Database Connection
    • Adding Adapter Services
    • Specifying a Working Directory
    • Starting the Adapter Configurations
    • Changing the Table Values and Receiving a Notification
    • Removing the Tables from a Database
  • Working with an Adapter Configuration
    • Creating an Adapter Configuration
    • Configuring an Adapter Configuration
  • Adapter Configuration Reference
    • Configuration Tab
      • Guidelines for Choosing an Instance ID
      • New Connection Information
      • Default Schema
    • Adapter Services Tab
    • Transports Tab
      • Sessions for the TIBCO Rendezvous Transport Type
      • Sessions for the JMS Transport Type
      • Session Reference
      • Endpoint Reference
    • Logging Tab
      • Log Level Panel
      • Supported Log Sinks and Roles
      • Log Sink Configuration Reference
    • Monitoring Tab
    • Advisories Tab
    • Advanced Tab
  • Creating and Configuring Publication Service
    • Creating Publication Service
    • Fetching a Table for Publication Service
      • Fetching a Table When Creating Publication Service
      • Fetching a Table After Creating Publication Service
    • Specifying a Publishing Table
    • Specifying a Polling Method
    • Selecting a Storage Mode
    • Enabling Loop Detection
  • Creating and Configuring Subscription Service
    • Creating Subscription Service
    • Fetching a Table for Subscription Service
      • Fetching a Table When Creating Subscription Service
      • Fetching a Table After Creating Subscription Service
    • Specifying an Exceptions Table
    • Configuring an Exceptions Table as a Source Table
    • Specifying an Opaque Exceptions Table
    • Specifying a Precommit Stored Procedure Call
    • Configuring a Subscriber Reply Sender
  • Creating and Configuring Request-Response Service
    • Request-Response Implementation
      • Requests
      • Responses
    • Creating Request-Response Service
    • Fetching a Schema Object for Custom RPC Service
      • Procedure Schema Information Reference
    • Selecting a Service Mode
      • Using RPC Mode
        • Standard RPC Operation
        • Custom RPC Operation
    • Using Quotes in Microsoft SQL Server
    • Using the REF Data Type with Oracle Databases
  • Adapter Service Reference
    • Configuration Tab
      • Transport Options
        • Guideline for Configuring the Wire Format
        • Guideline for Configuring the Delivery Mode (JMS Only)
      • Class Reference
    • Schema Tab
    • Publication Options Tab
    • DB2/390 Options Tab
    • DB2/AS400 Options Tab
    • Schema Tab
    • Subscription Options Tab
    • Child Table Mappings Tab
    • Child Exception Table Mappings Tab
    • DB2/390 Options Tab
    • Schema Tab
    • Request-Response Options Tab
  • Working with Parent-Child Table Relationships
    • Adding Child Tables in Publication Service
    • Adding Child Tables in Subscription Service
    • Mapping Child Tables in Publication Service and Subscription Service
  • Working with Schema Browser
    • Adding a Destination
    • Fetching Tables and Stored Procedures
      • Fetching Tables
      • Fetching Child Tables
      • Fetching Stored Procedures
      • Referencing an External Schema
    • Replicating Schema Information
  • Table Reference
    • Publishing Table
    • Source Table
    • Exceptions Table
    • Child Exceptions Table
    • Opaque Exceptions Table
    • Incremental Parent-Child Operation
    • Supported Data Types
      • DB2
      • Microsoft SQL Server
      • MySQL
      • Oracle
      • PostgreSQL
      • Sybase and Sybase Adaptive Server Anywhere
      • Teradata
  • Working with BusinessWorks Processes
    • Creating a Business Process
    • Testing a Specified BusinessWorks Process
    • Testing Multiple BusinessWorks Processes in Multiple Applications
    • Activities for Communicating with Adapter Services
    • Handling the anyType AE Data Type
  • Migrating an Adapter Project Created in TIBCO Designer
    • Calling a Process That Uses the Start Activity
  • Working with an Alerter
    • Alerter Process
    • Alerter Object Types and Stored Procedures
    • Starting an Alerter
    • Example for Starting an Oracle Alerter
    • Example for Starting a Microsoft SQL Server Alerter
  • Multithreading
    • Configuring Multithreading for Publication Service
    • Configuring Multithreading for Subscription Service
      • Multithreading and Session in Subscription Service
      • Multithreading and Tables for Subscription Service
    • Configuring Multithreading for Request-Response Service
      • Multithreading and Session in Request-Response Service
  • Advanced Operations
    • Starting an Adapter Configuration with Adapter Launcher
    • Configuring Load Balancing
      • Configuring Load Balancing in Publication Service
        • Creating an Adapter for Database Connection
        • Creating Publication Adapter Configurations
        • Creating Services of Publication Service
        • Configuring Load Balancing for Publication Service
      • Configuring Load Balancing in Subscription Service and Request-Response Service
        • Example for Configuring Load Balancing in Subscription Service
          • Creating an Adapter for Database Connection (Subscription Service)
          • Creating Subscription Adapter Configurations
          • Creating Services of Subscription Service
          • Configuring Load Balancing for Subscription Service
        • Example for Configuring Load Balancing in Custom RPC Service
    • Batch Processing
      • Batch Processing in Publication Service
      • Batch Processing in Subscription Service
    • Configuring Batch Commit for Subscription Service
    • Handling Passwords
    • Subject and Destination Names
    • Preregistering a Certified Subscriber
      • Preregistering in TIBCO Business Studio
      • Setting Preregistered Listeners in TRA Properties File
    • Changing the Location of the Ledger File
      • Configuring in TIBCO Business Studio
      • Modifying the TRA Properties File
    • Sending DateTime Data to an Adapter Configuration
    • Using the User Callout Java Library
      • Adding a User Library in a Project
      • Adding a Java Package and Class
      • Using the adbPreCommit Function
      • Using the alterMsgPub() and alterMsgSub() Functions
      • Exporting the JAR File
      • Replacing the Original JAR File
    • Using Database Deployment and Cleanup Scripts
    • OS Authentication
    • Runtime Schema
    • Runtime Table Schema Configuration
    • Specifying Query Timeout
    • Compressing JMS Messages
    • Configuring RVCMQ Backlog Size
    • Implementing Refresh Connection
    • Error Handling by Subscription Service
      • Prerequisites of Using Bulk Insert Error Handling
      • Working with Bulk Insert Error Handling
    • Using Opcodes to Set Operations for Subscription Service
    • Configuring Publish by Reference Object
      • Specifying a Referred Object
      • Changing Repository Objects for Parent-Child Table Relationships
        • Adding a Sequence
        • Adding an Association
    • Setting Maximum Rows in the Operation Level
    • Using Hints (Publication Service Only)
    • Configuring the Internal Message Queue
  • Frequently Asked Questions
    • General Questions and Answers
    • Request-Response Service Questions and Answers
  • Using Module Properties
    • Configuring Module Properties
    • Defining a Module Property with a Combined Value
    • Predefined Module Properties
  • Adapter Properties File
    • Adapter Properties
  • Trace Messages
    • Trace Message Examples
    • Trace Message Fields
    • Trace Messages Reference
  • Adapter Microagents and Methods
    • Adapter Microagents
    • Available TIBCO Hawk Methods
      • getEventQueueSize()
      • setDebugLevel()
      • toggleVerboseFlag()
      • showConfiguration()
      • terminateADBagent()
      • getPollingInterval()
      • setPollingInterval()
      • getPollingBatchSize()
      • setPollingBatchSize()
      • getActivityStatistics()
      • getActivityStatisticsByService
      • getActivityStatisticsByOperation()
      • getThreadStatistics()
      • getQueueStatistics()
      • getConnectionStatistics()
      • resetActivityStatistics()
      • resetThreadStatistics()
      • resetConnectionStatistics()
• Examples
  • Important Information
  • TIBCO Documentation and Support Services
  • Examples Overview
  • Prerequisites for Running Examples
    • Migrating Examples to TIBCO Business Studio
    • Calling a Process for a BusinessWorks 5 Example
    • Importing Examples to TIBCO Business Studio
    • Required Software
    • Starting the EMS Server
  • Working Through the Demo1 Example
    • Creating the Demo Tables
    • Specifying a Working Directory
    • Updating the Database Connection
    • Starting the Adapter Configurations
    • Inserting Data into the Source Table
    • Cleaning up the Database
  • Working Through the Operations Example
    • Sample Request Program
    • Creating the Demo Tables
    • Starting the Adapter
    • Testing the Example
      • Testing the RPC Standard Operation
      • Testing the RPC Custom Operation
      • Testing the Request-Reply Operation
    • Cleaning up the Example
  • Working Through the SalesOrder Example
    • Creating the Demo Tables
    • Starting the Adapter
    • Testing the Example
    • Cleaning up the Example
• Installation
  • Important Information
  • TIBCO Documentation and Support Services
  • Installation Overview
    • Installation Modes
    • Installation Environment
    • Installation Components
  • Installation Requirements
    • Installation Account
    • System Requirements
  • Preinstallation Tasks
  • Installation
    • Installing in GUI Mode
    • Installing in Console Mode
    • Installing in Silent Mode
  • Uninstallation
    • Uninstalling in GUI Mode
    • Uninstalling in Console Mode
  • Installation Logging