JDBC error when connecting to BigQuery with latest Simba Drivers

JDBC error when connecting to BigQuery with latest Simba Drivers

book

Article ID: KB0075703

calendar_today

Updated On:

Products Versions
Spotfire Data Science Team Studio 6.5.0

Description

End user gets an error when trying to connect to JDBC BigQuery using the latest Simba JDBC Drivers.

You may see this error in the production.log:
E, [2020-01-28T05:47:39.140609 #10342] ERROR -- : [c55b687d-0cde-4ce2-b497-f37486fd2b47] [current_user:id=2&username=noppol] JDBC error code = false
E, [2020-01-28T05:47:39.140880 #10342] ERROR -- : [c55b687d-0cde-4ce2-b497-f37486fd2b47] [current_user:id=2&username=noppol] Java::JavaLang::NoSuchMethodError: com.google.common.base.Splitter.splitToList(Ljava/lang/CharSequence;)Ljava/util/List;

 

Issue/Introduction

Unable to connect to BigQuery as a Data Source using latest Simba BigQuery Drivers

Resolution

Team Studio has only been tested to work with the Simba JDBC BigQuery Driver version 1.1.8.2020.  Any driver version later than 1.1.8.2020 will not work with Team Studio.

Please download the Simba JDBC BigQuery Driver Version 1.1.8.2020 that is attached to this KB article.  Ensure that you remove all old BigQuery JDBC Jars.

Reference to Connect to JDBC BigQuery in Team Studio 6.5.0
https://docs.tibco.com/pub/sfire-dsc/6.5.0/doc/html/TIB_sfire-dsc_6.5.0_install-admin/GUID-7721B84F-34DA-4816-BA5D-1324908A2E4B.html

Attachments

JDBC error when connecting to BigQuery with latest Simba Drivers get_app