PDA

View Full Version : Trouble connecting to Google BigQuery jdbc



crash
11-02-2012, 03:52 PM
I am trying to use starschema-bigquery-jdbc (http://code.google.com/p/starschema-bigquery-jdbc/) to connect to BigQuery and when I put the jar file in administration-console/jdbc/ PAC crashes on start up.
Part of the error message is "java.lang.NoSuchMethodError: org.mortbay.jetty.Request.getUserRealm pentaho"

Dezzsoke
06-24-2013, 08:33 AM
I just discovered your problem, the solution is:
1. download the Standalone version of the driver from the project homepage: https://code.google.com/p/starschema-bigquery-jdbc/
https://code.google.com/p/starschema-bigquery-jdbc/downloads/detail?name=bqjdbc-1.4-standalone.jar&can=2&q=
Please note that this version doesn't have any kind of dependency included in it, so you'll have to find the dependencies.
2. download the dependencies made for Kettle from:
https://code.google.com/p/starschema-bigquery-jdbc/downloads/detail?name=dependencies%20for%20kettle.zip&can=2&q=

Then put the JDBC jar into:
data-integration\libext\JDBC\

then extract the dependencies jar under:
data-integration\libswt\win32\
OR
data-integration\libswt\win64\
depending which version of kettle you're running

I tested it with the latest 4.4.0 version of Kettle

I also made a wiki entry:
https://code.google.com/p/starschema-bigquery-jdbc/wiki/PentahoDataIntegrationakaKettle

If you have further problems, please use the Issues page on google code.
https://code.google.com/p/starschema-bigquery-jdbc/issues/list

Dezzsoke
08-23-2013, 08:58 AM
Starschema's high performance Google bigquery JDBC Driver provides methods for querying and updating data in a Google BigQuery database.
Sadly bigquery doesn't support updates, so the JDBC also not able to update data.
Also you can't load data into bigquery through JDBC because the JAVA API is not designed for that.