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

Last updated on NOVEMBER 05, 2016

Applies to:

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

Symptoms

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:jmsuser/jmsuser@hsong-fr:1521:cp1251", new Properties());
AQjmsSession session = (AQjmsSession) topicConnectionFactory.createTopicConnection().createTopicSession(true, 0);
TopicPublisher publisher = session.createPublisher(session.getTopic("jmsuser", "topicQueueName"));

publisher.publish(session.createTextMessage("hello"));
session.commit();

 

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;

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