My Oracle Support Banner

Payload Vanishes When Publishing To AQ Topic Using Oracle JMS Provider (Doc ID 1389010.1)

Last updated on JULY 03, 2020

Applies to:

JDBC - Version and later
Oracle Containers for J2EE - Version and later
Information in this document applies to any platform.


Application deployed to OC4J to enqueue text message to the database Topic queue using the AQAPI does not work as expected: the user_data field of the queue table shows a correct text length but the NULL text content. No error is thrown.

Snippet source code to enqueue message:

TopicConnectionFactory topicConnectionFactory = AQjmsFactory.getTopicConnectionFactory("jdbc:oracle:thin:<USERNAME>/<PASSWORD>@<SID>:<PORT>:cp1251", new Properties());
AQjmsSession session = (AQjmsSession) topicConnectionFactory.createTopicConnection().createTopicSession(true, 0);
TopicPublisher publisher = session.createPublisher(session.getTopic("jmsuser", "topicQueueName"));



SQL select query to verify the enqueue result:
select t.user_data.text_len, t.user_data.text_vc, t.user_data.text_lob from <my Jms Text Topic Table> t;


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

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

In this Document

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