Switch jdbc driver for MS SQL Server from jtds to MicroSoft own driver (#12)

Wojciech Kapcia (Tigase) opened 3 years ago

As reported in https://github.com/tigase/tigase-server/issues/159 - jTDS MS SQL Server driver is not compatible with JDK17. However, MS provides nowadays their own JDBC driver which is FOSS (MIT!): https://github.com/microsoft/mssql-jdbc

Activities

Wojciech Kapcia (Tigase) commented 3 years ago

Switched to:

<dependency>
    <groupId>com.microsoft.sqlserver</groupId>
    <artifactId>mssql-jdbc</artifactId>
    <version>10.2.1.jre17</version>
    <scope>runtime</scope>
</dependency>

Wojciech Kapcia (Tigase) commented 2 years ago

Unfortunately this broke pubsub, because MS SQL JDBC driver doesn't seem to allow transactions within StoredProcedures (vide ~~https://github.com/microsoft/mssql-jdbc/issues/1704~~ https://github.com/microsoft/mssql-jdbc/issues/2008). Disabling said explicit transactions fixes the issue and doesn't seem to cause issues (TTS-NG tests pass)
Login to comment

Type	Bug
Priority	Normal
Assignee	Wojciech Kapcia (Tigase)
Version	tigase-server-8.3.0

Issue Votes (0)

Watchers (0)

Reference

tigase/_server/tigase-server#12