[teiid-issues] [JBoss JIRA] (TEIID-2929) Provide ability define "execution properties" as VDB properties

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-2929?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins updated TEIID-2929:
----------------------------------

    Forum Reference: https://community.jboss.org/thread/239728


The forum post where this comes from involves setting partialResultsMode.

So the approach here would be either 

* have the vdb properties simply be default values for the session/execution properties.  I think this makes sense for well known properties at least.

* allow there to be a server side initialization string on the vdb, such that any set of statements can be run.
                
> Provide ability define "execution properties" as VDB properties
> ---------------------------------------------------------------
>
>                 Key: TEIID-2929
>                 URL: https://issues.jboss.org/browse/TEIID-2929
>             Project: Teiid
>          Issue Type: Enhancement
>          Components: Server
>            Reporter: Ramesh Reddy
>            Assignee: Steven Hawkins
>
> Currently if user needs to set any execution properties on their connection, with JDBC they can define on the URL or use "SET " statement to issue a query. In ODBC can also use "SET " method.
> However, when working with packaged applications and ODBC or in some situations it may be better to configure these properties VDB wide so that all the connections are using same execution properties.
> This JIRA proposes ability to add execution properties as vdb properties in vdb.xml file. 

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