Re: LISTEN/NOTIFY support in JDBC driver?

From: Benjamin(dot)Feinstein(at)guardent(dot)com
To: barry(at)xythos(dot)com
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: LISTEN/NOTIFY support in JDBC driver?
Date: 2002-01-10 23:37:38
Message-ID: 397E0659AA2DD411843500508B64F1CE0287DE2C@USBOSMX01
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hey ya'll,

Thanks for the quick reply, Barry! I'm still having trouble getting the
notifications from the "SQLWarning Connection.getWarnings()" method. When I
tried to execute multiple LISTEN statments, I get warnings like:

java.sql.SQLWarning: NOTICE: Async_Listen: We are already listening on
event

However, I've never gotten a notification from the warnings. Yes, I am
sending the notifies from another connection to the same database. I've
attached my Java test program. Could you take a look and see what I'm doing
wrong?

Cheers,
Ben

-----Original Message-----
From: Barry Lind [mailto:barry(at)xythos(dot)com]
Sent: Wednesday, January 09, 2002 10:10 PM
To: Ben Feinstein
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: LISTEN/NOTIFY support in JDBC driver?

The jdbc driver does support notifications, but in a rather strange way.
When the driver receives a notification is takes the notification
message and adds it to the list of warnings on the connection. So the
way you get notifications is to call getWarnings(). Given that there
isn't a concept like notifications in the jdbc API, this is perhaps the
best way these can be handled within jdbc, unless someone can suggest a
better approach.

thanks,
--Barry

Benjamin(dot)Feinstein(at)guardent(dot)com wrote:

> Hello ya'll,
>
> It appears that the current version of the JDBC interface for PostgreSQL
> does not implement asyncronous client notifications. I have been able to
> issue a NOTIFY statement through the JDBC driver, but I haven't found how
to
> LISTEN for an client notification. Am I missing something, or does the
> JDBC-PgSQL interface not support LISTEN? Does anyone know of a patch to
the
> JDBC-PgSQL interface that enables the LISTEN functionality? I've looked
back
> through the list archives but was unable to find any threads in this
topic.
>
> I'm running:
> PostgreSQL 7.1.3
> jdbc7.1-1.2.jar
> Sun JDK 1.3.1_01
>
> Thanks for any help,
> Ben
>
>
>>Ben Feinstein
>> Software Development Engineer, R & D
>> W: 678.585.7865 x6726 F: 770.645.8311 M: 678.772.4126
>> 8302 Dunwoody Pl., Suite 320, Atlanta, GA 30350 www.guardent.com
>>_____________________________________________________
>>G U A R D E N T
>> Enterprise Security and Privacy Programs
>>
>>
>>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>
>

Attachment Content-Type Size
Pgsql_JDBC_Listen.java application/octet-stream 2.3 KB

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Peter Eisentraut 2002-01-10 23:57:56 Re: JDBC patch for DatabaseMetaData
Previous Message Ross J. Reedstrom 2002-01-10 22:54:02 Re: JDBC patch for DatabaseMetaData