On 10/6/05, Roman Rokytskyy <rrokytskyy@...> wrote:

> > I never tried it, but postgre has some kind of event mechanism:
> > http://www.postgresql.org/docs/7.4/interactive/sql-listen.html
> > http://www.postgresql.org/docs/7.4/interactive/sql-notify.html
>
> Sounds very similar to IB events. We have to check whether it is available
> via JDBC, so that our API is more or less coherent with that one.
>

Based on the JDBC driver documentation
(http://jdbc.postgresql.org/documentation/80/listennotify.html), it
looks like this is performed based on an extension of
java.sql.Connection. It also looks like it's a bit clumsy and not
really asynchronous; the connection still has to be polled for
notifications by first running a (dummy) sql statement. Looking at the
implementation, it appears that the notification data comes in on the
same socket connection as is used for all other traffic; in
Interbase/Firebird/Jaybird, the event notifications come in on a
dedicated event connection.

Gabriel