Re: notify clients on database updates

It would probably be best if you moved this "cached" data and the logic that uses it to the database. That way, you can forget about "notifying" anyone. The database knows when the data was modified. In short, I feel that your design probably isn't the strongest and that you are trying to get around that poor design.

HTH,
Brian

roger wrote:
> Hi, I've got another one of "those" kinds of questions.
> Here's the scoop....
>
> Middleware application server process reads and caches
> (builds objects out of) various database rows at startup,
> and uses these values to perform lots and lots of frequently
> required operations.
>
> The nature of these row values is that while they don't
> change often, they can and do change occasionally.
>
>
> So, I need some sort of mechanism by which my application
> level code (either C++/OCI or C#/ado.net) can be
> "notified" when such changes take place.
>
> I can think of a couple of ways to start down the path,
> but first I'm wondering if there is some well known approach
> to doing this kind of thing - surely I can't be the first
> one to have wanted to do something like this.
>
>
> Thanks for your consideration.
>
>
> And before I forget to mention it yet again -
> I'm using Oracle 9.2.
>
> Thanks.
Received on Fri Oct 24 2003 - 08:31:01 CDT