Skip site navigation (1) Skip section navigation (2)

Re: Java LISTEN/NOTIFY client library work-around

From: Jan Urbański <wulczer(at)wulczer(dot)org>
To: Joel Jacobson <joel(at)gluefinance(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Java LISTEN/NOTIFY client library work-around
Date: 2011-11-30 12:27:19
Message-ID: 4ED62127.8050902@wulczer.org (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-jdbc
On 30/11/11 13:07, Joel Jacobson wrote:
> Hi,
>
> 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
>
> Is there some other library with a proper implementation where you don't
> have to spam the database with queries to get the notifications?

You mean a Java library? If Java is not a requirement, the psycopg2 
Python library supports notifies well.

Cheers,
Jan

In response to

Responses

pgsql-hackers by date

Next:From: Robert HaasDate: 2011-11-30 13:10:00
Subject: Re: synchronous commit vs. hint bits
Previous:From: Joel JacobsonDate: 2011-11-30 12:07:01
Subject: Java LISTEN/NOTIFY client library work-around

pgsql-jdbc by date

Next:From: Andrew DunstanDate: 2011-11-30 13:58:04
Subject: Re: Java LISTEN/NOTIFY client library work-around
Previous:From: Joel JacobsonDate: 2011-11-30 12:07:01
Subject: Java LISTEN/NOTIFY client library work-around

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group