[teiid-issues] [JBoss JIRA] (TEIID-2875) Metadata failed to load. No column found

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-2875?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13038898#comment-13038898 ] 

Steven Hawkins commented on TEIID-2875:
---------------------------------------

> but I obtain the same error.

The name that exclude tables is checking against is based upon the settings of the translator and the particulars of the db.  By default the translator will use all source name parts - catalog and schema and no quoting - catalogName.schemaName.tableName.  However Oracle does not report a catalog, so the name used for comparison would be just schemaName.tableName.  So as long as the exclusion expression is written taken into account the name that's being compared, it should work.

> and run the query "select * from m1.t1, m2.t2 where m1.t1.field1=m2.t2.field2" , is this join done within Oracle DB's engine?

The engine will assume that models/schemas against the same translator/jndi source are effectively the same.  You can double check the query plan to ensure that the pushdown happens as expected.

> Because, as far as I understand, the property importer.tableNamePattern only accepts a single table name.

It's a SQL like pattern.  It can use the % and _ wildcards, but that can be limiting.  excludeTables can also be written as a negation so that it includes only specific tables - https://docs.jboss.org/author/display/TEIID/JDBC+Translator



> Metadata failed to load. No column found
> ----------------------------------------
>
>                 Key: TEIID-2875
>                 URL: https://issues.jboss.org/browse/TEIID-2875
>             Project: Teiid
>          Issue Type: Bug
>    Affects Versions: 8.6
>         Environment: Windows server 2003, Windows 7.
>            Reporter: SHI HONG CHIN
>            Assignee: Steven Hawkins
>         Attachments: JakkerData-vdb.xml
>
>
> Affected database: Oracle
> The following error displayed when Teiid loading a dynamic VDB:
> 10:21:41,458 WARN  [org.teiid.RUNTIME] (teiid-async-threads - 2)  TEIID50036 VDB JakkerData.1 model "IWMS" metadata failed to load. Reason:TEIID60011 No column found with name "RATE"."CHARGE_NAME"
> 10:23:29,994 WARN  [org.teiid.RUNTIME] (teiid-async-threads - 4)  TEIID50036 VDB JakkerData.1 model "IWMS" metadata failed to load. Reason:TEIID60011 No column found with name "RATE"."CHARGE_NAME"
> I am not the one who design the database. But, I cannot find any table with above mentioned column name in Oracle database. So, I am not sure whether the above mentioned column name is a hidden column or not.
> This bug does not exist in version 8.5.



--
This message was sent by Atlassian JIRA
(v6.3.11#6341)