| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2011-11-30 14:02:33 | Re: Reserved words and delimited identifiers |
| Previous Message | Robert Haas | 2011-11-30 13:18:44 | Re: Word-smithing doc changes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2011-11-30 14:36:50 | Re: Bug when retrieving money datatype. |
| Previous Message | Jan Urbański | 2011-11-30 12:27:19 | Re: Java LISTEN/NOTIFY client library work-around |