From: thhal at mailblocks.com (Thomas Hallgren)
Date: Wed, 08 Jun 2005 17:12:00 +0200
Subject: [Pljava-dev] Obtaining Query from Trigger
In-Reply-To: <ce04e69f05060808054ac098cd@mail.gmail.com>
References: <42A68EDA.1090206@mailblocks.com>
	<ce04e69f050607150868a9b80e@mail.gmail.com>
	<thhal-0XCeCAwV9zjYkHoY0KllhRjVR7BiY28@mailblocks.com>
	<42A70381.7060801@mailblocks.com>	<ce04e69f05060807207c684553@mail.gmail.com>
	<thhal-0BJyCA71/zjY1rTR2es9iWrUdMVc4gY@mailblocks.com>
	<ce04e69f05060808054ac098cd@mail.gmail.com>
	<42A70AC0.7030409@mailblocks.com>
	<thhal-0Q6OCA3OAzjYT02DCwJUwx6yN2xIrsf@mailblocks.com>
Message-ID: <thhal-0Q6OCA3WAzjYeMnbS6hzr+s4Abguc8E@mailblocks.com>

Joao Afonso wrote:

>  If I have the following:
>
>   - insert into user ("user_id", "name") values ('1','test')
>
> I want to pass the above string as a parameter to a Java function,
>because I might have to modify it and even pass the query to a
>different DB.
>
>  In the case that this can not be done at all, I guess I could obtain
>the data that was inserted to the DB with a SELECT and then pass it to
>a java function?
>
>  I'm sorry if I'm being a little vague on the subject, but like I
>said I'm new to pljava and these are just some ideas I need to test
>for a project I'm developing.
>  
>
If you want to know the name of the table and the data that will be 
inserted, then use the TriggerData instance that is passed to the 
trigger.  You'll find methods to obtain the relation name (i.e. the 
table name) and the new tuple. That will be far more efficient then 
parsing SQL statements.

Regards,
Thomas Hallgren