apache / apache/hop

[Bug]: GEOMETRY not supported by Oracle plugin

Open
#2,747 3 comments 0 reactions 0 assignees View on GitHub
awaiting triage Database P3 Transforms
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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.