My Oracle Support Banner

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 and later
Oracle Data Integrator on Marketplace - Version 1.0.2 and later
Information in this document applies to any platform.


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.


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.