Re: Getting DBMS_ALERT to signal database updates to a Java application

In article <36C93A80.5363131_at_kideys.com>, "E. Kideys" <ed_at_kideys.com> writes
>Hi everyone,
>
> I would like my Java application to be alerted to any changes to a
>certain table in my Oracle 8.0.5 database. I am aware of a feature
>called DBMS_ALERT which accomplishes this but through Pro C functions.

dbms_alert is a server-side package and should be accessible using whatever method you usually use for your Java calling packages on the server...

I'd guess that you would have a trigger on the table that signals the change and your Java application periodically/constantly waits for that signal.

Andy

-- 
Andy Hardy
Senior IT Systems Engineer, ALSTOM Automation
Tel: +44 1908 696200
Fax: +44 1908 696225
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Opinions are mine and do not necessarily reflect those of ALSTOM Automation