Skip to main content
169 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
0 votes
0 answers
34 views

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 ...
user518066's user avatar
  • 1,467
0 votes
0 answers
82 views

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 ...
halarouita's user avatar
  • 1
0 votes
0 answers
119 views

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 ...
Teodor Mysko's user avatar
  • 232
1 vote
1 answer
90 views

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. ...
thomjah's user avatar
  • 53
0 votes
1 answer
506 views

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: @...
Georgii Lvov's user avatar
  • 3,850
0 votes
1 answer
174 views

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 "...
TwilightHaribo's user avatar
  • 103
2 votes
0 answers
104 views

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 "<...
NIDHEESH KRISHNA's user avatar
  • 177
2 votes
0 answers
95 views

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 “...
Leonardo's user avatar
  • 11.5k
1 vote
1 answer
242 views

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 ...
Georgii Lvov's user avatar
  • 3,850
0 votes
1 answer
51 views

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....
user19024546's user avatar
  • 11
3 votes
0 answers
418 views

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, ...
actunderdc's user avatar
  • 1,478
1 vote
0 answers
170 views

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".&...
raVen's user avatar
  • 83
1 vote
1 answer
134 views

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. ...
L.Malsha's user avatar
  • 11
0 votes
0 answers
85 views

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 ...
L.Malsha's user avatar
  • 11
3 votes
1 answer
1k views

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 := ...
John Deverall's user avatar
  • 6,340
0 votes
0 answers
335 views

I get the following message when trying to dequeue a message in a Node.js program. I am using node-oracledb Version 5.5.0. The documentation says that this is an error for enqueueing a message. The ...
zakariah1's user avatar
  • 414
0 votes
1 answer
1k views

While upgrading to the latest SpringBoot versions from 2.x to 3.x, I have encountered that there is version compatibility issue for Oracle Advance queue "AQjmsFactory" with Jakarta.jms ...
Gajanana Ganjigatti's user avatar
  • 1
1 vote
1 answer
97 views

I am working on helidon SE service where AQ connector is being used. The service is registered as listener/subscriber to a multi-consumer queue. If database connection is reset due to db restart, AQ ...
Sandhya Thummala's user avatar
  • 13
0 votes
0 answers
354 views

I've written a sample application for a producer and consumer scenario using an Oracle AQ "buffered" queue. From the producer I am able to send the message to the buffered queue. I have ...
Krish's user avatar
  • 13
3 votes
2 answers
3k views

I am using Oracle AQ in my Java Spring Boot application. I have Oracle JMS implementation AQAPI as dependencies. Recently I had tried to update the application to Spring Boot 3.x which is build on ...
Ev.Rei.'s user avatar
  • 283
0 votes
1 answer
1k views

I want to dequeue message with message id from my queue table, but I get error that ORA-25263: no message in queue OPERATION_QUEUE with message ID DBF9DE01CB5C0DA7E0550000FF000001 How I can dequeue ...
oliaaa_s's user avatar
  • 69
0 votes
1 answer
570 views

If is it possible change delay of JMS Message when it's already in the queue? When I send message via JMS, I set jmsMessage.setIntProperty("JMS_OracleDelay", 120). Then this jmsMessage ...
oliaaa_s's user avatar
  • 69
1 vote
0 answers
176 views

I have an application that queues and deques messages from Oracle AQ using the JMS interface. When the application is running items get queued and dequeued and I can see queued items in the queue ...
tantalum's user avatar
  • 2,452
1 vote
1 answer
354 views

Given: create TYPE things IS VARRAY(1) OF THING_TYP NOT NULL; and an Oracle AQ queue table, and a queue FOO_BAR, calling DBMS_AQ.ENQUEUE_ARRAY using a JDBC CallableStatement results in an ...
Robin Green's user avatar
  • 33.4k
0 votes
1 answer
264 views

Tried to send a message to the queue using the Java Code available on the Oracle website. The code ran successfully but I can't see any record in the db. static String myJson = &...
fatherazrael's user avatar
  • 6,037
-1 votes
1 answer
2k views

Not getting in any project and even jdbc dependency: First time tried project using Oracle Advanced Queue in Maven and got following error Failed to collect dependencies at com.oracle:aqapi:jar:11.2.0....
fatherazrael's user avatar
  • 6,037
0 votes
1 answer
168 views

For JMS pub/sub with a topic and two durable subscribers, in most cases when a message is sent to the topic we want the message to be consumed by both subscribers. But in a particular scenario we may ...
user518066's user avatar
  • 1,467
3 votes
0 answers
825 views

I have a schema that owns some queues and an application that connects to that schema and uses the queues. For security reasons I want to create a user schema that can access the queue and I want the ...
Dinu Nicolae's user avatar
  • 1,331
0 votes
1 answer
550 views

I have a QUEUE_OWNER schema that has some queues. When I connect the application to that data source everything works fine and the app can read the from the queues. I want to create a _USER schema ...
Dinu Nicolae's user avatar
  • 1,331
-1 votes
1 answer
144 views

I am trying send pl/sql command to oracle, but i have no idea how I can do that. There is no select or insert only work with oracle AQ. So, Maybe someone have experience with that situation? Any idea'...
red_eyes's user avatar
  • 43
