Ingres Community Forums Login Register Ingres.com  

Ingres Community Forum


Go Back   Ingres Community Forums > Ingres Forums > OpenROAD Developer's Forum
 

Reply
 
LinkBack Thread Tools Display Modes
Old 2009-06-09   #1 (permalink)
Ingres Community
 
Join Date: May 2007
Posts: 40
Default Oracle Gateway - losing database events?

I'm not sure what version we are on, but has anyone experienced losing database events through the oracle gateway?

I've 3 similar events that are raised yet I'm only receiving the last one within OpenROAD?
Pete.Wilkinson@vivista.sungard.com is offline   Reply With Quote
Old 2009-06-09   #2 (permalink)
Ingres Community
 
Join Date: May 2007
Posts: 40
Default

having now spoken to the DBA, my problem is duplicate event names. Though the message data in each is different, it only process the last one as the previous ones are duplicates in its eyes, which is correct
Pete.Wilkinson@vivista.sungard.com is offline   Reply With Quote
Old 2009-06-13   #3 (permalink)
Ingres Corp
 
Join Date: Mar 2007
Location: On the OpenROAD
Posts: 666
Default

Yep, according to Oracle doc (Signalling Database Events with Alerters) that's correct:
Quote:
Alerts can be signalled more often than the corresponding application WAIT calls. In such cases, the older alerts are discarded. The application always gets the latest alert (based on transaction commit times).
Bodo is offline   Reply With Quote

Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


© 2009 Ingres Corporation. All Rights Reserved