Polling must not know what each connection is doing, simply becouse it is a
pool with connections
If you want transactions - use high level - may be TRANSACTION_SERIALIZABLE
For knowing affected tables and columns we use additional table - like this
ID - autogenerated
affected_table
affected_row
operation (insert, update,delete)
user_id (the user that have performed the operation)

you have to play smart - like detecting insert and then update on same
table/row.. but code is less than a page and works
Niki

----- Original Message -----
From: "nagypapi" <nagypapi@...>
To: <Firebird-Java@yahoogroups.com>
Sent: Friday, December 12, 2003 1:21 AM
Subject: [Firebird-Java] Java and Triggers... again....


> Dear Group!
> I'm not that big a programmer (that's why I use Java ;-) )
> and I need some way for informing my java application using jaybird
> with FB of any change in database. I don't like polling because of
> unnecessary overhead and it's not exact (suppose an insert and a
> delete in a row affects the same data. Polling doesn't notice anything).
> Right now I'm using a java app that acts as a server and each java
> client that uses the db tells the server before updating, so the
> server notifies every connected client.
> I know Jaybird doesn't support this, but I was wondering if there was
> any other way(that doesn't need months of programming :) ) (like
> developing some kind of comm. bridge in c...) by now?
> Thanks!
>
>
>
> To unsubscribe from this group, send an email to:
> Firebird-Java-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>