From: | joaoaafonso at gmail(dot)com (Joao Afonso) |
---|---|
To: | |
Subject: | [Pljava-dev] Obtaining Query from Trigger |
Date: | 2005-06-08 14:20:57 |
Message-ID: | ce04e69f05060807207c684553@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pljava-dev |
Ok, my mistake... I'll need to think of something else. But I still
need to get the query that fired on an insert, update or delete. Could
you help me with that??
Thanks in advance.
On 6/8/05, Thomas Hallgren <thhal at mailblocks.com> wrote:
> Joao Afonso wrote:
>
> > Hi!
> >
> > I started using pljava two days ago, so I apologize if this was
> >already posted before.
> >
> > I need to get the sql query that fired a trigger on a DB so that it
> >can be re-issued to another DB.
> >
> > For example, if 'select * from users' fired a before select trigger,
> >the string with the query should be somehow passed to the java
> >function that is associated to that trigger.
> >
> >
> I hate to dissapoint you but to my knowledge a trigger is never fired
> for SELECT. Only INSERT, UPDATE, and DELETE will fire triggers.
>
> Regards,
> Thomas Hallgren
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Hallgren | 2005-06-08 14:41:05 | [Pljava-dev] Obtaining Query from Trigger |
Previous Message | Michael Judd | 2005-06-08 11:41:06 | [Pljava-dev] Re: VM initialization failure |