My Oracle Support Banner

Messaging Gateway / MQ Series Sample 2: Two Propagation Jobs - AQ Queue to MQ Series and MQ Series to an AQ Queue (Doc ID 215982.1)

Last updated on MAY 10, 2024

Applies to:

Oracle Database - Enterprise Edition
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Purpose

The second sample sets up two propagation schedules. One from an AQ queue to
an MQSeries queue, and one from that same MQSeries queue back to a different
AQ queue. The AQ queues accept payloads of type sampleADT.

Sample transformations are provided and registered with the Messaging
Gateway for transforming the payload to the Messaging Gateway canonical type,
MGW_BASIC_MSG_T, on an outbound propagation, and for transforming the
MGW_BASIC_MSG_T to a sampleADT payload on an inbound propagation.

All Messaging Gateway samples are located in the default directory of:
ORACLE_HOME/mgw/samples/aq2mq

The second sample requires the following files: samples_init.sql,
sample_common_setup.sql, sample2_setup.sql, sample2_adm_setup.sql,
sample2_adm_cleanup.sql, sample2_cleanup.sql, sample_common_cleanup.sql

This sample assumes that the messaging gateway has already been configured.

Scope

Intended Audience: Novice

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.