cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Help us improve the PTC Community by taking this short Community Survey! X

Connection to BigQuery Fails with JDBC connector

saguiarde
10-Marble

Connection to BigQuery Fails with JDBC connector

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 1

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

 

Top Tags