ADF, Continuous Query Notification, JDBC, JDeveloper

Override inputListOfValues component model and Continuous Query Notification sample in ADF

Requirement: Standard ADF inputListOfValues component should behave like this: When pressed “Search”, action should stop and wait untill any change happen in DB table being searched When change happen in DB table, search should resume among updated data. If no change happen it should resume after 10 seconds timeout In addition – search input field validation should happen on “Search”…

Continue Reading

ADF, JDBC

How to select all JDBC Database Change Notification Registrations and clean them?

Question: How do I select all database change notifications registered via JDBC driver by my DB user? Answer: select * from user_change_notification_regs Question: How do I clean all of my DB change notifications? Answer: Database change notifications registered via JDBC driver can be deregistered only the same way – using JDBC driver. Therefore you need to execute this code: This…

Continue Reading