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

Re: Java LISTEN/NOTIFY client library work-around

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Jan Urbański <wulczer(at)wulczer(dot)org>
Cc: Joel Jacobson <joel(at)gluefinance(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Java LISTEN/NOTIFY client library work-around
Date: 2011-11-30 13:58:04
Message-ID: 4ED6366C.7000602@dunslane.net (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-jdbc

On 11/30/2011 07:27 AM, Jan Urbański wrote:
> 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.
>
>

... and probably most libraries that (unlike JDBC) are libpq-based, like 
the perl DBD::Pg.


cheers

andrew

In response to

pgsql-hackers by date

Next:From: Alvaro HerreraDate: 2011-11-30 14:02:33
Subject: Re: Reserved words and delimited identifiers
Previous:From: Robert HaasDate: 2011-11-30 13:18:44
Subject: Re: Word-smithing doc changes

pgsql-jdbc by date

Next:From: Tom LaneDate: 2011-11-30 14:36:50
Subject: Re: Bug when retrieving money datatype.
Previous:From: Jan UrbańskiDate: 2011-11-30 12:27:19
Subject: Re: Java LISTEN/NOTIFY client library work-around

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