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 EditionOracle 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! |