Scott Miller

Appsguild - Software craftsmanship, project management, and the biz of software
  Home  |   Contact  |   Syndication    |   Login
  145 Posts | 3 Stories | 168 Comments | 72 Trackbacks

News



Article Categories

Archives

Image Galleries

Best Blogs

Podcasts

Scott's links

Oracle Advanced Queueing Publish-Subscribe Model
I created a whitepaper and example for my work with Advanced Queueing. The whitepaper can be found here: AdvancedQueueingPublish-SubscribeModelWhitePaper.doc
The SQL is here: AQPublishSubscribeSQL.zip

This is similar to the BooksOnline example in the Oracle 9i Advanced Queuing documentation. It uses a graphical design business as an example, with a central customer service location and multiple satellite offices. It sets up four multisubscriber queues - one for incoming projects, and two satellite offices. It then sets up subscribers to the project queue with rules that propagate messages to the satellite design office queues based on the routing code in the intelligent project number. If an inputted project number does not match the correct codes (maybe because of customer service input error) it propagates the message to a customer service queue for review.

Advanced Queueing does all this at the database level without needing a message broker or message server.

This is the basis for an application that I am doing for a customer. DotNet functionality and interaction will be forthcoming in the future.

posted on Friday, September 16, 2005 6:55 AM

Feedback

# re: Oracle Advanced Queueing Publish-Subscribe Model 12/20/2005 10:21 AM Transporter
Hey, did you ever complete this application. I'm curious to know how to interact with Advanced Queueing from a C# application. I'm pretty new to this area, so not sure if it's just as easy as using some SQL in your code to interact with the queue tables.

# re: Oracle Advanced Queueing Publish-Subscribe Model 12/20/2005 1:07 PM Scott Miller
It is mostly just SQL to access the queue tables. All of the real power/functionality is performed by the queue engine embedded in the database.

# re: Oracle Advanced Queueing Publish-Subscribe Model 3/11/2006 2:43 AM Nasir
Hi, I want to implement AQ. We have two java applications running in our environment. Now I want to use AQ for message passing between these two applications. Actually i want to ask you when a message arrives in the queue how the application will be notified that there is a message in the queue take it and process it. I will be really great full to you for your help in this regard.

# re: Oracle Advanced Queueing Publish-Subscribe Model 3/11/2006 5:55 PM Scott Miller
If a message arrive in the queue it will be processed according to the rules that you have setup. You can use subscriber queues that have rules and will auto-pop a message off the queue. Or you can make a queue and pop the message of the queue manually.

# re: Oracle Advanced Queueing Publish-Subscribe Model 8/25/2007 3:24 AM Harshita
Hi, I am not able to access the white paper and the SQL application.
AdvancedQueueingPublish-SubscribeModelWhitePaper.doc
The SQL is: AQPublishSubscribeSQL.zip

Can someone help me please.



Post A Comment
Title:
Name:
Email:
Website:
Comment:
Verification: