[Bug]: GEOMETRY not supported by Oracle plugin
- Dominant language
- Java
- Stars
- 1.5k
- Forks
- 476
- Avg merge
- 18h 33m
- Merged PRs (30d)
- 204
Description
### 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
Contributor guide
Research direction
Start by reproducing the geometry-column failure in the Table Input transform with the Oracle plugin and the ojdbc8.jar and xdb.jar files under plugins/databases/oracle/lib. Review the gis plugin path referenced by the stacktrace. Done means Oracle GEOMETRY values can be selected without the XML-type error, empty results, or STRUCT cast failure.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java
- Domain
- database
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Quiet
- Clarity
- Mostly clear
- Newbie friendliness
- 48/100