Getting Array base type information from DatabaseMetaData

Lance Andersen lance.andersen at
Tue Oct 5 21:55:56 UTC 2021

Hi Dave,

There  indeed does not appear to be a way to return the actual type of the SQL Array via DatabaseMetaData.getColumns (most likely due to the lack of use of SQL Array at the time and it was an oversight).

 As to what could be done, we could repurpose the SOURCE_DATA_TYPE column or add a 25th column called ARRAY_TYPE.

It would probably be best to add the ARRAY_TYPE to the ResultSet returned from getColumns()


On Oct 1, 2021, at 9:12 AM, Dave Cramer <davecramer at<mailto:davecramer at>> wrote:


I'm looking at how to provide base type information for arrays from

getColumns has no way to return the base type. The best we can do is return

Seems to me this is a gap. Am I missing something?

Dave Cramer

[cid:E1C4E2F0-ECD0-4C9D-ADB4-B16CA7BCB7FC at home]

Lance Andersen| Principal Member of Technical Staff | +1.781.442.2037
Oracle Java Engineering
1 Network Drive
Burlington, MA 01803
Lance.Andersen at<mailto:Lance.Andersen at>

More information about the jdbc-spec-discuss mailing list