nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

Accepted answers

repi

@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

All comments

repi

@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

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?

Welcome!

It looks like you're new here. Sign in or register to get started.