Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Trouble connecting to Google BigQuery jdbc

  1. #1
    Join Date
    Nov 2012
    Posts
    1

    Default Trouble connecting to Google BigQuery jdbc

    I am trying to use 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"

  2. #2
    Join Date
    Jun 2013
    Posts
    3

    Default

    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...e.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...e.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...ationakaKettle

    If you have further problems, please use the Issues page on google code.
    https://code.google.com/p/starschema...bc/issues/list
    Last edited by Dezzsoke; 06-24-2013 at 08:38 AM.

  3. #3
    Join Date
    Jun 2013
    Posts
    3

    Default

    Quote Originally Posted by benslinkard View Post
    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.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.