The data tables in my oracle 9i database change frequently and I want to find a way to get some form of notification (preferrably along with the changed data) to be called in my java app hosted by a servlet container such as Tomcat - what is the best way to go ?
My priliminary reading of oracle specific RowSets indicates that it can notify only if changes are made to its reference and are not when changes are done by somebody else to the database through some other process.
Database change can be notified to databse object using trigger, but for java program to be notified you need to query database.
could you explain you requirement in details.
Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
Joined: Jun 26, 2001
Well you could have your trigger (which in Oracle I think can be written in java) write the database changes as they occur to some external resource (a message queue might be an idea), then your middle tier component can be listening incoming messages on that queue for example.