[HOP-4256] GEOMETRY not supported by Oracle plugin

• Type: Bug
• Status: Closed
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: Migrated to GHI
• Component/s: Database
• Assignee: Unassigned
• Reporter: wayam
• Created: 29/Sep/22 20:12
• Updated: 20/Mar/23 14:43
• Resolved: 20/Mar/23 14:43

Description

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