[Bug]: GEOMETRY not supported by Oracle plugin

[hansva]

Apache Hop version?

2.3

Java version?

11

Operating system

Windows

What happened?

Migration: https://issues.apache.org/jira/browse/HOP-4256

I added an ojdbc8.jar to the plugins/databases/oracle/lib folder.

Using the "Table Input" I select a geometry column.  This results in an error about missing xml type.  So I add xdb.jar to the same folder.

Now the result is all empty values for the geometry column.

On adding the gis plugin the result is a stacktrace stating:

class oracle.sql.STRUCT cannot be cast to class oracle.sql.STRUCT

Issue Priority

Priority: 3

Issue Component

Component: Database, Component: Transforms

[rdubois-mel]

I'm trying to make the AtolCD GIS plugin work with an Oracle connection.

I modified the code, as I explain here: atolcd/hop-gis-plugins#16, and I can now do SELECTs.

But I'm stuck on INSERT/UPDATE, I always have the following error:

class oracle.jdbc.driver.T4CConnection cannot be cast to class oracle.jdbc.OracleConnection (oracle.jdbc.driver.T4CConnection is in unnamed module of loader org.apache.hop.core.plugins.HopURLClassLoader @313193f6; oracle.jdbc.OracleConnection is in unnamed module of loader org.apache.hop.core.plugins.HopURLClassLoader @3dcf6026)

and I can't find a solution.

I'm not a Java expert, does anyone know how to solve this damn "is in unnamed module of loader" error? :)

Thanks!

[rdubois-mel]

I tried to remove the ojdbc jar from the plugin, to avoid a conflict with the one loaded for Hop, but when I do that the selects don't work at all anymore...
I tried to force the loading of the classes not found, but without success..
I continue to investigate, but I don't have too many ideas anymore. 😢