'Error creating a database connection: Cannot initiate JDBC driver with class name oracle jdbc Oracle Driver' is returned while accessing TIBCO Spotfire configuration tool.

'Error creating a database connection: Cannot initiate JDBC driver with class name oracle jdbc Oracle Driver' is returned while accessing TIBCO Spotfire configuration tool.

After importing the Spotfire configuration tool from a Spotfire server (installation dir>/tomcat/webapps/spotfire/tools/spotfireconfigtool.jar) and running it on a local computer, below error is seen while accessing bootstrap file after providing the correct configuration tool password.


  This error is especially seen if the bootstrap created on the Spotfire server is using Oracle thin driver for Spotfire database. Generally, while importing the "installation dir>/tomcat/webapps/spotfire/tools/spotfireconfigtool.jar" file from Spotfire server machine to the Local computer, it is expected that only the following jar files are extracted under "spotfireconfigtool\lib" on the local machine.

bcprov-jdk15on-1.60.jar
miglayout-4.2-swing.jar
servlet-api.jar
spotfire-tss-tools.jar
sqljdbc4.jar
TIoracle.jar
TIsqlserver.jar

Since 'ojdbc' jar file is not copied over to local computer, the above described error is seen only with Oracle drivers. To resolve this, copy the "ojdbc" jar file from Spotfire server machine to "spotfireconfigtool\lib" on the local machine, reopen the configuration tool via uiconfig.bat and enter the tool password. The bootstrap should come up without any errors.

Note: The same issue can be seen in case there is any data source driver other than the out-of-box ones used in the bootstrap. So, ensure that the corresponding jar file needs to be copied over to "spotfireconfigtool\lib" on the local machine. Doc: Running the configuration tool on a local computer

• https://docs.tibco.com/pub/spotfire_server/10.3.4/doc/html/TIB_sfire_server_tsas_admin_help/GUID-64C519C3-4EF6-4285-A2CF-F4E319682C41.html