Projects tigase _server server-core Issues #1476
SQL Server driver throws an exception on latest 8.3.0 builds (#1476)
Closed
Unknown opened 2 years ago

Describe the bug The SQL Server DB Driver is broken on JDK 17 and throws this exception: Problem validating database connection: java.lang.NoClassDefFoundError: org/ietf/jgss/GSSException

To Reproduce Steps to reproduce the behavior:

  1. Do web install
  2. Select SQL Server as DB Backend
  3. Try to authenticate with SQL Server

Impact Can't use SQL Server as DB Backend

Expected behavior A clear and concise description of what you expected to happen.

Screenshots If applicable, add screenshots to help explain your problem.

Details (please complete the following information):

  • Tigase version: 8.3.0
  • JVM flavour and version [e.g. OpenJDK17]
  • Windows Server 2022 on WSL2 Docker (Docker Desktop)
Unknown commented 2 years ago

Could you share complete logs from the console (including complete stacktrace)?

Which 8.3.0 release did you you exactly (flavour, build number, download link)?

Unknown commented 2 years ago

I'd have to replicate the environment again for the traces, anyhow I tested against SQL Server 2019 and replicated the issue over all the 8.3 nightlies I found on dockerhub. While on latest builds (8.2.1) it works although the schema update always fails at admin adding/post actions. The only difference appears to be Jdk11 vs. Jdk17.

Unknown commented 2 years ago

Thank you for reporting this. It was due to using old jTDS driver for MS SQL Server database (which was the only FOSS option at the time a couple of years back). It was however not updated for a long time and when we switched to JDK17 it broke altogether. Luckily Microsoft now publishes completely FOSS SQL Server JDBC driver so we switched to it now. Next nightly (docker) builds will contain updated driver.

issue 1 of 1
Type
Bug
Issue Votes (0)
Watchers (0)
Reference
tigase/_server/server-core#1476
Please wait...
Page is in error, reload to recover