[teiid-issues] [JBoss JIRA] Created: (TEIID-1359) DatabaseMetaData.getTables() not returning values when supplied with types.

[John Doyle (JIRA)]

DatabaseMetaData.getTables() not returning values when supplied with types.
---------------------------------------------------------------------------

                 Key: TEIID-1359
                 URL: https://jira.jboss.org/browse/TEIID-1359
             Project: Teiid
          Issue Type: Bug
          Components: JDBC Driver
    Affects Versions: 7.1.1
         Environment: SOA 5.1 ER3 w/ EDS, JBDS Beta 1
            Reporter: John Doyle
            Assignee: Steven Hawkins


I have a VDB deployed into EDS.  When I connect with a Hibernate config I don't get any tables back.  If I connect with the DTP tooling I do. The difference seems to be that Hibernate is passing "TABLE" and "VIEW" as table types, otherwise the params to the call are the same.

Here is the SQL created in the call that returns no tables:
SELECT VDBName AS TABLE_CAT, SchemaName AS TABLE_SCHEM, Name AS TABLE_NAME, CASE WHEN IsSystem = 'true' and UCASE(Type) = 'TABLE' THEN 'SYSTEM TABLE' ELSE UCASE(Type) END AS TABLE_TYPE, Description AS REMARKS, NULL AS TYPE_CAT, NULL AS TYPE_SCHEM, NULL AS TYPE_NAME, NULL AS SELF_REFERENCING_COL_NAME, NULL AS REF_GENERATION, IsPhysical AS ISPHYSICAL FROM SYS.Tables g  WHERE UCASE(VDBName) LIKE ? ESCAPE '\'  AND UCASE(SchemaName) LIKE ? ESCAPE '\'  AND UCASE(Name) LIKE ? ESCAPE '\'  AND (CASE WHEN IsSystem = 'true' and UCASE(Type) = 'TABLE' THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\'  OR CASE WHEN IsSystem = 'true' and UCASE(Type) = 'TABLE' THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\' ) ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME


And the SQL from the call that returns the correct tables.
SELECT VDBName AS TABLE_CAT, SchemaName AS TABLE_SCHEM, Name AS TABLE_NAME, CASE WHEN IsSystem = 'true' and UCASE(Type) = 'TABLE' THEN 'SYSTEM TABLE' ELSE UCASE(Type) END AS TABLE_TYPE, Description AS REMARKS, NULL AS TYPE_CAT, NULL AS TYPE_SCHEM, NULL AS TYPE_NAME, NULL AS SELF_REFERENCING_COL_NAME, NULL AS REF_GENERATION, IsPhysical AS ISPHYSICAL FROM SYS.Tables g  WHERE UCASE(VDBName) LIKE ? ESCAPE '\'  AND UCASE(SchemaName) LIKE ? ESCAPE '\'  AND UCASE(Name) LIKE ? ESCAPE '\'  ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME




-- 
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira