Query execution timeout

Another important enterprise level requirement is to provide greater control over SQL queries that use too many resources or take too much time. Administrators can configure a global timeout that will stop queries from running longer that the limit. With Macro Security for Confluence, administrators can still allow trusted user to exceed the limit for specific long running queries. This is done by using the queryTimeout parameter on the macro. Trusted users can be configured in Macro Security for Confluence to be able to exceed the default queryTimeout parameter for the sql and sql-query macros.

By default, queryTimeout processing is not enabled (No limit) for compatibility with current behavior. A app administrator can set a specific value via Configure button for the app in UPM.

When enabled, the timeout will also be restricted by the render timeout limit imposed by Confluence on total time to render content (default is 120 seconds).

Requires database support

Only available when used against databases/JDBC drivers that provide support. A partial list is provided here. Check your database usage for similar support. See

SQL-172 - Getting issue details... STATUS

for more details.

PostgreSQL 9.2
Oracle 11g
MySQL 5.0

Release notes 5.1

2012-11-18