Error while starting Tibco Spotfire Statistics Services server with Java 11 with error "Could not open JDBC Connection for transaction"

Product:TIBCO Spotfire Statistics Services
Versions:10.10 and higher

Summary:
Error while starting Tibco Spotfire Statistics Services server with Java 11 with error "Could not open JDBC Connection for transaction"

Details:
While first starting up Tibco Spotfire Statistics Services (TSSS) server version 10.10 with a Microsoft SQL Server as the application database, the startup may fail with the following error message recorded in the \tomcat\logs:

04-Jan-2021 22:03:13.091 SEVERE [main] org.apache.catalina.core.StandardContext.listenerStart Exception sending context initialized event to listener instance of class [org.springframework.web.context.ContextLoaderListener]
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'com.insightful.splusserver.SplusStateInitializer#0' defined in class path resource [applicationContext-job-execution.xml]: Invocation of init method failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.lang.NoClassDefFoundError: javax/xml/bind/DatatypeConverter

Resolution:
To resolve the above error, you need to update the Microsoft SQL Server JDBC driver to a version which is compatible with the Java 11 version used by TSSS.

1. Download the latest JDBC driver bundle from Microsoft here:  https://docs.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-ver15
In the download, there will be several drivers:

• mssql-jdbc-8.4.1.jre8.jar
• mssql-jdbc-8.4.1.jre11.jar
• mssql-jdbc-8.4.1.jre14.jar

Place the jre11 jar file in the SPSERVER_HOME/endorsed directory, or SPSERVER_SHARE/endorsed for a clustered environment, of the Tibco Spotfire Statistics Services server.

2. Restart the Tibco Spotfire Statistics Services server.

For details, see Configuring a non-default database and Configuring the JDBC driver.