Re: Oracle Advanced Queue and Java Messaging System(JMS)

From: Martic Zoran <zoran_martic_at_yahoo.com>
Date: Sat, 9 Apr 2005 23:27:39 -0700 (PDT)
Message-ID: <20050410062739.69520.qmail@web52607.mail.yahoo.com>

My understanding is next:

1. AQ is built on top of tables and all main API is in PL/SQL. There is the possibility that some low level calls are implemented in C.
2. You have different API's to do AQ, like PL/SQL, C, Java. I believe at the end both C and Java calling Pl/SQL but not 100 sure :)
3. Oracle JMS is using Oracle AQ to persist messages or temporary queues when no need to persist them, but again Oracle database AQ

Standard Oracle story beggining and usually finishing with the database :)

At the end AQ queues are nothing then Oracle nice table level implementation of queues where even exception queue messages are in the same original table where only one STATE column telling you is the message processed/exception/arrived/.... Very nice interface with a lots of features I believe all in PL/SQL.

Regards,
Zoran

• Sami Seerangan <dba.orcl_at_gmail.com> wrote:
  > Hi:
  > I like to know what is the relationship between AQ
  > and JMS?
  >
  > Is AQ built on top of JMS? If not what is the
  > underlying technology for
  > AQ? I think AQ is written in C language and uses its
  > own enqueue/dequeue.
  > Any comments are welcome.
  > --Sami
  >
  > --
  > http://www.freelists.org/webpage/oracle-l
  >
  

  ---

Do you Yahoo!?
Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/

--
http://www.freelists.org/webpage/oracle-l

Received on Sun Apr 10 2005 - 02:31:35 CDT