Examples with PostgresSQLNotificationListener org.jabref.shared.listener.PostgresSQLNotificationListener used on opensource projects

Example 1 with PostgresSQLNotificationListener

use of org.jabref.shared.listener.PostgresSQLNotificationListener in project jabref by JabRef.

the class PostgreSQLProcessor method startNotificationListener.

@Override
public void startNotificationListener(DBMSSynchronizer dbmsSynchronizer) {
    // Disable cleanup output of ThreadedHousekeeper
    Logger.getLogger(ThreadedHousekeeper.class.getName()).setLevel(Level.SEVERE);
    this.listener = new PostgresSQLNotificationListener(dbmsSynchronizer);
    PGDataSource dataSource = new PGDataSource();
    dataSource.setHost(connectionProperties.getHost());
    dataSource.setPort(connectionProperties.getPort());
    dataSource.setDatabase(connectionProperties.getDatabase());
    dataSource.setUser(connectionProperties.getUser());
    dataSource.setPassword(connectionProperties.getPassword());
    try {
        pgConnection = (PGConnection) dataSource.getConnection();
        pgConnection.createStatement().execute("LISTEN jabrefLiveUpdate");
        // Do not use `new PostgresSQLNotificationListener(...)` as the object has to exist continuously!
        // Otherwise the listener is going to be deleted by GC.
        pgConnection.addNotificationListener(listener);
    } catch (SQLException e) {
        LOGGER.error("SQL Error: ", e);
    }
}