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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-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

Browse pgsql-hackers by date

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

Browse pgsql-jdbc by date

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