JMS_COMMIT Option of LKM JMS to SQL Appears Not to Function as Expected in ODI 12c with JMS Queues
(Doc ID 1926292.1)
Last updated on SEPTEMBER 05, 2023
Applies to:
Oracle Data Integrator - Version 12.1.2.0.0 and laterOracle Data Integrator on Marketplace - Version 1.0.2 and later
Information in this document applies to any platform.
Symptoms
When trying to read data from JMS Queue in Oracle Data Integrator (ODI) 12c there is a requirement to keep the message in the JMS Queue after reading and not delete it until desired 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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |