Groovy Script to connect SQL server

Manu Sukumaran Panicker October 9, 2017

Hi All,

I am trying to connect SQL server database through groovy script. The script I am trying in Groovy's "Script Console". 

Everytime I'm getting null value error.

Following is the code I'm trying to run in script console.

 

import groovy.sql.Sql
import java.sql.Driver

def driver = Class.forName('com.microsoft.sqlserver.jdbc.SQLServerDriver').newInstance() as Driver

def props = new Properties()
props.setProperty("user", "jiratesting")
props.setProperty("password", "ricciricci")

def conn = driver.connect("jdbc:sqlserver://1W8N542;databaseName=jira", props)
def sql = new Sql(conn)

try {
sql.eachRow("select count(*) from pro") {
return (it)
}
} finally {
sql.close()
conn.close()
}

 

Please suggest if anyone knows the answer.

Thank You.

 

 

 

 

 

1 answer

Suggest an answer

Log in or Sign up to answer
1 vote
Joshua Yamdogo @ Adaptavist
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 17, 2017

Hi Manu, which version of ScriptRunner and JIRA are you on?

TAGS
AUG Leaders

Atlassian Community Events