notify client of table changes (replacing polling)

[Hans]

Hello,

given an H2 server and an H2 client (connected via TCP), is there a way to notify the client of table changes, rather than polling the table using SELECTs periodically?

(Unfortunately, CREATE TRIGGER only works on the server.)

Thanks in advance.

[Evgenij Ryazanov]

Hello.

No, there is no such feature in H2. Only some databases have different own callbacks and that functionality is not standardized, AFAIK the SQL Standard does not have such features.

You can try to write some own code in the trigger to send some messages to your clients using the separate connections not managed by H2.