Forums

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

upgrade Confluence failed: checkIsolationLevel SQL Server isolation level

aida jemaa October 30, 2018

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>

 

1 answer

1 accepted

0 votes
Answer accepted
Shannon S
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
November 1, 2018

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 November 2, 2018 edited

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
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
November 7, 2018

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

Suggest an answer

Log in or Sign up to answer
TAGS
atlassian, likes for trees, atlassian community, social impact, tree planting campaign, community kudos, atlassian giving, environmental impact, sustainability, likes for good, atlassian social responsibility, community challenge

Make every click count—help us plant 50,000 trees! 🌳

Want to make your everyday Community actions directly contribute to reforestation? The Atlassian Community can achieve this goal by liking a post, attending an ACE, sending your peers kudos, and so much more!

Help us plant more trees
AUG Leaders

Atlassian Community Events