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

[Camilo Ortiz (JIRA)]

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

Camilo Ortiz commented on TEIID-2875:
-------------------------------------

Steven, thank you for your input. You are right, I was mistakenly putting the import properties in vdb instead of model as it should be. Now I have can have an active VDB with a single table by using 

<property name="importer.tableNamePattern" value="my-table"/>

To add more tables, I tried to use 

<property name="importer.excludeTables " value="my-regex"/>

but I obtain the same error. Then, I decided to create another model within the same vdb to add a different table from the same oracle DB (i.e., same datasource). This worked, and now I am able to query both of the tables using a JDBC client. 

If a query uses tables from different models that share a datasource from relational DB, does it executes entirely in within the relational DB? For example, if I have the following vdb.xml: 

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<vdb name ="myvdb" version="1">
    <property name="UseConnectorMetaData" value="true" />   
    <model name="m1">
    <property name="importer.tableNamePattern" value="t1"/>
        <source name="my-connector" translator-name="oracle" connection-jndi-name="java:/datasources/oracleDb" />
    </model>
    <model name="m2">
    <property name="importer.tableNamePattern" value="t2"/>
        <source name="my-connector" translator-name="oracle" connection-jndi-name="java:/datasources/oracleDb" />
    </model>
</vdb>

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? 

Also, Is there a better (smarter) way to add multiple tables for the case that one has to specify each of them? Maybe a way to have a regex to import? Because, as far as I understand, the property  importer.tableNamePattern only accepts a single table name.

Thanks a lot for your help.

> 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)