How NOTIFY and LISTEN

[Alan Alfredo Rojas Marroquin]

Hi,

I'm not sure if it's the right group.

My question is, How can I use NOTIFY and LISTEN of PostgreSQL (http://www.postgresql.org/docs/current/static/sql-notify.html) in Play Framework (Java) through JPA?

Thanks!

[Matthias Kurz]

Hi Alan,

check out these resources, hopefully they can help you:

http://www.depesz.com/2012/06/13/how-to-send-mail-from-database/ (read through it, it also uses the NOTIFY LISTEN approach)

https://jdbc.postgresql.org/documentation/94/listennotify.html (example code in Java)

https://wiki.postgresql.org/wiki/PgNotificationHelper

https://wiki.postgresql.org/wiki/PgNotificationPoller

Regards,

Matthias

[Alan Alfredo Rojas Marroquin]

uffff, Thanks a lot! XD