[teiid-issues] [JBoss JIRA] (TEIID-2754) DatabaseMetaData reports views as tables

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-2754?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-2754.
-----------------------------------

    Resolution: Partially Completed


Added a connection property:

reportAsViews

that can be set to true if view model tables should show up as views.  This will default to false for backwards compatibility and since this has yet to be requested as functionality I'll leave it as effectively undocumented and unreported by the driver.  We can then further expose the option as needed, but at least it will be there if desired by a user.
                
> DatabaseMetaData reports views as tables
> ----------------------------------------
>
>                 Key: TEIID-2754
>                 URL: https://issues.jboss.org/browse/TEIID-2754
>             Project: Teiid
>          Issue Type: Bug
>          Components: JDBC Driver, Query Engine
>    Affects Versions: 8.4
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 8.6
>
>
> The client already has a check for isVirtual & system table type to report a "system view".
> We have a "View" type in our metadata, but we generally do not use it in our metadata code. 
> So we either could set the view type on the server (although this seems like a broad change) or add another DatabaseMetaData check for isVirtual & table.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira