Highlighted

coldfusion and bigquery

New Here ,
May 28, 2019

Copy link to clipboard

Copied

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

Views

202

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

coldfusion and bigquery

New Here ,
May 28, 2019

Copy link to clipboard

Copied

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

Views

203

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
May 28, 2019 0

Have something to add?

Join the conversation