Hi all,
after upgrading to FME 2018.1 we are not able to connect to MS SQL Server anymore. This seems to be due to an invalid connection parameter:
Using Java Reader Interface Version 2.0 (Oct 31, 2000) with module MSSQL_JDBC_SPATIAL to read data
MS SQL Server Spatial (JDBC) Reader: Preloading JDBC Driver Class 'com.microsoft.sqlserver.jdbc.SQLServerDriver'
MS SQL Server Spatial (JDBC) Reader: Creating connection using connection string 'jdbc:sqlserver://************' and properties '{statementPoolingCacheSize=10, disableStatementPooling=false, integratedSecurity=false, user=************, encrypt=false, multiSubnetFailover=false, trustServerCertificate=true, applicationName=Safe Software FME, database=************, password=************}'
com.microsoft.sqlserver.jdbc.SQLServerException: The disableStatementPooling value false is not valid.However, I don't see an option to control statement pooling on the connection or reader level. And even if I would, I'm kind of concerned what the performance impact might be if we would disable pooling...
We get this error only on FME Server 2018.1 (which is running inside a docker environment). On FME Workbench 2018.1 the same workspace runs without issues (on Windows and Mac OS). It also ran perfectly fine with FME Server 2017.1.
What can we do to get around this issue?
Thanks!