Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Error rendering macro 'sql-query'

Seth Howard July 13, 2020

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.

2 answers

1 accepted

0 votes
Answer accepted
repi
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 13, 2020 edited
Italo Qualisoni [e-Core]
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 13, 2020

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

Seth Howard July 14, 2020

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]
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 14, 2020
Seth Howard July 14, 2020

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]
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 14, 2020

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.

0 votes
Yuki Kang April 17, 2023

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?

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
TAGS
atlassian, atlassian community, job interviews, interview tips, career advice, interview preparation, job search, interview experiences, hiring process, atlassian careers, community discussion, interview best practices

Interview Tips & Pet Peeves ✍️

Join the discussion on interview best practices and common pitfalls. Share your experiences and learn from others in the Atlassian Community.

Share you experiences!
AUG Leaders

Atlassian Community Events