Skip to Content
avatar image
Former Member

Oracle PUSH to Desktop App

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 28, 2015 at 03:31 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

  • avatar image
    Former Member
    Oct 28, 2015 at 11:23 AM

    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

    Add comment
    10|10000 characters needed characters exceeded