[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:all-tabpanel ]

Steven Hawkins closed TEIID-2798.
---------------------------------


    
> 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