[HACKERS] [ANNOUNCE] PQNotify java listen / notify hack

[Magnus Naeslund(f)]

... And maybe i should attach the code aswell :)

I'm not subscribed to pgsql-jdbc or pgsql-announce, so please CC me if your 
responding...

Magnus

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


PGNotify-0.1.tar.gz
Description: GNU Zip compressed data


---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

[HACKERS] [ANNOUNCE] PQNotify java listen / notify hack

[Magnus Naeslund(f)]

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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-


---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html