Script - sql query (groovy)
Run a simple query against a direct JDBC connected database (mySQL)
How to use
Example scripts can be used in one of 3 different ways:
- Directly via url:Â https://bitbucket.org/bobswift/confluence-script/src/master/src/itest/resources/sqlQuery.groovy
- Download to the script folder in your Confluence home directory and use script=#sqlQuery.groovy (Note: Please find the sqlQuery.groovy file attached to this page)
- Copy the script into the macro body
View source
Requirements
- Scripting for Confluence 4.x or above
- Confluence 4.1 or above
Tested
This script (latest version in Bitbucket) is tested during release testing using GINT
{groovy:output=wiki|script=#https://bitbucket.org/bobswift/confluence-script/raw/3340d53e9f10b4b587e61a1a6323179d88bbf487/src/itest/resources/sqlQuery.groovy|dbServer=mySqlDBServer}
{groovy}