Versions Compared

Version Old Version 13 New Version 14
Changes made by

Stefan Franz

Stefan Franz

Saved on

Key

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

...

https://www.oracle.com/de/database/technologies/appdev/jdbc-downloads.html

MSSQL

Infonote

Optimal performance can only be reached when the connection string contains sendStringParametersAsUnicode=false . Is this parameter missing the created indexes cannot be used and queries will be significant slower!

Code Block
<repoName>.metaservice.databasev2.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
<repoName>.metaservice.databasev2.url=jdbc:sqlserver://localhost:1433;databaseName=CONTENTSERVER;sendStringParametersAsUnicode=false

Depending on your configuration and version of MS SQL Server you need additional properties in the connection string:

  • encrypt=true;

  • trustServerCertificate=true;

Code Block
<repoName>.metaservice.databasev2.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
<repoName>.metaservice.databasev2.url=jdbc:sqlserver://localhost:1433;databaseName=CONTENTSERVER;encrypt=true;trustServerCertificate=true;sendStringParametersAsUnicode=false

Driver is included from Version 2.3.0, for older Version driver can be found here:
https://docs.microsoft.com/de-de/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-ver16

...