| View previous topic :: View next topic |
| Author |
Message |
Steve Sharpe
Guest
|
 Posted: Tue Jun 06, 2006 5:02 pm Post subject: Replicate IBEvents in ORACLE |
 |
|
We are about to port our database from InterBase 7.5 to ORACLE 10g (IBExpress to DOA componets). We make extensive use of IBEvents in our server side code to respond to updates to database rows rather than a simple "run query every 10 seconds" approach.
Does anyone have any suggestions for how we could go about replicating this functionality when ORACLE was the back end database?
Thanks Steve |
|
| Back to top |
|
 |
frecobos
Guest
|
| Posted: Fri Jun 09, 2006 12:57 am Post subject: Re: Replicate IBEvents in ORACLE |
|
|
DOA has a component called TOracleEvent. Check the help for it.
It looks like using Triggers, DBMS_Alert oracle package and this
component you would be able to implement what you are looking for.
regards. |
|
| Back to top |
|
|
Eric Hill
Guest
|
| Posted: Fri Jun 09, 2006 6:32 pm Post subject: Re: Replicate IBEvents in ORACLE |
|
|
| Quote: | We are about to port our database from InterBase 7.5 to ORACLE 10g
(IBExpress to DOA componets). We make extensive use of IBEvents in our
server side code to respond to updates to database rows rather than a
simple "run query every 10 seconds" approach.
Does anyone have any suggestions for how we could go about replicating
this functionality when ORACLE was the back end database?
|
Oracle also has queues (DBMS_AQ and DBMS_AQADM packages) that are
publish/subscribe. DOA has 100% support for queues, and you can easily
subscribe to a "change notification" queue that a trigger can place events
into. Queues can be point-to-point messaging queues or (what you want)
broadcast queues. Many clients subscribe to the change queue and any time
anything changes, you can stick a change notification (your definition,
any kind) into the queue and all clients will receive it.
Eric |
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
