Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This article provides steps for pre-checking the connection and instructions to add a profile with database type - Microsoft SQL Server.

Instructions

If you are observing the below error in the log (atlassian-confluence.log) files, perform the pre-checks that are mentioned below:

...

  1. If the Confluence instance is upgraded to any of the latest versions, i.e.,7.13.1 or higher, ensure the old( before upgrade) and new (after upgrade) Java files are not in the same place. If the files are located in the same place, then stop the Confluence, remove old files and restart the Confluence.

  2. Make sure the plugin is up-to-date.
  3. Use the maven link in the Driver JAR location instead of the path to the driver jar. The compatible jar versions are available here: https://repo1.maven.org/maven2/com/microsoft/sqlserver/mssql-jdbc/. Navigate to the respective jar version, use the link, and test the connection. If it works, then download the jar version from the same maven link and place it under the /opt/atlassian/confluence<confluence-Installation-directory>/confluence/WEB-INF/lib. 
  4. If you still observe the error as shown in the picture, then follow the below given instructions:

...


  1. Add the below JVM parameter line in setenv.sh file under: <Confluence_installation_directory>/bin/setenv.sh or <Confluence_installation_directory>/bin/setenv.bat, if it is Windows.

    Code Block
    languagebash
    themeMidnight
    CATALINA_OPTS="-Dadd-modules=java.xml.bind ${CATALINA_OPTS}"


  2. After After adding this entry, restart the Confluence and validate the SQL Pro profile against your SQL Server database.
  3. If you are still facing an issue, and your current java version is 1.11, then make it to 1.8 and re-check the connection.

...

Info