1 vote
1 answer
604 views

We grant the following priviliges on schema A to user B for inserting into a queue in Oracle 12c: GRANT CREATE SESSION TO &UNAME_ENQUEUE; GRANT EXECUTE ON SYS.DBMS_AQ TO &UNAME_ENQUEUE; GRANT ...
Seldon's user avatar
  • 397
1 vote
0 answers
865 views

So I am fairly new to Oracle, certainly no Oracle master However I have used queues a lot before. I have been told that Oracle AQ supports this feature which seems to fly in the face of everything I ...
sacha barber's user avatar
  • 2,353
0 votes
1 answer
864 views

I am enqueuing JSON messages onto Oracle AQ on the JVM via the JMS client. This is working fine for small text messages but is failing for larger messages. I believe that this is something to do with ...
lance-java's user avatar
  • 29.4k
0 votes
1 answer
686 views

I'm trying to enqueue a jms text message on oracle AQ from nodejs. const enqueue = async () => { try { await oracle.createPool(); const connection = await oracle.getConnection();...
DaafVader's user avatar
  • 1,764
0 votes
2 answers
3k views

I'm developing camel route to connect to Oracle AQ on Jboss EAP Fuse. I managed to do it using the connection factory as follows: <bean class="org.apache.camel.component.jms.JmsComponent" ...
user14281661's user avatar
  • 3
2 votes
1 answer
1k views

I tried to develop queueing mechanism for our application. My idea is to prepare standard solution where there is one application (app0) producing events and one or more applications (app1, app2) ...
Patryk Dobrowolski's user avatar
  • 1,625
0 votes
1 answer
1k views

I am using Oracle 12.01, ODP.NET x64, version 4, and referencing Oracle.DataAccess.dll in .net framework 4.6. Problem appears when I try to dequeue a message in visual studio. My user has granted ...
Katherine's user avatar
  • 1
0 votes
0 answers
107 views

I have spring-jms integrated with multi-consumer Oracle Advanced Queue and each time that the application is started, adds a new consumer with name TSUB_1_[RANDOM] like TSUB_1_9FA550C4DC828DA9E05347F. ...
jotapdiez's user avatar
  • 1,466
0 votes
1 answer
512 views

I have set up a single customer Oracle AQ. I observe messages from this queue in a Java web application with CLIENT_ACKNOWLEDGE mode. But as soon as I receive the messages in the onMessage method, the ...
Ramaraj T's user avatar
  • 5,230
1 vote
0 answers
2k views

I am new to the Oracle AQ process and have a few questions about the exception queue. Here's my scenario: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 Create Table and Queue: BEGIN ...
B Red's user avatar
  • 33
0 votes
1 answer
2k views

I have a problem where my counterpart is placing messages on a JMS TEXT queue on Oracle (some custom application not using java) and I am to pick it up. The route is very simple: <!--Receive data ...
Katarina Stubberud's user avatar
  • 19
0 votes
0 answers
203 views

I am trying to invoke DBMS_AQ through java but getting following exception while invoking enqueue method.(Spring boot). While enqueing I am using a entity made in java which is similar to the dbms ...
Akshada Humne's user avatar
  • 1
1 vote
1 answer
421 views

I have a Spring Batch code that read (dequeue) data from an Oracle AQ. But to read only 100 rows, it takes 4 minutes!! What it can be the problem with this reader? ¿How can i improve the ...
Stranger's user avatar
  • 73
0 votes
2 answers
2k views

I have a Java service which is getting messages from an Oracle Advanced Queue. I can create the connection and listen and get messages OK. I can see that you can stop and start listening for ...
Adam's user avatar
  • 6,812
3 votes
1 answer
4k views

I have executed following command to start a user queue. BEGIN DBMS_AQADM.START_QUEUE('MY_USER.MY_QUEUE'); END; Is it possible to check and confirm if this Queue is started or stopped using a ...
Nilmi Nawalage's user avatar
  • 347
0 votes
0 answers
296 views

I need to monitor one table in my Oracle database for any insert/updates using Oracle Advanced Queue and Java. Note: The table usually gets 10000 inserts/updates per minute in production env. Can ...
Vijay's user avatar
  • 41
0 votes
1 answer
2k views

We are using spring boot to run our queue polling program. The queue is being polled about every 2 mins, and every 2 mins the session is closed, then refreshed. The connection is a shared connection ...
WendyG's user avatar
  • 606
0 votes
1 answer
2k views

im really new to coding (a few days).I would like to ask you for a help with my problem/idea. im having .SQL script for re-enqueue of expired messages. DECLARE v_en_options DBMS_AQ....
DannyBoy's user avatar
  • 1
3 votes
1 answer
3k views

With newer version of Oracle DB (12.2.0.1) we start to receive ORA-00932, for the code which works well with older DB server. Moreover the driver reports strange detail of exception: ORA-00932: ...
Marek-A-'s user avatar
  • 494
0 votes
2 answers
3k views

I have an insert/update trigger for a Oracle table. Is there a way to send the details of the affected row(all columns) as a message to JMS? I can write a Java Program, 'loadjava' that and call from ...
Subashini's user avatar
  • 11

1
2 3 4