Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

coldfusion and bigquery

New Here ,
May 28, 2019 May 28, 2019

Anyone have any experience setting up the Simba JDBC driver for Google BigQuery using service account authentication?

The problem seems to be reading the file  which is defined in the OAuthPvtKeyPath which is a part of the JDBC URL.

When I submit the form with the JDBC URL, Driver Class, Driver Name etc I receive the following error:

java.sql.SQLNonTransientConnectionException: [Simba][JDBC](10100) Connection Refused: [Simba][JDBC](11640) Required Connection Key(s): OAuthPvtKeyPath, OAuthServiceAcctEmail, ProjectId

All three parameters (OAuthPvtKeyPath, OAuthServiceAcctEmail and Projectid) is part of the JDBC URL like this example from the Simba JDBC driver user manual (except from the OAuthPvtKeyPath which is the path I'm using on my Mac):

jdbc:bigquery://https://www.googleapis.com/bigquery/v2:443;

ProjectId=MyBigQueryProject;OAuthType=0;

OAuthServiceAcctEmail=bqtest1@data-drivertesting.

iam.gserviceaccount.com;

OAuthPvtKeyPath=/Applications/ColdFusion2018/cfusion/lib/myfilewithkeys.json;

TOPICS
Database access
520
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
no replies

Have something to add?

Join the conversation
Resources