java.lang.NullPointerException: Cannot invoke method addURL() on null object

Question

Please help me to resolve this null pointer exception.

I am executing this script from "Script Runner" console in JIRA.

--------------------------------------------------------------------------------------------------------------------------

this.class.classLoader.rootLoader.addURL(new URL("file:///C:/TEMP/sqljdbc4.jar"))

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

def sql = Sql.newInstance("jdbc:sqlserver://servername:1433/Valid_DB_Name", "Valid user", "valid password", "com.microsoft.sqlserver.jdbc.SQLServerDriver")
--------------------------------------------------------------------------------------------------------------------------

Nic Brough -Adaptavist- · Answer

I can't tell you anything more - your code and explanation do not explain what the "this" object is for or where you expect it to come from

Nishant Kansal · Answer

Thanks, Nic.

Could you please help me further to resolve it? I am not much into OO programming and although I understood your point, however, couldn't able to think of the resolution as such.

Nic Brough -Adaptavist- · Answer

The first line of your code here calls a method on an object that does not exist at the point at which you run it.  The "this" is empty!