JDBC driver. DatabaseMetadata.getTableTypes return empty result set

dqmdev · November 10, 2020, 5:50pm

When DatabaseMetadata.getTableTypes is called, Dremio Driver isn’t returning a Resultset to describe the available types.

Server version 4.9.3-202010281843560195-edc49b6d
Driver version 4.9.1-202010230218060541-2e764ed0

azary · March 11, 2022, 9:02pm

Hi, I encountered the same exact problem with Dremio server and JDBC driver version 20.1.0-202202061055110045-36733c65. Is there any resolution?

The empty ResultSet returned by the DatabaseMetadata.getTableTypes is breaking my metadata collection code. Any info will be appreciated.

azary · April 1, 2022, 8:47pm

Hi Dremio, this is a clear bug. Is there any plan to fix the issue in the driver?

balaji.ramaswamy · April 3, 2022, 6:46pm

@azary @dqmdev This will be fixed in the new driver. Will get back on the exact Dremio version it will be shipped with

dqmdev · April 15, 2022, 5:47pm

What build number will that fix be released in?

Topic		Replies	Views
JDBC driver DatabaseMetadata.getTtypeInfo returns empty result set	2	927	March 15, 2021
JDBC driver ResultsetMetadata does not return schema name	2	943	November 11, 2020
JDBC driver DatabaseMetadata.getCatalog returned null but other methods return catalog name Dremio	0	858	November 10, 2020
Mixed types are not supported as returned values over JDBC, ODBC and Flight connections	7	2217	March 24, 2021
JDBC driver returns a large set of unexpected schemas	7	1504	April 19, 2021