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

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

book

Article ID: KB0073244

calendar_today

Updated On:

Products Versions
Spotfire Statistics Services 10.10 and higher

Description

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

Issue/Introduction

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

Environment

Windows

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.

Additional Information

Doc: Configuring a non-default database Doc: Configuring the JDBC driver
Powered by Wolken Software