Обсуждение: Calling a java program thru a trigger or a function in postgresql
Calling a java program thru a trigger or a function in postgresql
От
venkycraj@yahoo.com (venky)
Дата:
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
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@yahoo.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