Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle AQ Debug JARs - How do I enable trace output

585274Jul 2 2007
Hi,

I'm having some issues dequeuing messages from a JMS Bytes message queue that were originally enqueued using the DBMS_AQ PL/SQL package. Message properties are all intact (JMSCorrelationID), but the message body is 0 bytes, when the actual size should be 17KB.

There is no issue dequeuing this exact message using PL/SQL. I have also carried out tests with the same message, enqueuing using JMS and dequeuing using PL/SQL, enqueuing using JMS and dequeuing using JMS. All these other scenarios are fine.

What would helpful would be if I could get trace logging turned on using the AQ JARs, aqapi_g.jar or aqapi13_g.jar. I had assumed it was similar to turning on trace logging for ojdbc14_g.jar (setting system property -Doracle.jdbc.LogFile=...), but that does not seem to be the case.

Any help would be welcome.

Thanks,
Paul
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 30 2007
Added on Jul 2 2007
0 comments
1,430 views