Stack Overflow
Stack Overflow

Questions tagged [advanced-queuing]

Oracle Advanced Queuing (AQ) is a sort of Message Oriented Middleware developed by Oracle Corporation and integrated into its Oracle database.

Oracle Advanced Queuing (AQ) is a sort of Message Oriented Middleware developed by Oracle Corporation and integrated into its Oracle database.

AQ uses database structures as a repository for asynchronous queuing as an element in various Oracle-oriented and heterogeneous operations.

For more info, check Introduction to Oracle Advanced Queuing

96 questions
15
votes
5 answers

Display contents of Oracle AQ SYS.AQ$_JMS_TEXT_MESSAGE

I have an application that uses JMS op top of Oracle advanced queuing. I would like to do a query on the queue table that shows the content of the message (which in my case is XML). So when I do a 'select user_data from [queue_table]' I get 'AQ…
Bruno Ranschaert
  • 7,428
  • 5
  • 36
  • 46
12
votes
2 answers

What is the difference between Oracle Streams and Change Data Capture?

There are several similar Oracle technologies - Oracle Streams, Oracle Change Data Capture and Database Change Notification. What are the differences between these? Are they related to Oracle Advanced Queueing?
Petr Sturc
9
votes
2 answers

How to migrate Spring Boot JMS from ActiveMQ to Oracle Advanced Queueing

I'm studying the Spring Boot and JMS example and yes, I'm rather new on this Since we work with Oracle, I would like to migrate the Spring Boot & JMS example from ActiveMQ to Oracle Advanced Queueing. However I really find very little information on…
dhmc
  • 193
  • 1
  • 15
8
votes
1 answer

Consuming message in the correct order from an Advanced Queue by Camel and JMS

I have a problem by using Apache Camel in combination with Oracle Advanced Queues and JMS. It's about an application to distribute messages. Messages are received and enqueued in Oracle Advanced Queues with the help of Camel. Then they are consumed…
The Dodo
  • 147
  • 8
7
votes
1 answer

Does SQL Server have a feature similar to Oracle Streams Advanced Queuing?

Oracle Streams AQ (Advanced Queuing) provides highly scalable database-backed queuing functionality. Does an equivalent feature exist in SQL Server (any version)? Note: I do not mean simply using a table as a queue, but a specific vendor-provided…
Synesso
  • 37,610
  • 35
  • 136
  • 207
5
votes
3 answers

Oracle Advanced Queuing - Queue Propagation

EDIT: It seems to be something with having the two queues in the same schema. I’m trying to experiment with queue propagation but I’m not seeing records in the destination queue. But that could easily be because I don’t have all the pieces in…
Mark Brady
4
votes
1 answer

Simulate a scenario where message goes into exception queue

How to simulate an exception during enqueue/dequeue/browse of oracle aq so that message goes into exception queue. I am newbie and yet to go through subscribers and consumer. What I hv done is ---- BEGIN dbms_aqadm.drop_queue_table ( queue_table…
Bopsi
  • 2,090
  • 5
  • 36
  • 58
4
votes
2 answers

Oracle Advanced Queue In Java

I am implementing Oracle Advanced Queue and am completely new to it. I have a few doubts regarding it. Below is my code: package com; /* Set up main class from which we will call subsequent examples and handle exceptions: */ import…
RK3
  • 1,221
  • 9
  • 26
  • 37
4
votes
4 answers

Lookup structure for handling future events (time based)

I am looking for an efficient data structure, that'll allow me to cue events ... that is, i will be having an app, where at any time in execution, it is possible, that an event will be raised for a future point in execution ... something…
back2dos
  • 15,588
  • 34
  • 50
4
votes
3 answers

PL/SQL function in Oracle cannot see DBMS_AQ

I have problem with Oracle 9.2 and JMS. I created PL/SQL routine to send XML text (from file or CLOB) to queue, but this routine do not compile. My code looks like (filling message omitted): create or replace procedure jms_test(msg varchar2) is …
Michał Niklas
  • 53,067
  • 18
  • 70
  • 114
3
votes
2 answers

Oracle SQL query fails only in one process: "ORA-01405: fetched column value is NULL"

I'm trying to call a system stored procedure in a "plugin" that I've built. When I test my plugin out in a test application, it works fine. When I run the plugin in the targeted app I'm building it for, I get an exception from Oracle that doesn't…
Mike Atlas
  • 8,193
  • 4
  • 46
  • 62
3
votes
1 answer

in Oracle, how can we dequeue data conditionally in dbms_aq.dequeue

Oracle DB is 11g. My question is related to Oracle APPS ERP. We are using dbms_aq.dequeue to dequeue Sales Orders. The problem is, all the Sales Orders Lines are dequeued. We want to put a condition that dbms_aq.dequeue should only dequeue such…
Shabuddin Shaikh
  • 33
  • 7
3
votes
2 answers

Programmatically check if Oracle AQ Queue exists

We have a messaging system based on Oracle AQ - it works very well, enqueing and dequeing without any problems. Now we got a request to add some sanity checks before startup and during runtime, for example "check if the queue actually exists for the…
Scorpio
  • 2,309
  • 1
  • 27
  • 45
3
votes
1 answer

PL/SQL: How to handle timeout for DBMS_AQ.DEQUEUE

I am calling DBMS_AQ.DEQUEUE from a PL/SQL program. I don't want to wait forever but regularly timeout if there is no data in the queue before I try dequeuing again. The Oracle documentation for the DEQUEUE procedure is clear on how to specify the…
themik81
  • 401
  • 6
  • 17
3
votes
1 answer

Addressing "WebLogic server side components must use AQ JMS datasource configuration"

I'm migrating an old Java application, originally written for Oracle Application Server, to WebLogic 10.3.6 in Oracle Fusion Middleware. The application uses Oracle Advanced Queue / JMS functionality. The AQ is already configured in a database. Now…
tomfumb
  • 3,669
  • 3
  • 34
  • 50
1
2 3 4 5 6 7