LordThread / starschema-bigquery-jdbc

Automatically exported from code.google.com/p/starschema-bigquery-jdbc
0 stars 0 forks source link

Starschema JDBC for BigQuery #17

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago
I am facing an issue with Starschema JDBC driver for BigQuery while testing the 
queries through Apache JMeter. 

For this test, I got the JDBC driver (bqjdbc-1.4.jar) from 
"https://code.google.com/p/starschema-bigquery-jdbc/downloads/list" URL and 
tested the driver through another third party tool called Squirrel. This works 
fine. 

The same jdbc driver is copied to the Apache JMeter server lib directory as 
shown in the below path. 

/jm/apache-jmeter-2.13/lib/bqjdbc-1.4.jar

Once the driver is copied, I was not able to start the JMeter and it returns 
the error message as mentioned below. But I was able to start JMeter if the BQ 
JDBC jar is not copied into "/jm/apache-jmeter-2.13/lib" directory. 

./startJMeterMaster 
An error occurred: Cannot inherit from final class

I tried an another an option by replacing the BigQuery jdbc driver with 
standalone version i.e from 
https://code.google.com/p/starschema-bigquery-jdbc/downloads/detail?name=bqjdbc-
1.4-standalone.jar

With this jar file, I was able to start JMeter with no issue, but when I run 
the query it returns an error as mentioned in the attached file 
(jmeter_standalone.log). 

Later, I copied required jar files from Google API client library 
(https://developers.google.com/api-client-library/java/apis/bigquery/v2?hl=en), 
but I end up in different error while running the query as specified below. The 
detailed error message is in the attached file (jmeter_jackson.log)

Uncaught Exception java.lang.NoClassDefFoundError: 
com/google/api/client/json/jackson/JacksonFactory. See log file for details.

How do I resolve the above reported issue?

Do you have any different version of JDBC driver which supports Apache JMeter 
2.13? 

FYI - Apache JMeter is running on Redhat Enterprise Linux Server Release 6.6

Suggestion from your end is greatly appreciated. 

Original issue reported on code.google.com by arengas...@avaya.com on 20 Aug 2015 at 10:19

Attachments: