Postgres Pro
Downloads
Home   >   mailing lists

Re: Is it possible to get the Payload from a NOTIFY via the JDBC Driver? - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: Is it possible to get the Payload from a NOTIFY via the JDBC Driver?
Date
Msg-id alpine.BSO.2.00.1108231321150.20121@leary.csoft.net
Whole thread Raw
In response to Is it possible to get the Payload from a NOTIFY via the JDBC Driver?  (Edvin Syse <es@syse.no>)
Responses Re: Is it possible to get the Payload from a NOTIFY via the JDBC Driver?
List pgsql-jdbc
Tree view 

On Mon, 15 Aug 2011, Edvin Syse wrote:

> According to the JavaDoc, the PGNotification#getParameter() is currently
> a NOOP. I was wondering if there are any plans to implement it, or if it
> would be possible to get this information some other way?
>

This works with 9.0 and newer server versions.  The JDBC driver didn't
need any changes to make that happen, so the comment never got updated.

> I'm also curious to know if there are any plans to implement async
> support for notifications.
>

Meaning a callback mechanism or just not needing to issue queries to the
server?  Currently the JDBC driver supports an intermediate method
depending on your connection type.  You only need to poll
PGConnection.getNotifications, not issue server queries as long as you
aren't connected via SSL.  The driver uses InputStream.available to
determine when a notification is pending which isn't supported on all
InputStreams.


Kris Jurka

pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: getTablePrivileges empty if table owned by group role
Next
From: Bodor Andras
Date:
Subject: Re: JDBC SSL hostname verification