Script Runner SQL connect to SQL

[Tomasz Bryła]

Hi,

I would like to display some data from MSSQL. I have a View in Jira database. I try do this with tutorial from official Script Runner Documentation, but when I run code in script console i get this error:

groovy.lang.GroovyRuntimeException: Ambiguous method overloading for method groovy.sql.Sql#<init>. Cannot resolve which method to invoke for [null] due to overlapping prototypes between: [interface javax.sql.DataSource] [interface java.sql.Connection] at Script1.run(Script1.groovy:13)

Somewhere i saw that problem was a jdbc Driver, but it's the same database which Jira is connected. Does anybody know the solution? 

[Cristian Rosas _Tecnofor_]

Could you share your code without datasource, user and password? The SQL could also have false data, but it would be better if your share the type of those objects.

[Meena Sabnivisu]

Hi Tomasz Bryła,

I am facing same situation. Can u plz help me out if you have resolved it.

Thanks.

[Tomasz Bryła]

@Meena Sabnivisu

I was installed a new jdbc driver and connected to database like that:

jdbc:sqlserver://;serverName=NameOfServer;portNumber=1433;databaseName=jira_db