[
https://issues.jboss.org/browse/TEIIDDES-1693?page=com.atlassian.jira.plu...
]
Dan Florian commented on TEIIDDES-1693:
---------------------------------------
The invalid name is coming from the ModeShape DDL sequencer. The ModeShape Teiid DDL
parser is interpreting the ':' in the identifier as if the identifier is of the
form "namespacePrefix:name." The actual, or full name, of the object in
ModeShape/JCR has the form "{namespaceUrl}name." A lookup is done to find the
"namespaceUrl" using the "namespacePrefix."
In this case, the ModeShape Teiid parser tries to look up the namespace URL for the
"Products.product" prefix and does not find one. The parser then *assumes* that
the part of the identifier before the ':' is the URL itself and then inserts curly
braces around it when forming the full name. So "Products.product:info" becomes
"{Products.product}info".
Since the Teiid DDL actually allows a similar "namespace:identifier" format via
their "option namespace" DDL statement, I'm not sure what the solution is
right now.
Table name "product:info: being imported as
"product}info" through new Teiid Connection importer
------------------------------------------------------------------------------------------------
Key: TEIIDDES-1693
URL:
https://issues.jboss.org/browse/TEIIDDES-1693
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 8.1
Reporter: Barry LaFond
Assignee: Dan Florian
Fix For: 8.2
MY SQL Source: jdbc:mysql://slntds03.mw.lab.eng.bos.redhat.com:3306/Products
This DB defines a table as "product:info"
JDBC importer correctly imports that table as "product_info"
Teiid Connection importer changes the name to "product}info" and the columns
names end up as "{PRODUCT}ID instead of "PRODUCT_ID"
--
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