Re: Can Oracle alert a java applet?

I'm not up on my Java yet, but generically speaking, the DBMS_ALERT package exists for just this type of situration. A process can register and wait upon a named event and be guaranteed to be notified that the event has taken place. Alerts are usually triggered via database triggers, and obey commit-time rules (ie, a commit has to happen before the alert is triggered...a rollback will cancel the alert).

So the real answer to your question is...can you write a java thread that registers and waits for an Oracle alert event using Oracle's DBMS_ALERT package. I'm afraid I don't know enough about JDBC to answer this for you, but my guess would be YES.

Regards,

Dave Macpherson

amaury wrote in message <356AEDA4.91D8782D_at_logica-sa.com>...
>Hi,
>I am very new to Oracle, and haven't sokved my
>problem reading the docs. Maybe somebody knows the answer:
>
>I need to alert a Java applet running on a workstation
>that the Oracle database (on the server) has been updated.
>The Java applet would then SQL the DB.
>
>I have read that "triggers" COULD do the trick,
>but I don't know if this is true. Does somebody knows any way to alert the
>applet that the DB has been updated? Or maybe the DB could directly send
the new
>values to the applet?
>Arggh! I can't figure out what to do!
>Please help!
>
>Thanks,
>Amaury
Received on Wed May 27 1998 - 17:18:04 CDT