Skip to main content
S
saguiarde1-Visitor
1-Visitor
July 27, 2020
Question

Connection to BigQuery Fails with JDBC connector

  • July 27, 2020
  • 1 reply
  • 893 views

Hello, 

 

I have tried to connect to BigQuery using the JDBC connector. I downloaded the driver and added to the <tomcat_home>\lib. However, I am still not able to access the database. I am getting this error: 

 

image.png

 

I have tried these connection strings: 

 

SELECT CURRENT_TIMESTAMP()

SELECT NOW()

 

 
 

 

 

1 reply

T
tmisner16-Pearl
16-Pearl
July 29, 2020

Hello saguiarde,

 

Lets get some more verbose logging for this by enabling Error Stack Tracing in the ErrorLog.log file. To do this access the LoggingSubsystem entity in ThingWorx. Navigate to the Configuration tab and tick "Enable Error Stack Tracing", save the entity.

 

Following this reproduce the connection attempt by simply re-saving your DatabaseThing. Afterwards grab the ApplicationLog, ErrorLog from ThingworxStorage\logs along with any time relevant Tomcat logs located under <Apache Tomcat Install>\logs.

 

-Tyler

 

Terms & ConditionsCookie settingsAccessibility statement