Investigate the possibility of using DB-specific queries [INT-2676]

[spring-operator]

Gunnar Hillert opened INT-2676 and commented

Investigate the following question:

• Should we possible do DB specific SQL queries? E.g. for MySQL and Oracle do "select ... for update" helping prevent duplicate reads.

• Should we consider DB specific Message Store implementations? Microsoft SQL Server has "Query Notifications" (not supported for JDBC?)

http://rusanu.com/2006/06/17/the-mysterious-notification/

Oracle has Database Change Notifications

http://theblasfrompas.blogspot.com/2010/02/using-database-change-notification-dcn.html

and PostgreSQL may also have respective support.

---

Affects: 2.1.3

This issue is a sub-task of #6647