169 questions
0 votes
0 answers
34 views
OracleAQ: JMS_OracleDelay settings
When I use a JMS message producer with OracleAQ to send a message with JMS_OracleDelay message.setIntProperty("JMS_OracleDelay", 10) I see the the underlying AQ table add the correct DELAY ...
0 votes
0 answers
82 views
Dequeue from the exception queue and put it back to regular queue
I'm using Oracle AQs and what I'm having is some messages in the exception queue and I would like to move them back to the regular queue. As you may know, exception queues in Oracle and special, some ...
0 votes
0 answers
119 views
Slow message delivery in Java application using Oracle Advanced Queue
I have a Java application that connects to Oracle Advanced Queue (AQ) and listens for various event types. The Java server and the Oracle server are on different machines but within the same data ...
1 vote
1 answer
90 views
JMS application unable to consume from Oracle Sharded Queue
We have a system that successfully send messages across a normal, non-sharded Oracle Advanced Queue (AQ), but when we change to a Sharded Queue, the Java application is unable to consume the messages. ...
0 votes
1 answer
492 views
Spring boot with Oracle AQ and Universal Connection Pool
I am using Oracle AQ with spring boot with as follows: Gradle dependency: implementation "com.oracle.database.spring:oracle-spring-boot-starter-aqjms:23.4.0" JmsConfiguration: @...
0 votes
1 answer
167 views
Oracle AQ - Multiple JMS Listeners to dequeue a specific custom 'message type'- is this possible?
I have an Oracle 19 Database in which I planned to leverage Oracle AQ for its queueing capabilities. During a flow, a message will be created. Messages can be either of "type A" or "...
2 votes
0 answers
102 views
Read Oracle AQ message from Java with RAW type
I was trying to read RAW type AQ message from java application. But I'm getting error. java.lang.NullPointerException: Cannot invoke "String.equalsIgnoreCase(String)" because "<...
2 votes
0 answers
94 views
Oracle AQ and .Net core - How to be notified that a message is available?
Im having a bit of difficulty in creating worker service that will continuously read a AQ… my expectation is: Open Connection Create a Queue Object Hookup the “myqueue.MessageAvaiable” event Call “...
1 vote
1 answer
238 views
Sequential processing of logically grouped messages in Oracle AQ by multiple consumers
I have a spring-boot service using Oracle AQ. The service receives http-requests, enqueues request bodies as message into Oracle AQ, then dequeues it and sends to the destination services via http, so ...
0 votes
1 answer
51 views
Publishing outgoing messages with Helidon and Oracle AQ
I have the following class that supposed to send messages to Oracle AQ defined application.yml. @ApplicationScoped public class BaseAQClient{ private static final Logger logger = LoggerFactory....
3 votes
0 answers
412 views
Read messages from Oracle AQ with custom ADT payload
I am trying to read messages from an Oracle Queue that has custom ADT payload (not simple text messaging) using a simple spring cloud stream project. I am having difficulties doing this with spring, ...
1 vote
0 answers
169 views
Spring-Jms DefaultMessageListenerContainer ADT payloads Issue
I am working on a Springboot (1.5.14.RELEASE) and I upgraded that to Springboot 3.3.2. I have an oracleAQ queue and I was using XmlMessageListenerContainer (Because my payloadtype is "SYS".&...
1 vote
1 answer
133 views
Error in executing task: 'javax.jms.Session javax.jms.Connection.createSession(boolean, int)
I followed this blog and tried to configure Oracle AQ with WSO2 Micro Integrator 4.2.0. There I created proxy service and inbound endpoint as explined in the blog. But I'm getting the below error. ...
0 votes
0 answers
81 views
ERROR when trying to configure Oracle AQ with WSO2 Micro Integrator
I'm trying to configure Oracle AQ with WSO2 Micro Integrator 4.2.0. I created oracle Queue and I was able to send and messages there. Howver when I tried to configure it with WSO2 MI and trying to ...
3 votes
1 answer
1k views
Large numbers of warnings generated by suspected JDBC driver issue using Oracle 19c
Note: Oracle has now released a fix for this issue. See in comments below. Overview We are getting warnings in our database logs that seem to be caused by the following statements: 1) BEGIN :1 := ...