Script - sql query (groovy)

Run a simple query against a direct JDBC connected database (mySQL)

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

Tested

This script (latest version in Bitbucket) is tested during release testing using GINT

{groovy:output=wiki|script=#https://bitbucket.org/bob_swift/examples/raw/tip/confluence/groovy/sqlQuery.groovy|dbServer=mySqlDBServer}
{groovy}