Re: A method to asynchronously LISTEN ?

Hello,

This feature is indeed what we would need.
In fact I do not understand how the test case works.
I am more a sql/database guy.

Best regards,
Philippe Ebersohl

From: "Dave Cramer" <pg(at)fastcrypt(dot)com>
To: "Philippe Ebersohl" <philippe(dot)ebersohl(at)dalim(dot)com>
Cc: "List" <pgsql-jdbc(at)postgresql(dot)org>
Sent: Monday, 25 February, 2019 16:13:49
Subject: Re: A method to asynchronously LISTEN ?

Philippe

On Mon, 25 Feb 2019 at 04:15, Philippe Ebersohl < philippe(dot)ebersohl(at)dalim(dot)com > wrote:

Hello Dave,

This is, sir, what we would like !

However looking at line 47-50 of
pgjdbc/src/test/java/org/postgresql/test/jdbc2/NotifyTest.java

How do we guaranty that the listener is called before the assertTrue() is fired ?

stmt . executeUpdate( " NOTIFY mynotification " );

assertTrue(flag . get());

I'm not sure exactly what you mean

Dave Cramer

davec(at)postgresintl(dot)com
www.postgresintl.com

BQ_BEGIN

From: "Dave Cramer" < pg(at)fastcrypt(dot)com >
To: "Philippe Ebersohl" < philippe(dot)ebersohl(at)dalim(dot)com >
Cc: "List" < pgsql-jdbc(at)postgresql(dot)org >
Sent: Friday, 22 February, 2019 20:03:46
Subject: Re: A method to asynchronously LISTEN ?

Hi Philippe,
So this is old, but I didn't get much response https://github.com/pgjdbc/pgjdbc/pull/579

have a look and see if it works for you. If so we can look at putting it in.

Dave Cramer

davec(at)postgresintl(dot)com
www.postgresintl.com

On Sat, 16 Feb 2019 at 03:36, Philippe Ebersohl < philippe(dot)ebersohl(at)dalim(dot)com > wrote:

BQ_BEGIN

Hello,
I checked the documentation and FAQ at jdbc.postgresql.org
Is there a roadmap of feature implementation for the jdbc driver ?

Are there plans to include something similar to the PGNotificationListener found in pgjdbc-ng?
Which does not require to send SELECT to the postgres.

We would if possible only use one postgresql jdbc driver.

I hope I hit the right list for my questions.
Thank you.

Best regards,
Philippe Ebersohl

(null)

BQ_END

BQ_END