Usage of Google Drive via Hop

[dave-csc]

Hello,

in our organization we're trying to setup a Google Drive repository to exchange files created/readable by Hop.

To do so, our Google Drive administrator gave me the JSON credential file that I linked in the Hop configuration, and activated a project that can use the Google Drive API.

With this configuration, I can log in to Google and get a token file, but when I try to access the files in "My Drive" folder as explained in the documentation I still get the following exception in the file browser:

Error browsing to location: 'googledrive://'
FileSystemException: Unknown message with code "Unable to get Google Drive file object for 'googledrive:///Foglio di lavoro senza nome'".
Root cause: ClassCastException: class com.google.api.client.auth.oauth2.StoredCredential cannot be cast to class com.google.api.client.auth.oauth2.StoredCredential (com.google.api.client.auth.oauth2.StoredCredential is in unnamed module of loader 'app'; com.google.api.client.auth.oauth2.StoredCredential is in unnamed module of loader org.apache.hop.core.plugins.HopURLClassLoader @2b6fcca1)

org.apache.commons.vfs2.FileSystemException: Unknown message with code "Unable to get Google Drive file object for 'googledrive:///Foglio di lavoro senza nome'".
	at org.apache.hop.vfs.googledrive.GoogleDriveFileSystem.processFile(GoogleDriveFileSystem.java:74)
	at org.apache.hop.vfs.googledrive.GoogleDriveFileSystem.resolveFile(GoogleDriveFileSystem.java:53)
	at org.apache.commons.vfs2.provider.AbstractFileObject.resolveFile(AbstractFileObject.java:1801)
	at org.apache.commons.vfs2.provider.AbstractFileObject.resolveFiles(AbstractFileObject.java:1839)
	at org.apache.commons.vfs2.provider.AbstractFileObject.getChildren(AbstractFileObject.java:1124)
	at org.apache.hop.ui.core.vfs.HopVfsFileDialog.populateFolder(HopVfsFileDialog.java:941)
	at org.apache.hop.ui.core.vfs.HopVfsFileDialog.refreshBrowser(HopVfsFileDialog.java:898)
	at org.apache.hop.ui.core.vfs.HopVfsFileDialog.enteredFilenameOrFolder(HopVfsFileDialog.java:686)
	at org.apache.hop.ui.core.vfs.HopVfsFileDialog.lambda$open$2(HopVfsFileDialog.java:331)
	at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:91)
	at org.eclipse.swt.widgets.Display.sendEvent(Display.java:5855)
	at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1617)
	at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:5065)
	at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:4517)
	at org.apache.hop.ui.core.vfs.HopVfsFileDialog.open(HopVfsFileDialog.java:584)
	at org.apache.hop.ui.core.dialog.BaseDialog.presentFileDialog(BaseDialog.java:278)
	at org.apache.hop.ui.core.dialog.BaseDialog.presentFileDialog(BaseDialog.java:128)
	at org.apache.hop.ui.hopgui.delegates.HopGuiFileDelegate.fileOpen(HopGuiFileDelegate.java:80)
	at org.apache.hop.ui.hopgui.HopGui.menuFileOpen(HopGui.java:709)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:568)
	at org.apache.hop.ui.core.gui.BaseGuiWidgets.lambda$getListener$1(BaseGuiWidgets.java:213)
	at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:91)
	at org.eclipse.swt.widgets.Display.sendEvent(Display.java:5855)
	at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1617)
	at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:5065)
	at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:4517)
	at org.apache.hop.ui.hopgui.HopGui.open(HopGui.java:476)
	at org.apache.hop.ui.hopgui.HopGui.main(HopGui.java:354)
Caused by: org.apache.commons.vfs2.FileSystemException: Unknown message with code "class com.google.api.client.auth.oauth2.StoredCredential cannot be cast to class com.google.api.client.auth.oauth2.StoredCredential (com.google.api.client.auth.oauth2.StoredCredential is in unnamed module of loader 'app'; com.google.api.client.auth.oauth2.StoredCredential is in unnamed module of loader org.apache.hop.core.plugins.HopURLClassLoader @2b6fcca1)".
	at org.apache.hop.vfs.googledrive.GoogleDriveFileObject.<init>(GoogleDriveFileObject.java:98)
	at org.apache.hop.vfs.googledrive.GoogleDriveFileSystem.createFile(GoogleDriveFileSystem.java:39)
	at org.apache.hop.vfs.googledrive.GoogleDriveFileSystem.processFile(GoogleDriveFileSystem.java:72)
	... 30 more
Caused by: java.lang.ClassCastException: class com.google.api.client.auth.oauth2.StoredCredential cannot be cast to class com.google.api.client.auth.oauth2.StoredCredential (com.google.api.client.auth.oauth2.StoredCredential is in unnamed module of loader 'app'; com.google.api.client.auth.oauth2.StoredCredential is in unnamed module of loader org.apache.hop.core.plugins.HopURLClassLoader @2b6fcca1)
	at com.google.api.client.auth.oauth2.AuthorizationCodeFlow.loadCredential(AuthorizationCodeFlow.java:280)
	at com.google.api.client.extensions.java6.auth.oauth2.AuthorizationCodeInstalledApp.authorize(AuthorizationCodeInstalledApp.java:101)
	at org.apache.hop.vfs.googledrive.GoogleDriveFileObject.getCredentials(GoogleDriveFileObject.java:247)
	at org.apache.hop.vfs.googledrive.GoogleDriveFileObject.getDriveService(GoogleDriveFileObject.java:251)
	at org.apache.hop.vfs.googledrive.GoogleDriveFileObject.<init>(GoogleDriveFileObject.java:95)
	... 32 more

Are there any other authorization that should be given by the Google Drive administrator, or there's something wrong with the configuration?

Thanks for your support

[bamaer]

this is related to the known open issue #2524