[ANNOUNCE] PQNotify java listen / notify hack

From: "Magnus Naeslund(f)" <mag(at)fbab(dot)net>
To: <pgsql-hackers(at)postgresql(dot)org>, <pgsql-announce(at)postgresql(dot)org>, <pgsql-jdbc(at)postgresql(dot)org>
Subject: [ANNOUNCE] PQNotify java listen / notify hack
Date: 2002-09-27 00:47:52
Message-ID: 0d7801c265bf$82972e60$f80c0a0a@mnd
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-jdbc

I heard people asking for listen/notify support in the jdbc driver from different pgsql lists. I don't know what the status is about that, but here's one solution.

I did this quick hack for our own purposes, maybe someone would like to pick this code up and use it as we do...

This code is not well tested, but it will be in the near future, if anyone have any comments/spot any bugs, please tell me.

The code is in c++ & java, and was tested/works on win32 and linux/alpha (64bit).
It needs the jdk JNI headers, since it uses the java native interface ...

Just to be clear, this way we're using one separate connection to look at notifys, and do the work (if any) in a regular JDBC connection when we get the notify.

Magnus

--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Programmer/Networker [|] Magnus Naeslund
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

Browse pgsql-hackers by date

  From Date Subject
Next Message Magnus Naeslund(f) 2002-09-27 00:53:52 [ANNOUNCE] PQNotify java listen / notify hack
Previous Message Jim Mercer 2002-09-27 00:26:51 hacker help: PHP-4.2.3 patch to allow restriction of database access

Browse pgsql-jdbc by date

  From Date Subject
Next Message Magnus Naeslund(f) 2002-09-27 00:53:52 [ANNOUNCE] PQNotify java listen / notify hack
Previous Message Barry Lind 2002-09-26 20:56:39 Re: error codes