[Pljava-dev] PLJAVA Trigger Function more arguments

From: ilazaro at tekniker(dot)es (Nacho)
To:
Subject: [Pljava-dev] PLJAVA Trigger Function more arguments
Date: 2005-11-02 11:49:23
Message-ID: loom.20051102T124317-786@post.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pljava-dev

Hello

I have a question, I have defined a java trigger and I want send from
PostgreSQL more arguments than the TriggerData object

I have the following code

CREATE TRIGGER tu_elementos_instalacion_monitorizar_tr
AFTER UPDATE
ON elementos_instalacion_monitorizar
FOR EACH ROW
EXECUTE PROCEDURE sendudpmessagetr('valor');

CREATE OR REPLACE FUNCTION sendudpmessagetr()
RETURNS "trigger" AS
'tekniker.udpip.SendUdpMessage.sendudpmessagetr'
LANGUAGE 'javau' VOLATILE;
ALTER FUNCTION sendudpmessagetr() OWNER TO optemi;

public static void sendudpmessagetr(TriggerData td) throws SQLException{...}

My question is that if is it possible define

public static void sendudpmessagetr(TriggerData td, String str1, String str2)
throws SQLException{...}

Or if it is possible to define inside the TriggerData more arguments because I
have see in documentation that is avaliable the getArguments() method, but I
don?t know how define these new arguments in the TRIGGER function

Thanks in advance for your help

Nacho

Responses

Browse pljava-dev by date

  From Date Subject
Next Message Thomas Hallgren 2005-11-02 13:17:55 [Pljava-dev] PLJAVA Trigger Function more arguments
Previous Message armin 2005-10-31 22:17:14 [Pljava-dev] pljava on Windows XP