upgrade Confluence failed: checkIsolationLevel SQL Server isolation level

[aida jemaa]

Hello

When we try to upgrade confluence from version 5.10.8 to 6.12.1, we have an error appeared 

in logs:

2018-10-30 17:05:26,188 ERROR [localhost-startStop-1] [confluence.setup.dbcheck.SqlServerChecker] checkIsolationLevel SQL Server isolation level could not be read java.sql.SQLException

We are using the following level:

<property name="hibernate.connection.isolation">2</property>

[Shannon S · Accepted solution]

Hello Aida,

I see that you have raised a support ticket in addition to your question, so let's wait until my colleague is able to help determine the reason for the issue.

As soon as you're able to rectify the issue, could you let us know how it was resolved?

Thank you, and take care,

Shannon

[aida jemaa]

Hello Shannon

As explained by Support Team:

A  JDBC driver  was missing for SQL server 2017 when using Windows based authentication, using the integratedSecurity=true parameter.

After installation of the driver, we need to add the following properties in Tomcat java options.

-Djava.library.path=C:\Microsoft JDBC Driver 6.4 for SQL Server\sqljdbc_<version>\enu\auth\x86

Then it's ok.

https://docs.microsoft.com/en-us/sql/connect/jdbc/building-the-connection-url?view=sql-server-2017#Connectingintegrated

[Shannon S]

Aida,

Thank you for confirming the resolution to your issue! Hopefully it can help some other users if they have this issue in the future.

Regards,

Shannon