[
https://issues.jboss.org/browse/TEIID-2875?page=com.atlassian.jira.plugin...
]
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)