Skip site navigation (1) Skip section navigation (2)

Re: Calling a java program thru a trigger or a function in postgresql

From: "Thomas Hallgren" <thhal(at)mailblocks(dot)com>
To: <pgsql-patches(at)postgresql(dot)org>
Cc: "venky" <venkycraj(at)yahoo(dot)com>
Subject: Re: Calling a java program thru a trigger or a function in postgresql
Date: 2004-02-12 11:59:46
Message-ID: 022001c3f15f$b5792b30$6401a8c0@ad.eoncompany.com (view raw or flat)
Thread:
Lists: pgsql-patches
I think your question is a bit off-topic on this mailinglist. You should
probably post it to pgsql-general.

Anyway, perhaps you'd be interested in looking at
http://gborg.postgresql.org/project/pljava.

Regards,

Thomas Hallgren

----- Original Message ----- 
From: "venky" <venkycraj(at)yahoo(dot)com>
Newsgroups: comp.databases.postgresql.patches
Sent: Tuesday, January 20, 2004 14:44
Subject: Calling a java program thru a trigger or a function in postgresql


> Here's a high-level overview of what I want to do:
>
> 1.  A record in a postgresql database is changed.
> 2.  If the change causes the data record to meet certain conditions based
on
>     Boolean logic, a database trigger will invoke a Java UDF.
> 3.  This Java UDF uses the JavaMail API to send an e-mail to a specified
>     recipient.
>
> The javamailing program is written separately and is running fine.
>
> Can any one give me the following details :
>
> 1.  Where to place the java or class file for access.
> 2.  plz give me the exact create function statements.
> 3.  plz give me the exact create trigger statments.
>
>              O R
> Plz give me the code to satisfy my requirement.
>
> Thanks in advance for ur help
>
> venky


In response to

pgsql-patches by date

Next:From: Tom LaneDate: 2004-02-12 15:40:23
Subject: Re: Some new SPI functions
Previous:From: Thomas HallgrenDate: 2004-02-12 11:53:39
Subject: Some new SPI functions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group