Bigquery jdbc connector "NoClassDefFoundError"

[porpor]

Hi

I'm trying to connect Bigquery via Simba jdbc but I got this error.

Starting job testConn at 15:54 20/04/2022.

[statistics] connecting to socket on port 3527

[statistics] connected

Exception in thread "main" java.lang.NoClassDefFoundError: com/google/api/client/json/gson/GsonFactory

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.DriverManager.getConnection(Unknown Source)

at java.sql.DriverManager.getConnection(Unknown Source)

at routines.system.SharedDBConnection.getConnection(SharedDBConnection.java:63)

at routines.system.SharedDBConnection.getDBConnection(SharedDBConnection.java:131)

at local_project.testconn_0_1.testConn$2.getDBConnection(testConn.java:557)

at org.talend.components.jdbc.runtime.JdbcRuntimeUtils.createConnectionOrGetFromSharedConnectionPoolOrDataSource(JdbcRuntimeUtils.java:201)

at org.talend.components.jdbc.runtime.JDBCSourceOrSink.connect(JDBCSourceOrSink.java:217)

at org.talend.components.jdbc.runtime.setting.JdbcRuntimeSourceOrSinkDefault.initConnection(JdbcRuntimeSourceOrSinkDefault.java:46)

at org.talend.components.jdbc.runtime.JdbcRuntimeUtils.validate(JdbcRuntimeUtils.java:114)

at org.talend.components.jdbc.runtime.JDBCSourceOrSink.validate(JDBCSourceOrSink.java:121)

at local_project.testconn_0_1.testConn.tDBConnection_4Process(testConn.java:420)

at local_project.testconn_0_1.testConn.runJobInTOS(testConn.java:731)

at local_project.testconn_0_1.testConn.main(testConn.java:575)

Caused by: java.lang.ClassNotFoundException: com.google.api.client.json.gson.GsonFactory

at java.net.URLClassLoader.findClass(Unknown Source)

at java.lang.ClassLoader.loadClass(Unknown Source)

at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)

at java.lang.ClassLoader.loadClass(Unknown Source)

... 16 more

[statistics] disconnected

Job testConn ended at 15:54 20/04/2022. [Exit code = 1]

Here is my configuration

JDBC URL: jdbc:bigquery://https://www.googleapis.com/bigquery/v2:443;ProjectId=<myProject>;OAuthType=0;OAuthServiceAcctEmail=<serviceAccount>;OAuthPvtKeyPath=<keyPath>

Keep user name and password empty.

[Anonymous]

Hello

The error means the required jar is missing or you included a wrong version of jar files, take a look at this similar topic that shows how to add the driver jars.

Regards

Shong