Re: Is it possible to get the Payload from a NOTIFY via the JDBC Driver? - Mailing list pgsql-jdbc

From Edvin Syse
Subject Re: Is it possible to get the Payload from a NOTIFY via the JDBC Driver?
Date
Msg-id 6C37221E818AD94EB8593F2D10B7D62611A9B9@EX-2010-01.ad.sdhosting.no
Whole thread Raw
In response to Re: Is it possible to get the Payload from a NOTIFY via the JDBC Driver?  (Kris Jurka <books@ejurka.com>)
List pgsql-jdbc
> This works with 9.0 and newer server versions.  The JDBC driver didn't
> need any changes to make that happen, so the comment never got
> updated.

Sweet, thanks :)

> > I'm also curious to know if there are any plans to implement async
> > support for notifications.
> >
> 
> Meaning a callback mechanism or just not needing to issue queries to the
> server?  Currently the JDBC driver supports an intermediate method
> depending on your connection type.  You only need to poll
> PGConnection.getNotifications, not issue server queries as long as you
> aren't connected via SSL.  The driver uses InputStream.available to
> determine when a notification is pending which isn't supported on all
> InputStreams.

It would be nice to be able to attach a listener that gets notifications in realtime as they come over the wire, but if
Iunderstand you correctly, I can atleast let a thread poll regularily, and it will not create any network traffic,
right?Is there a way to attach a listener with today's architecture?
 

-- Edvin

pgsql-jdbc by date:

Previous
From: Ian Pilcher
Date:
Subject: Re: PreparedStatement syntax extensions?
Next
From: dexdyne
Date:
Subject: Re: time zone setting.