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