Connection to BigQuery Fails with JDBC connector

[saguiarde]

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: 

I have tried these connection strings: 

SELECT CURRENT_TIMESTAMP()

SELECT NOW()

[tmisner]

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