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

[Van Halbert (JIRA)]

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

Van Halbert commented on TEIID-2798:
------------------------------------

I took that to mean that the path to column will be used when deriving value from the Object source defined (referenced) in by the OBJECTTABLE function.   So I really missed that.    And after testing, you are right, don't need to model the object column or need to use OBJECTTABLE.   But out of this, need to fix the metadata so that it doesn't include the Object source in the source table.    It could be useful if the object was being returned to the client, but I don't think it should be added by default.  What do you think?
                
> 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