dynamobi/dynamobi — Issue #710: [FRG-162] browse foreign schemas doesn't return schemas if qualifying_catalog_name is specified for jTDS jdbc driver
Author: dynamobi-build
Created: 2011-12-30 03:44:39+00:00
State: open
Labels: FRG, JDBC Foreign Data Wrapper

[reporter="elin", created="Thu, 29 Jun 2006 18:36:59 -0500 (GMT-05:00)"]
The net.sourceforge.jtds.jdbc.JtdsDatabaseMetaData.getSchemas() call doesn't return information for catalogs. Since we're filtering the schemas on the catalog name if it's specified via qualifying_catalog_name, no schemas will be returned for browse_foreign_schemas.

A workaround for this is to set the default catalog to the catalog desired for the user and then don't specify qualifying_catalog_name when the server is defined.