Projects tigase _server tigase-server Issues #12
Switch jdbc driver for MS SQL Server from jtds to MicroSoft own driver (#12)
Closed
wojciech.kapcia@tigase.net opened 2 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

wojciech.kapcia@tigase.net commented 2 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.net 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)

issue 1 of 1
Type
Bug
Priority
Normal
Assignee
Version
tigase-server-8.3.0
Issue Votes (0)
Watchers (0)
Reference
tigase/_server/tigase-server#12
Please wait...
Page is in error, reload to recover