My Oracle Support Banner

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

Last updated on JULY 23, 2018

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

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.