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

Java LISTEN/NOTIFY client library work-around

From: Joel Jacobson <joel(at)gluefinance(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Java LISTEN/NOTIFY client library work-around
Date: 2011-11-30 12:07:01
Message-ID: CA+9pJHR4SaDbxWGCJKVE0msH6sZKZbNKrzmpUrzjKPn5n9LV2A@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-jdbc
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?

If not, my company is willing to sponsor development of a patch fixing this
problem.

-- 
Best regards,

Joel Jacobson

Responses

pgsql-hackers by date

Next:From: Jan UrbańskiDate: 2011-11-30 12:27:19
Subject: Re: Java LISTEN/NOTIFY client library work-around
Previous:From: jesperDate: 2011-11-30 11:38:20
Subject: GIN internal query-plan alternatives.

pgsql-jdbc by date

Next:From: Jan UrbańskiDate: 2011-11-30 12:27:19
Subject: Re: Java LISTEN/NOTIFY client library work-around
Previous:From: Oliver JowettDate: 2011-11-30 08:22:33
Subject: Re: Bug: Cannot pass null in Parameter in Query for ISNULL

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