JMS_COMMIT Option Of LKM JMS... Appears Not To Function As Expected In ODI 12c With JMS Queues

(Doc ID 1926292.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Data Integrator - Version 12.1.2.0.0 and later
Information in this document applies to any platform.

Symptoms

You are trying to read data from JMS Queue in Oracle Data Integrator (ODI) 12c.

The requirement is to keep the message in the JMS Queue after reading and not delete it until wishing to do so.

There is an option called "JMS_COMMIT" in "LKM JMS to SQL" knowledge module.

As per the oracle documentation if you set this option to 'FALSE' the message will not be deleted from the JMS queue after reading it.

However in reality the message is getting deleted as soon as you read it from the JMS queue.

Cause

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 hundreds of Community platforms