I’m trying to set up NotificationListener using HikariDataSource and PGConnection (i’m using postgresql in my app), however I have a problem wrapping a HikariDataSource in PGConnection.
Firt I tried to do it using a separate class with connection to the database and PGDataSource instead of Hikari (one class for all databse operations – using Hikari, one class for notification listener only), but the problem is that they’re separate sessions and one session doesn’t see the listening channel set in the other session.