dbeaver / dbeaver/dbeaver

VECTOR type support Oracle DB

Open
#41,484 3 comments 0 reactions 0 assignees View on GitHub
x:oracle xf:data editor
Dominant language
Java
Stars
51.8k
Forks
4.4k
Avg merge
3d 8h
Merged PRs (30d)
188

Description

**Is your feature request related to a problem? Please describe.**
Vector type support for Oracle DB queries.
By default it does not show anything but an error.

**Describe the solution you'd like**
Have the type supported out of the box and fully explorable.

I have seen there is a specifc visualization for VECTOR type in other PRs (#23391)

**Describe alternatives you've considered**
Setting manually driver property `oracle.jdbc.vectorDefaultGetObjectType=double[]`, but at least it should be set by default.
In this way It shown in the column row, but in the Value panel it is showed as object address (I suppose), so the support is not complete.

Image

**Additional context**
When selecting a column with a vector type, there is the error:
```
org.jkiss.dbeaver.model.exec.DBCException: SQL Error [17004] [99999]: ORA-17004: Invalid column type: JDBC 4.3 does not specify a default conversion for VECTOR. A default conversion may be configured using the "oracle.jdbc.vectorDefaultGetObjectType" connection property
https://docs.oracle.com/error-help/db/ora-17004/
```

Oracle's relative documentation: https://docs.oracle.com/en/database/oracle/oracle-database/26/jjdbc/working-with-vectors.html

Contributor guide

Open the contributing guide

Research direction

Start by examining DBeaver's Oracle database handling and the JDBC property oracle.jdbc.vectorDefaultGetObjectType described in the issue. Compare the existing VECTOR visualization referenced in PR #23391 with the current column-row and Value panel behavior. Done means Oracle VECTOR columns can be selected without ORA-17004 and their values are displayed rather than as object addresses.

Written by the indexing model from the issue text.

Assessment

Tech stack
java
Domain
databases
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Active
Clarity
Mostly clear
Newbie friendliness
50/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.