19 February 2010
This release is focused on helping administrators control and audit the use of the SQL macros.
Confluence 2.9 and above. Release 4.0.0 may work on earlier versions of Confluence, but it is not supported on earlier versions and requires the server be running JVM 1.5 or above. Later releases of SQL for Confluence will be targeted for Confluence 3.1 and above and will not work on earlier versions of Confluence.
Highlights of SQL for Confluence 4.0
A global configuration setting has been added that gives the administrator the ability to limit the number of rows that will be processed by sql macros. When configured, this can prevent excessive resource use by poorly constructed queries that return too many rows.
In addition, a new limit parameter has been added to control the number of rows displayed on an individual sql macro. The sql macro will only process and display rows up to the limit specified. Normally, the value will have to be less than the global configuration setting. Using macro security, the administrator can permit a higher value for the limit parameter to authorized users. This allows the administrator to control exception cases where a higher number of rows is expected.
Administrators can optionally log all SQL statements used in sql macros. This option is enabled by adding configuration in the ../WEB-INF/classes/log4j.properties file. In addition, warnings are issued when the default row limit is exceeded.
Use logging when establishing or lowering row limit
Setting or lowering the row limit in an installation may cause a few existing SQL queries to show only the limited number of rows. Use logging to track usage that exceeds the limit. Investigate queries that exceed the default limit for correctness. If correct, use the limit parameter to prevent further warnings.
# SQL statement logging
log4j.appender.sqlplugin.layout.ConversionPattern=%d %p %m%n
Setting additivity to false prevents sql being logged to your main confluence log.
Users with Confluence 3.0 and above can use the Confluence macro browser to prompt for sql macros.
- Allow for translation of default parameter settings and macro browser information
Translation help requested
If anyone can contribute new or improved translations, they can be incorporated into the deliverable. Only a few phrases are required for a minimal translation. For examples, unzip the jar and look in the i18n directory.
- noDataMessage parameter to allow a message to be displayed when the sql does not return any rows.