]
Van Halbert commented on TEIIDDES-2972:
---------------------------------------
What I did notice, when using the Stock example, was the Name (or nameInSource) didn't
match that of the method name created on pojo. In this case, it changed
"product_id" to "productName" and changed "company_name" to
"companyName".
So what ever the name of the pojo method is changed to, so should the NameInSource be set
to also. They have to match.
Incorrect NameInSource assignment
---------------------------------
Key: TEIIDDES-2972
URL:
https://issues.jboss.org/browse/TEIIDDES-2972
Project: Teiid Designer
Issue Type: Bug
Components: Modeling
Affects Versions: 10.0.2
Reporter: Van Halbert
Assignee: Barry LaFond
Priority: Blocker
When performing the wizard to materialization into a JDG data source, the nameInSource
assigned to the JDG source tables is incorrect. Example:
CREATE FOREIGN TABLE Stock (
product_id integer OPTIONS(NAMEINSOURCE '"product_id"', NATIVE_TYPE
'integer', FIXED_LENGTH 'TRUE'),
symbol string(4000) OPTIONS(NAMEINSOURCE '"symbol"', NATIVE_TYPE
'string'),
price string(50) OPTIONS(NAMEINSOURCE '"price"', NATIVE_TYPE
'string', FIXED_LENGTH 'TRUE'),
company_name string(256) OPTIONS(NAMEINSOURCE '"company_name"',
NATIVE_TYPE 'string'),
CONSTRAINT PK_prodid PRIMARY KEY(product_id)
) OPTIONS(NAMEINSOURCE '"Stocks"."Stock"', UPDATABLE
'TRUE')
The NAMEINSOURCE not be set or if it is, should be the same name as the table. In this
case, "Stock".