[teiid-issues] [JBoss JIRA] (TEIID-2798) Add creation of view when exposing metadata via Object translator

[Steven Hawkins (JIRA)]

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

Steven Hawkins commented on TEIID-2798:
---------------------------------------

The documentation does mention 

"All other columns will have their name in source (which defaults to the column name) interpreted as the path to the column value from the primary object."

But it certainly can be made more clear that the example is just an that and not required for usage.
                
> Add creation of view when exposing metadata via Object translator
> -----------------------------------------------------------------
>
>                 Key: TEIID-2798
>                 URL: https://issues.jboss.org/browse/TEIID-2798
>             Project: Teiid
>          Issue Type: Enhancement
>          Components: Misc. Connectors
>    Affects Versions: 8.4.1
>            Reporter: Van Halbert
>            Assignee: Van Halbert
>
> When the metadata is exposed for the java object via the Object translator, a view should also  be created using a template similar to:
> SELECT 
>      		    t.{pkKeyField}, o.{colname}, o.{colname} 
> 		FROM Order
>     		    {ObjectSourceTable} as T,
>       		    OBJECTTABLE('x' PASSING T.{ObjectTypeName}Object as x COLUMNS
>       			{colname}  {type}  'teiid_row.{colname}',  ….) as o
> 		where
> {pkKeyField} is the primary key column to the cache
> {ObjectSourceTable} is the source table imported above
> {ObjectTypeName} is the column added in {ObjectSourceTable} to reference the cache object
> {colname} is the name of the columns that have “get” methods, see the {ObjectSourceTable} for columns to use
> {type} is the data type for this column

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