I would like to bind my EJB object (container managed or bean managed) to Oracle 8 DBMS_ALERT or DBMS_PIPE so that my object is notified whenever there is an update in the database by some batch process. Is it possible to do? If so, how?

Alexey Ryndin

If you use Oracle 8 you can use ORACLE ADVANCE QUERYING and subscribe for it with JMS, so you object can register some message listener, which will be notified when message sent by your batch process will arrive. For more detail information how to lookup Oracle Advance Querying system and to subscribe your JMS receiver or subscriber, look http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/appdev.817/a85456.pdf. (You may need to register yourself on technet.oracle.com first).