JDBC driver metadata does list vector columns

[jpechane]

Driver version

13.2.1.jre11

SQL Server version

Microsoft SQL Server 2025 (RTM) - 17.0.1000.7 (X64)

Client Operating System

Fedora Linux

JAVA/JVM version

Java 21

Table schema

CREATE TABLE vector_table (id int primary key, cola VECTOR(3) NOT NULL)

Problem description

Call to DatabaseMetaData.getColumns() lists only the id column

Root cause

The method in question depends on sys.sp_columns. The procedure does not return the columns too.

Proposed solution

The method should be rewritten to use SQL Server information schema so it is not limited by ODBC.