Error rendering macro 'sql-query'

[Seth Howard]

Updating from 5.7 to 7.X and setup a Dev environment to test. After upgrade to 7.x we are getting this error on some pages that work in Prod:

Error rendering macro 'sql-query'

Unable to load database driver: net.sourceforge.jtds.jdbc.Driver. Make sure your configuration is correct.

I have found this error in posts but not an answer. 

Any help is appreciated.

[repi · Accepted solution]

@Seth Howard 

The net.sourceforge.jtds.jdbc.Driver is no longer supported since confluence version 6.4.

https://confluence.atlassian.com/confkb/migrate-from-the-jtds-driver-to-the-supported-microsoft-sql-server-driver-in-confluence-6-4-or-later-939505122.html

[Italo Qualisoni [e-Core]]

@Seth Howard , you will need to update the app settings to use the new driver instead of jtds as mentioned by @repi 

[Seth Howard]

Right now it reads :
<property name="hibernate.connection.driver_class">com.microsoft.sqlserver.jdbc.SQLServerDriver</property>

Is that incorrect?

Thank you all for your help.

[Italo Qualisoni [e-Core]]

@Seth Howard ,

check this

https://bobswift.atlassian.net/wiki/spaces/SQL/pages/392594283/No+JDBC+Driver

[Seth Howard]

Does the whole ENU folder go in the /bin directory or just the jre*.jar files?

Sorry I am asking for the hand holding but I cannot figure out quite what I am doing wrong.

Thanks again!!!!

[Italo Qualisoni [e-Core]]

Don't need to sorry :) 

You should copy only the jtds-1.2.2.jar file under <Confluencei nstall-directory>/lib folder;

You can get this jar file from https://sourceforge.net/projects/jtds/files/jtds/1.2.1/ 

you will need to download jtds-1.2.1-dist.zip , extract it and then copy the  jtds-1.2.2.jar into the <Confluencei nstall-directory>/lib

And then you will need to restart the application.

[Yuki Kang]

We came across the same error after we upgraded Wiki from 7.13.7 to 7.19.16 recently. Is this the same issue related to jdbc driver?