Unable to run groovy script in JIRA 5.1

Question

I am using a grrovy script for workflow transition. On the transition, it is showing following excepton/error in the log file:

The script failed : javax.script.ScriptException: javax.script.ScriptException: javax.naming.NameNotFoundException: Name jdbc is not bound in this Context"

JamieA · Answer

You can get the connection through other means, eg https://studio.plugins.atlassian.com/wiki/display/GRV/Miscellaneous+Groovy+Scripts#MiscellaneousGroovyScripts-ExecuteaSQLquery

swati sneha · Answer

def getSQL = {
    Context initialContext = new InitialContext();
    if ( initialContext == null) {
        log("JNDI problem. Cannot get InitialContext.");
        System.exit(0)
    }

DataSource datasource = (DataSource)initialContext.lookup("java:comp/env/jdbc/defaultDS");

if (datasource == null) {
        log("Failed to lookup datasource.")
        System.exit(0)
    }

new Sql(datasource)
}

*Note: defaultDS is the datasource name.

Regards

Swati

swati sneha · Answer