We have a requirement to handle 700K database-initiated events/day (8AM-5PM), these messages will be consumed outside of the database by various programs and adapters, many of them in-house.

At this point, our choices seem to be:

1) In-house implementation of Advanced Queue, bridged outside to something else
2) ext proc for each session, which holds open a connection to something else and pushes the events
3) Java VM in each session, which holds open a connection to something else and pushes the events
4) Oracle Messaging Gateway (based on AQ and Streams).

At current, the initiative has been to use extproc connections to an adapter, but because of their undesired properties (extproc/session etc), we feel that this technology would limit us going forward.

Does anyone have experience with Oracle Messaging Gateway? JVM/session? Any other products/technologies?

Regards,

Jeffrey J Frey