This discussion is archived
1 2 Previous Next 23 Replies Latest reply: Feb 7, 2013 11:09 PM by 974920 RSS

Handling Database Change Notification int ADF Fusion Web Application

974920 Newbie
Currently Being Moderated
I am trying to implement a system that detects modifications (e.g. insert operation) in the database. I searched over net and found these two examples: [amis technology blog|] and [niallcblogs post |]

I have downloaded a sample application in AMIS' BLOG and follow the steps which registers notifications listeners to database.
Both requires "change notification" privilege in database so I have added change notification privilege to my db user.
When I run the application It registers listeners to db notifications correctly with "registerForDatabaseNotifications" method.
Adds DatabaseNotificationHandler instances as listeners. But when I inserted a row to the table,
It does not reach to "onDatabaseChangeNotification" method as expected in the example.

After this unsuccessful attempt, I ve tried niallcblogs post, followed the steps to create and refresh a chart according to emp and dept
tables iln SCOTT schema. But again the notification does not reach to the method.

I use Jdeveloper and access to HR schema over a remote connection to our Oracle DB
Do you have any idea? I can add project sources if needed?
1 2 Previous Next


  • Correct Answers - 10 points
  • Helpful Answers - 5 points