From: thomas at tada.se (Thomas Hallgren)
Date: Wed, 02 Nov 2005 15:15:03 +0100
Subject: [Pljava-dev] PLJAVA Trigger Function more arguments
In-Reply-To: <5234B8D9C36F9E4D9B1AF01013708B6B0152C03A@txindoki.tekniker.es>
References: <5234B8D9C36F9E4D9B1AF01013708B6B0152C03A@txindoki.tekniker.es>
Message-ID: <4368C9E7.60202@tada.se>

Ignacio L?zaro wrote:
> Hello
>
> I have the table 'elementos_intalacion_monitorizar' with the fields 'value' and 'code'
> After one UPDATE of this table I want send a UDP message to a port of a IP with the code and value modified (only if the value has changed)
>
> I have a java class to send a UDP message and the required parameters are IP, port and code&value. IP and port are defined in a table named configuration 
>
> So what I need, is to define a trigger that 
> 1- check if the value of the code has really changed
> 2- get the ip and port from configuration table
> 3- execute the java class that send the UDP message with the required values
>
> What I have done
> 1- I have installed in postgreSQL the java class
> 2- I have defined the TRIGGER and FUNCTION explained before, but as I can understand with your last message and for my tests is that it is not possible get dinamically from a table the ip and port values inside the definition of the trigger
>
> My question at this stage : is there another way of executing a java class from PostgreSQL trigger or function?
>
>   
A trigger has a concept of an 'old' and a 'new' row. What you're after 
is the 'new' row, i.e.

ResultSet newRow = td.getNew();
String value = newRow.getString("value");
String code = newRow.getString("code");

Regards,
Thomas Hallgren