kepler sql plugin connection issue "driverClassName com.microsoft.sqlserver.jdbc.SQLServerDriver"

[Omprakash Thamsetty]

Hi,

I am facing connection issue for "

Kepler - SQL Query Fields | Grids Dashboards" after upgrade jira data center version to 10.3.18. I tried replacing the mssql-jdbc-12.6.5.jre17.jar and setting up setenv to recognize the jdbc driver. But still no luck. I opened support ticket as critical as it is impacting my instance. 

Error message is:

An error occurred, Failed to load class of driverClassName com.microsoft.sqlserver.jdbc.SQLServerDriver

not sure how to resolve it. Anyone face any issue and any help much appreciated. 

[Aron Gombas _Midori_]

@Omprakash Thamsetty 

The error message suggess that it is a common class loading issue that occurs after major Jira upgrades due to changes in how the OSGi framework handles third-party JDBC drivers. The plugin's classloader cannot see the SQL Server driver even though the JAR is on the system classpath.

My first try would be this: place the mssql-jdbc-12.6.5.jre17.jar file in the <jira-install>/lib/ directory. Clear plugin cache, restart Jira. 

[Omprakash Thamsetty]

Hi @Aron Gombas _Midori_ I tried that but didnot worked. Plugin team released new version with fix. It has bug in it. Thanks for update. 

[Fabio Racobaldo _Catworkx_]

Hi @Omprakash Thamsetty ,

if you are talking about Power Scripts app, please specify what version you have installed. The latest version compatible with JIRA 10.3.8 should be 7.2.1000.0 (https://marketplace.atlassian.com/apps/43318/power-scripts-jira-workflow-automation/version-history?versionHistoryHosting=dataCenter )

Hope this helps,

Fabio