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|http://technology.amis.nl/2012/06/18/notifying-adf-applications-of-database-changes-fast-and-lean-using-database-query-result-change-notification-part-one/] and [niallcblogs post |http://niallcblogs.blogspot.nl/2009/06/auto-refreshing-adf-chart-objects-in.html]

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 11.1.1.4.0 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

Legend

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