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

Hi,

In NT you can create dll and execute its functions from PL/SQL. See about external procedures in PL/SQL manual of Oracle 8. You can call this functions from triggers.

You can call system NET SEND command from dll and send message to computer which you want.

Andrew Protasov

In article <36C93A80.5363131_at_kideys.com>,   "E. Kideys" <ed_at_kideys.com> wrote:
> This is a multi-part message in MIME format.
> --------------9BB4332D3EA958A11D54B689
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> 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.
>
> I have already written my application in Java and I use JDBC for normal
> SQL operations. The project manager refuses another upgrade of the
> database to 8i so I must use the present Oracle 8.0.5.
>
> For those of you who are familiar with DBMS_ALERT, how can I get it to
> communicate a table change from a trigger to a running Java application?
>
> There is nothing that I saw in JDBC to accomplish this so I presume I
> must use SQLJ. To my understanding, SQLJ was designed to work with
> Oracle 8i.
>
> How can I embed SQLJ in my Oracle 8.0.5 database triggers with
> particular interest in DBMS_ALERT?
>
> My java application will be running on the same Windows NT machine as
> the database server.
>
> Are there any Windows NT system functions which I can use to signal the
> table change which I can embed in the trigger without using Java? What
> I had in mind was sending a message to a particular Winsock port for
> which the java application would be listening.
>
> Any help is greatly appreciated. Thanks in advance.
>
> --
>
> Ed A. Kideys
>
> Kideys Inc.
> One Main Street, Suite 301
> Eatontown, NJ 07724-3450
>
> www.kideys.com
> ed_at_kideys.com
>
> Phone : 732 460 9510
> Fax : 732 247 0180
> --------------9BB4332D3EA958A11D54B689
> Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf"
> Content-Transfer-Encoding: 7bit
> Content-Description: Card for Ed Kideys
> Content-Disposition: attachment; filename="vcard.vcf"
>
> begin: vcard
> fn: Ed Kideys
> n: Kideys;Ed
> org: Kideys Inc.
> adr: One Main Street;;Suite 301;Eatontown;NJ;07724-3450;USA
> email;internet: ed_at_kideys.com
> title: President
> tel;work: 732 460 9510
> tel;fax: 732 247 0180
> note: www.kideys.com
> x-mozilla-cpt: ;0
> x-mozilla-html: FALSE
> version: 2.1
> end: vcard
>
> --------------9BB4332D3EA958A11D54B689--
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Feb 16 1999 - 00:00:00 CET