Hi Matt, I change the class name to the name you mentioned above and now I am getting this error:
java.lang.NoClassDefFoundError: com/google/api/client/json/JsonFactory: java.lang.NoClassDefFoundError: com/google/api/client/json/JsonFactory I added all of the jars to the database driver location(s) field as such: /home/mydir/google-api-client-1.22.0.jar, /home/mydir/google-api-services-bigquery-v2-rev320-1.22.0.jar, /home/mydir/GoogleBigQueryJDBC42.jar, /home/mydir/google-http-client-1.22.0.jar, /home/mydir/google-http-client-jackson2-1.22.0.jar, /home/mydir/google-oauth-client-1.22.0.jar, /home/mydir/jackson-core-2.1.3.jar Any further suggestions? I believe the JsonFactory is part of jackson-core-2.1.3.jar but for some reason its not seeing that jar? Thanks, Margarita On Thu, Aug 17, 2017 at 5:05 PM, Matt Burgess <[email protected]> wrote: > Margarita, > > Sorry to hear you're having trouble connecting. In this case, I believe it > is the Database Driver Class Name that is the issue. According to [1], > you'll want to use the following driver class name (rather than the > DataSource one you are using now): > > com.simba.googlebigquery.jdbc42.Driver > > Regards, > Matt > > [1] http://cdn.simba.com/products/BigQuery/doc/JDBC_ > InstallGuide/content/jdbc/using/class.htm > > > On Thu, Aug 17, 2017 at 5:04 PM, Margarita Uk <[email protected]> > wrote: > >> Hello, >> Has anyone had experience connecting to a private project in google >> bigquery? I have uploaded the jdbc driver to the server and I entered the >> connection information as such: >> >> [image: Inline image 1] >> >> It's throwing this error: >> >> Can't load Database Driver: >> org.apache.nifi.reporting.InitializationException: Can't load Database Driver >> >> >> >> Anyone have any insight???? >> >> Thanks!! >> > >
