On Wed, 30 Nov 2011, Joel Jacobson wrote:

> As you know, LISTEN/NOTIFY is broken in the Java client library. You have to
> do a SELECT 1 in a while-loop to receive the notifications.
> 
> http://jdbc.postgresql.org/documentation/head/listennotify.html

This documentation is out of date.  Currently you can get notifications 
without polling the database if you are not using a SSL connection.  You 
still must poll the driver, using PGConnection.getNotifications, but it 
will return new notifications received without an intermediate database 
query.  This doesn't work over SSL and potentially some other connection 
types because it uses InputStream.available that not all 
implementations support.

Kris Jurka

In response to

• Java LISTEN/NOTIFY client library work-around at 2011-11-30 12:07:01 from Joel Jacobson

Responses

• Re: Java LISTEN/NOTIFY client library work-around at 2011-12-01 12:21:39 from Joel Jacobson

pgsql-hackers by date

Next:	From: Tom Lane	Date: 2011-12-01 03:29:03
	Subject: Re: Accounting for toast in query planner. (gin/gist indexes).
Previous:	From: Andrew Dunstan	Date: 2011-12-01 00:06:52
	Subject: Re: Review of VS 2010 support patches

pgsql-jdbc by date

Next:	From: bht	Date: 2011-12-01 07:58:40
	Subject: Re: Bug: Cannot pass null in Parameter in Query for ISNULL
Previous:	From: Craig Ringer	Date: 2011-11-30 23:46:47
	Subject: Re: Bug when retrieving money datatype.