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.
Hi Manu, which version of ScriptRunner and JIRA are you on?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.