Spotfire Server : Which Oracle driver do I need for my Spotfire Server?

If your Spotfire server installation uses an Oracle database for the Spotfire database, or if any information services make use of an Oracle database, the correct driver needs to be installed on the Spotfire server.

The TIBCO Spotfire server is bundled with Data Direct driver for connections to the Spotfire Oracle Database.

When selecting this driver in the UI config tool (Configure TIBCO Spotfire Server), it will be displayed as "Oracle DataDirect"



and show a JDBC URL that includes "tibcosoftwareinc"



This driver is not recommended for production use. Instead download an Oracle JDBC driver directly from Oracles website and use that instead.

To know what the correct driver is to use, the Oracle version and JVM version must be known.
The JVM version can be determined by running the version.(sh|bat) command which is located in the <installation root>\tomcat\bin directory.

Using CATALINA_BASE: /opt/tibco/tss/12.0.0/tomcat
Using CATALINA_HOME: /opt/tibco/tss/12.0.0/tomcat
Using CATALINA_TMPDIR: /opt/tibco/tss/12.0.0/tomcat/temp
Using JRE_HOME: /opt/tibco/tss/12.0.0/jdk
Using CLASSPATH: /opt/tibco/tss/12.0.0/tomcat/spotfire-boot-lib/*:/opt/tibco/tss/12.0.0/tomcat/bin/bootstrap.jar:/opt/tibco/tss/12.0.0/tomcat/bin/tomcat-juli.jar
Using CATALINA_OPTS: -Xms512M -Xmx4096M -Dorg.apache.catalina.session.StandardSession.ACTIVITY_CHECK=true -Dorg.apache.catalina.startup.EXIT_ON_INIT_FAILURE=true -DLog4jContextSelector=org.apache.logging.log4j.core.async.AsyncLoggerContextSelector -Dlog4j.configurationFile=/opt/tibco/tss/12.0.0/tomcat/spotfire-config/log4j2-tomcat.xml -Dlog4j.configurationFactory=com.spotfire.server.tomcat.log.integration.SpotfireConfigurationFactory -Djava.util.logging.manager=org.apache.logging.log4j.jul.LogManager -Djava.library.path=/opt/tibco/tss/12.0.0/tomcat/spotfire-lib:/opt/tibco/tss/12.0.0/tomcat/custom-ext
NOTE: Picked up JDK_JAVA_OPTIONS: --add-opens=java.base/java.lang=ALL-UNNAMED --add-opens=java.base/java.io=ALL-UNNAMED --add-opens=java.base/java.util=ALL-UNNAMED --add-opens=java.base/java.util.concurrent=ALL-UNNAMED --add-opens=java.rmi/sun.rmi.transport=ALL-UNNAMED
Server version: Apache Tomcat/9.0.63
Server built: May 11 2022 07:52:11 UTC
Server number: 9.0.63.0
OS Name: Linux
OS Version: 4.18.0-425.3.1.el8.x86_64
Architecture: amd64
JVM Version: 17.0.3+8-LTS-111
JVM Vendor: Oracle Corporation

Then visit the Oracle JDBC driver site to obtain the driver, looking a your JVM version and Oracle server version.

For example, using the output from the version command above, the ojdbc11.jar would be the correct driver to use.

The driver should be copied to the

<installation root>\custom-ext

directory on your spotfire server.

The service would then need to be restarted so it can be available for selection when running the Spotfire Configuration Tool, or setting up an Information Services. Please see here for more details.