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:
2. Restart the Tibco Spotfire Statistics Services server.
For details, see Configuring a non-default database and Configuring the JDBC driver.
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
2. Restart the Tibco Spotfire Statistics Services server.
For details, see Configuring a non-default database and Configuring the JDBC driver.