Oracle PUSH to Desktop App

[Former Member]

Hi all,

I have an app which needs to report to users certain database criteria in real time.

So it sits there and constantly polls the database whenever a timer event fires (usually every minute).

Very wasteful of CPU cycles and network traffic.

So, instead, is it possible for the Oracle (or SQL Server) database to send a message to my desktop app whenever certain triggered updates occur?

Ideally, the database should trigger a user event in my app.

Is it possible to "register" an app with Oracle to make this work?

All other ideas are welcome. (someone suggested NET SEND).

TIA

Larry

[Former Member · Accepted solution]

Take a look at Oracle's Streams Advanced Queuing.

From the guide (Sending Messages Using Oracle Streams Advanced Queuing)

Oracle Streams Advanced Queuing (AQ) can notify an application and users when a message of interest is enqueued. Notifications enable applications and users to do their work without constantly checking a queue for new messages. Notifications can be sent to an application using PL/SQL, Java Message Service (JMS), or Oracle Call Interface (OCI) callback functions. Notification can also be sent to a specified e-mail address or HTTP post. In addition, notifications can be presented in either RAW data type form or XML form. Applications and users do not need to be connected to a database to receive notifications. When they are notified that a message of interest has appeared in a queue, they can connect to the database and check the queue.

[Former Member · Accepted solution]

As alternative to your current situation of pulling, you could convert that pull to look at messages created by a DBMS_PIPE procedure.  You're still pulling, but it should be less noisy on the network. For a simple example, see DBMS PIPE - Oracle FAQ

[Former Member]

Hi Larry;

   Oh yea .. <sigh> I wish we still had Distributed PowerBuilder (DPB) feature </sigh> as we could so easily do Server Push to client applications using that feature!  

   I wonder if you could modify Roland's "Chat" example that uses WinSock programming to do the trick ( Topwiz Software - PBChat )?

Regards ... Chris