How do I get asynchronous / event-driven LISTEN/NOTIFY support in Java using a Postgres database?

by

Use the pgjdbc-ng driver.

http://impossibl.github.io/pgjdbc-ng/

It supports async notifications, without polling. I have used it successfully.

See https://database-patterns.blogspot.com/2014/04/postgresql-nofify-websocket-spring-mvc.html

Source code: https://bitbucket.org/neilmcg/postgresql-websocket-example

Oleg has a nice example answer as well

More Related Contents:

  1. Is it possible to specify the schema when connecting to postgres with JDBC?
  2. Mapping PostgreSQL JSON column to a Hibernate entity property
  3. proper hibernate annotation for byte[]
  4. How to map a PostgreSQL array with Hibernate
  5. what is @JoinColumn and how it is used in Hibernate
  6. Unable to connect to Postgres DB due to the authentication type 10 is not supported
  7. Postgres data type cast
  8. How to get a value from the last inserted row? [duplicate]
  9. What are the pros and cons of performing calculations in sql vs. in your application
  10. org.postgresql.util.PSQLException: FATAL: sorry, too many clients already
  11. No results returned by the Query error in PostgreSQL
  12. Driver JDBC PostgreSQL with Android [duplicate]
  13. Mapping array with Hibernate
  14. How do I use PostgreSQL JSON(B) operators containing a question mark “?” via JDBC
  15. Java JDBC ignores setFetchSize?
  16. Hibernate, Postgres & Array Type
  17. XML data to PostgreSQL database [closed]
  18. Java Enums, JPA and Postgres enums – How do I make them work together?
  19. @BatchSize a smart or stupid use?
  20. java.lang.ClassNotFoundException: org.postgresql.Driver, Android
  21. No operator matches the given name and argument type(s). You might need to add explicit type casts. — Netbeans, Postgresql 8.4 and Glassfish
  22. Persisting UUID in PostgreSQL using JPA
  23. Convert a Result Set from SQL Array to Array of Strings
  24. Hibernate saving User model to Postgres
  25. Postgres UUID JDBC not working
  26. Array with UserType in Hibernate and PostgreSQL –> MappingException
  27. How to make a database listener with java?
  28. Postgres Interval not working with native spring data JPA query
  29. Hibernate mapping between PostgreSQL enum and Java enum
  30. How to use Postgres JSONB datatype with JPA?

Leave a Comment