JDBC event subscribe Oracle

d like to monitor changes in Oracle DB using JDBC connection. Does anyone knows if it is possible to subscribe to DB events and receive events through callbacks? I do not want to poll tables for changes explicitly.

Regards, Kia Stansel

Views: 22

▶ Reply to This

Replies to This Discussion

Permalink Reply by Roscoe Gariepy on September 11, 2013 at 6:26pm

This can be done with Oracle's "change notification":

http://docs.oracle.com/cd/B28359_01/java.111/b31224/dbmgmnt.htm#CHD...

Permalink Reply by David Daves on September 11, 2013 at 6:29pm

It depends on the version of the Oracle database and the Oracle JDBC drivers. Newer versions supportDatabase Change Notification which allows your applications to subscribe to database events. There is a chapter in the JDBC Developer's Guide that discusses how to implement this.

▶ Reply to Discussion

RSS

Oracle Jobs in US

Groups

Videos

  • Add Videos
  • View All

© 2024   Created by Maisam Agha.   Powered by

Badges  |  Report an Issue  |  Terms of Service