Subject | Re: Registering Listeners using jaybird |
---|---|
Author | asha_a_v |
Post date | 2006-11-10T17:28:27Z |
Yes, I understood jaybird2.1 has the facility to register listener.
But i can see only eventName and eventCount methods.
Is there anyway to get the columnname from the events, meaning which
column has changed?
Can anyone help me how to get which column has been updated from the
DB table?
Example : I have a table in Customer DB called CustomerDetails, I am
having 2 fields in that table like Customer_ID and Customer_Name.
I had written trigger for CustomerDetails UPDATE like
AS
BEGIN
POST_EVENT 'CUSTOMERDETAILS_UPDATE';
END
Now I know my java program will get notification when an update
happens in CUSTOMERDETAILS table.
But i want to know, If i update CUSTOMER_NAME column in my java
program is it possible for me to get the Updated column is
CUSTOMER_NAME.
What steps i should follow to get this done in my program.
If anyone knows this please explain me.
Thanks in Advance,
Asha.
--- In Firebird-Java@yahoogroups.com, "asha a.v" <asha_a_v@...>
wrote:
_______________
But i can see only eventName and eventCount methods.
Is there anyway to get the columnname from the events, meaning which
column has changed?
Can anyone help me how to get which column has been updated from the
DB table?
Example : I have a table in Customer DB called CustomerDetails, I am
having 2 fields in that table like Customer_ID and Customer_Name.
I had written trigger for CustomerDetails UPDATE like
AS
BEGIN
POST_EVENT 'CUSTOMERDETAILS_UPDATE';
END
Now I know my java program will get notification when an update
happens in CUSTOMERDETAILS table.
But i want to know, If i update CUSTOMER_NAME column in my java
program is it possible for me to get the Updated column is
CUSTOMER_NAME.
What steps i should follow to get this done in my program.
If anyone knows this please explain me.
Thanks in Advance,
Asha.
--- In Firebird-Java@yahoogroups.com, "asha a.v" <asha_a_v@...>
wrote:
>_____________________________________________________________________
> hi Team,
>
> Does anyone worked with registering listeners with
> Firebird DB through jaybird?
>
> I have a table named "Teams" in FOOTBALL DB.
> I want to register a listener for this table and
> whenever there is a update,delete or insert happens in
> that table, I want to get notified through listeners.
>
> Can anyone explain me the steps to achieve this.
>
> Please help.
>
> Thanks,
> Asha.
>
>
> Asha.A.V
> Software Engineer
> SatPath Systems Inc.
> 46661,Fremont blvd.
> Fremont.CA.
>
>
>
>
_______________
> Want to start your own business?
> Learn how on Yahoo! Small Business.
> http://smallbusiness.yahoo.com/r-index
>