NOTIFY/LISTEN with JDBC
От | Martin Kresse |
---|---|
Тема | NOTIFY/LISTEN with JDBC |
Дата | |
Msg-id | 200002100825.JAA05019@mail.vr.IN-Berlin.DE обсуждение исходный текст |
Список | pgsql-interfaces |
Hi there, I'm writing a database application in Java, which needs to get notified about changes in the database. Therefore I'd like to use the NOTIFY/LISTEN mechanism, but I can't get it working with JDBC. I was told, to use connection.getWarnings() method to retrieve notifications, which doesn't seem to work. I'm using PostgreSQL 6.5.1 with the JDBC-Driver 6.5 for jdk1.1, and the following code doesn't produce any output, while a parallel running psql-shell displays the notifications... Connection c = DriverManager.getConnection(...); Statement s = c.createStatement(); s.execute("LISTEN test"); while(true) { s.execute("NOTIFY test"); SQLWarning w = c.getWarnings(); if (w != null) System.out.println(w.getMessage()); try { Thread.sleep(2000); } catch (InterruptedException ex) {} } Am I doing something wrong? Thanks a lot for your help, Martin Kresse
В списке pgsql-interfaces по дате отправления: