We are developing a C++ server which will process based on time based events. For example if a particular user has configured a particular task that has to be processed at a particular time, then an event or notification needs to be sent to the C++ server from the database, to initiate the task. The timming configuration is stored in the database, and the C++ server shouldnt poll the database at an interval, but event should be notified from the database at the configured timming.
We are using odatabase and odynaset libraries to connect and access the oracle database 11g.
Kindly request you to provide a solution for the above problem.
Thanks for the reply.
Please consider the scenario.
"Multiple merchants has logged in the portal, and have configured the settlement time of the transactions at a particular time. The settlement time configured by the merchants wiill varry across the merchants, and is not a single fixed time. hence we cannot run the procedure at a particular time. Multiple events or notifications has to be generated at the timming configured by the merchants only"
Hope i am able to explain the problem. Please revert with any suitable solution.
Have a look at Oracle AQ - Advance Queues. Oracle sessions & jobs can enqueue a message. Your C#/C++ code uses PL/SQL to dequeue the message and process it.
Alternatively (less robust and scalable), DBMS_PIPE can be used.
How to enqueue the messages automatically and i dont want to manage them, it should be time based events which should happen automatically.Please give me a solution for the above problem.
Thanks in advance