Re: Notification on an Oracle table modification to a serverside Java program

Marc wrote:

> Hi Community!
>
> Im looking for a method to send a notification to my JAVA programm (in
> my case a Servlet) if an entry of an Oracle 8i table changes.
>
> The Servlet is a serverside Cache, which caches dynamical data and
> needs an instant update if any data in the underlying Backend DB
> changes.
>
> I appreciate ANY hints and comments!
>
> Best wishes,
>
> Marc

Look at a database trigger in combination with advanced queuing. I think those capabilities existed back in the dark ages of 8i. ;-)

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)