Jira plugin; No suitable driver found for jdbc:sqlserver

[Sudhanshu Pandey]

Hi,
I am using "atlassian-plugin-sdk-8.0.7" to crate a Jira Plugin,  jira.version=7.13.0 | amps.version= 8.0.0;
In the back-end, I am using JDBC and trying to connect SQL Server 2014 (and not SQL Server Express) to fetch some data from database.

First I tried adding below dependency in pom.xml, thinking the appropriate version will automatically be chosen (as it happens in Spring Boot), But exception was thrown asking to define proper version.

<dependency>
       <groupId>com.microsoft.sqlserver</groupId>
       <artifactId>mssql-jdbc</artifactId>
       <scope>compile</scope>
</dependency>

Then I added <version>6.4.0.jre8</version>. But its still throwing exception: 

java.sql.SQLException: No suitable driver found for jdbc:sqlserver://...

To fix this, I tried adding different version for driver but not getting any success.

Please help and suggest how can get data from Database. 

Any suggestion or help will be appreciable. Let me know if any more information is needed.