when a table/view in denodo has a $ in the name - the standard jdbc call to getColumns returns 0 rows.
No error is raised - it just reports that the table/view has no columns.
to fix this - there is a denodo stored procedure that can extract column metadata, including any with special characters (e.g. $). the procedure is CATALOG_VDP_METADATA_VIEWS (see here )
will need to be fully tested to make sure no information is missing. one area to look at is the column position, which is no returned, but can be implied by the row order returned.
darren-wrigley
commented
5 years ago
when a table/view in denodo has a $ in the name - the standard jdbc call to getColumns returns 0 rows.
No error is raised - it just reports that the table/view has no columns.
ResultSet columns = dbMetaData.getColumns(schemaName, null, tableName, null);to fix this - there is a denodo stored procedure that can extract column metadata, including any with special characters (e.g. $). the procedure is CATALOG_VDP_METADATA_VIEWS (see here )
will need to be fully tested to make sure no information is missing. one area to look at is the column position, which is no returned, but can be implied by the row order returned.