Query Timeout

[basejump]

App Query Timeout

A default will be set on the database as outlined here https://www.crunchydata.com/blog/control-runaway-postgres-queries-with-statement-timeout (see here if you have 9ci access https://github.com/9ci/domain9/issues/1791)

Helpful links

timeout on transactoin, setting this level will pick up both hibernate and jdbcTemplate

• https://docs.spring.io/spring-boot/docs/2.7.7/reference/html/application-properties.html#application-properties.transaction.spring.transaction.default-timeout
• https://stackoverflow.com/questions/54151182/spring-transaction-timeout-configurable
• https://stackoverflow.com/questions/70664498/how-to-set-the-default-transactional-timeout-globally
• https://dzone.com/articles/spring-transaction-management

query timeouts for hibernate, would change in gorm-tools

• https://ducmanhphan.github.io/2020-04-02-How-to-configure-Hibernate-correctly-in-our-project/
• http://www.mastertheboss.com/hibernate-jpa/jpa-configuration/3-ways-to-set-a-query-timeout-for-jpa-hibernate-applications/
• https://vladmihalcea.com/query-timeout-jpa-hibernate/

query timeout in jdbcTemplate

• https://stackoverflow.com/questions/20889062/jdbctemplate-setquerytimeout-specific-for-each-query-i-e-query-level

can be tested on postgres with select 1 from pg_sleep(15)

Phase 1 - Query timeout

• check to see if spring.transaction.default-timeout works and it set in PlatformTrxManager. See links above.
• If that doesn't work then lets setup a PreQueryEvent Listener. That is fired in all cases. MangoQuery fires it and Gorm fires it for all finders.
• in the listener can get use the getHibernateCriteria() on the query property and set the timeout there. Lets just stick with setting it from whatever spring.transaction.default-timeout is set to.

Timeout by user or role

this will be able to be done in the PreQueryEventListner