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

[Van Halbert (JIRA)]

Van Halbert created TEIID-2798:
----------------------------------

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