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/bob_swift/examples/raw/tip/confluence/groovy/sqlQuery.groovy
Download to the script folder in your Confluence home directory and use script=#sqlQuery.groovy
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 unnamed link
{groovy:output=wiki|script=#https://bitbucket.org/bob_swift/examples/raw/tip/confluence/groovy/sqlQuery.groovy|dbServer=mySqlDBServer}
{groovy}