Subject Re: Java and Triggers... again....
Author gstratfo
You may want to look into Asta (www.astatech.com). It can handle this
very easily. It's not free, but it is very capable, with built-in
instant messaging, filesharing, security, etc., etc.

The server runs on Linux or Windows, and clients can be written in
Delphi, Kylix, Java, etc., for use on PCs or handhelds.

Graham

--- In Firebird-Java@yahoogroups.com, "Nikolay Ivanchev"
<nivanchev@i...> wrote:
> 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@f...>
> 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/
> >
> >
> >