I have JRE installed:
Code:
$ java -version java version "10" 2018-03-20 Java(TM) SE Runtime Environment 18.3 (build 10+46) Java HotSpot(TM) 64-Bit Server VM 18.3 (build 10+46, mixed mode)
I unzipped that into ~/ado/simba_jdbc, which is on my ado-path:
Code:
. adopath [1] (BASE) "/Applications/Stata/ado/base/" [2] (SITE) "/Applications/Stata/ado/site/" [3] "." [4] (PERSONAL) "/Users/dimitriy/ado/" [5] (PLUS) "/Users/dimitriy/Library/Application Support/Stata/ado/plus/" [6] (OLDPLACE) "~/ado/" [7] "~/ado/simba_jdbc"
I am able to jdbc connect (or there are no errors):
Code:
. #delimit cr delimiter now cr . set debug on . local jar "GoogleBigQueryJDBC42.jar" . local driverclass "com.simba.googlebigquery.jdbc.Driver" . local url "jdbc:bigquery://https://www.googleapis.com/bigquery/v2:443;ProjectId=XXXX;OAuthType=YYY;OAuthRefreshToken=ZZZ;" . local user "AAAA" . local pass "BBBB" . jdbc connect, jar(`"`jar'"') driverclass("`driverclass'") url("`url'") user("`user'") password("`pass'") Classpaths: file:/Applications/Stata/ado/base/jar/libstata-plugin.jar Classpaths (add): file:/Users/dimitriy/ado/simba_jdbc/GoogleBigQueryJDBC42.jar file:/Applications/Stata/ado/base/jar/libstata-plugin.jar Classpaths: file:/Applications/Stata/ado/base/jar/libstata-plugin.jar
Code:
. jdbc showtable Classpaths: file:/Applications/Stata/ado/base/jar/libstata-plugin.jar java.lang.ClassNotFoundException: com.google.auth.http.HttpTransportFactory at java.base/java.net.URLClassLoader.findClass(URLClassLoader.java:471) at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:589) at java.base/java.net.FactoryURLClassLoader.loadClass(URLClassLoader.java:899) at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:522) at com.simba.googlebigquery.googlebigquery.core.BQConnection.connect(Unknown Source) at com.simba.googlebigquery.jdbc.common.BaseConnectionFactory.doConnect(Unknown Source) at com.simba.googlebigquery.jdbc.common.AbstractDriver.connect(Unknown Source) at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677) at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:189) at com.stata.plugins.jdbc.StJdbc.getConnection(StJdbc.java:168) at com.stata.plugins.jdbc.StJdbc.showTables(StJdbc.java:1796) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at com.stata.Javacall.load(Javacall.java:270) at com.stata.Javacall.load(Javacall.java:92) r(5100);
0 Response to JDBC connection to Google BigQuery Database
Post a Comment