[teiid-issues] [JBoss JIRA] (TEIID-2180) Limiting source tables in dynamic VDBs using importer.excludeTables

Sat Sep 1 07:34:32 EDT 2012

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

Steven Hawkins resolved TEIID-2180.
-----------------------------------

    Resolution: Done

Changed the logic to be able to do a table by table column lookup in most situations spanning schemas or using exclusions.

> Limiting source tables in dynamic VDBs using importer.excludeTables
> -------------------------------------------------------------------
>
>                 Key: TEIID-2180
>                 URL: https://issues.jboss.org/browse/TEIID-2180
>             Project: Teiid
>          Issue Type: Enhancement
>          Components: JDBC Connector
>    Affects Versions: 8.1
>            Reporter: Samier Nadji
>            Assignee: Steven Hawkins
>             Fix For: 8.2
>
>
> JDBCMetdataProcessor.getColumns() calls metadata.getColumns() for all the tables even the excluded ones. The while loop to process the columns is what takes a long time.
> Is it possible to change the code in JDBCMetdataProcessor.getColumns() to only get columns for the tables that are included in the tableMap? i.e. if an exclusion filter is specified, call metadata.getColumns() separately for each 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