SICS 22.2

SE-11844 #

Unicode support in Microsoft SQL Server is now fully implemented via the use of the <unicodeMode>true</unicodeMode> datasource setting.

SE-11416 #

3rd party libraries used by SICS has been updated to their latest version, giving SICS access to new functionality and the latest security patches.

eMessaging #

SICS eMessaging Server now uses JAX-WS for creating and consuming Acord SOAP messages. This was changed to remove the dependency to XMLBeans 3.0.1.
In SICS folder conf/sics.emessaging.integration.properties the address to eMessaging Server is updated:

From:

acord.soap.server.url=http://hostname:portnumber/acord.soap/servlet/AxisServlet

To:

acord.soap.server.url=http://hostname:portnumber/acord.soap/wsdl/MyAcordMsgService.wsdl

MS SQL Server driver #

MS SQL Server driver was updated to version 11.2.x.

This driver version has a breaking change:
If want you use an unencrypted JDBC connection from SICS to your SQL Server DBMS, it is now required to explicitly set property encrypt=false on the JDBC connection string.

For details, please check the Microsoft official documentation at: https://docs.microsoft.com/en-us/sql/connect/jdbc/release-notes-for-the-jdbc-driver?view=sql-server-ver16

Sample config with unencrypted JDBC connection string:
(exerpt from sics-database-source.xml)

<source name="SQLServer">
  <driver>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver>
  <accessor>com.csc.troll.accessor.JDBCDatabaseAccessor</accessor>
  <interface>com.csc.troll.accessor.SQLServer2000Interface</interface>
  <dataSource>jdbc:sqlserver://hostname;sendStringParametersAsUnicode=false;selectMethod=cursor;encrypt=false</dataSource>
  <useParameterizedSql>true</useParameterizedSql>
  <statementCacheSize>100</statementCacheSize>		
  <!--  <caseSensitiveUserNames>true</caseSensitiveUserNames> -->
</source>

If you want to use an encrypted JDBC connection, a pre-requisite is to install and configure SSL/TLS support on your MS SQL Server DBMS.

For details, please check Microsofts official documentation at: https://docs.microsoft.com/en-us/sql/connect/jdbc/understanding-ssl-support?view=sql-server-ver16