VECTOR type support Oracle DB
- 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.
**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
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