Questions about Listen/Notify mechanism - Mailing list pgsql-jdbc

From max
Subject Questions about Listen/Notify mechanism
Date
Msg-id 4C4267FA.2080604@directbox.com
Whole thread Raw
Responses Re: Questions about Listen/Notify mechanism  (Oliver Jowett <oliver@opencloud.com>)
Re: Questions about Listen/Notify mechanism  (Craig Ringer <craig@postnewspapers.com.au>)
Re: Questions about Listen/Notify mechanism  (Chris Wareham <cwareham@visitlondon.com>)
List pgsql-jdbc
Hallo,

I need to write a Java app which deals with as low as possible network
resources. That's why the database should inform my Java app about
changes and I does not have to poll the database every 5 seconds to
recognize them.
I read the Postgresql-JDBC documentation about the Listen/Notify
commands. I do not understand that note

"A key limitation of the JDBC driver is that it cannot receive
asynchronous notifications and must poll the backend to check if any
notifications were issued."

Does that mean that the driver will poll the database, e.g. every 5
seconds? If so, that would not be acceptable for me, because that is
exactly what I want to avoid. The only advantage of using Listen/Notify
in that case would be that I don't need an extra notification table that
my trigger would fill. Am I wrong? Oo

I hope somebody can help me with that.

Regard,

Max


pgsql-jdbc by date:

Previous
From: Florence Cousin
Date:
Subject: Re: documentation on PGResultSetMetaData
Next
From: "Mikael"
Date:
Subject: Re: Questions about Listen/Notify mechanism