[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:comment-tabpanel&focusedCommentId=12965340#comment-12965340 ] 

Steven Hawkins commented on TEIID-2929:
---------------------------------------

> I was thinking, at the connection time session service set all the vdb properties on server.

Execution properties are not maintained on the server side.  It's all client side, and then with each request method we'll send the set of relevant values.  So all of that would need to be re-worked for this logic to make sense for JDBC and/or we'd have to introduce initialization logic after logon that will send the default values to the client (similar to pg).

However with ODBC we're acting on the server side against our client, so it's quite simple there just to set execution properties (or even connection properties) directly.


> 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
>             Fix For: 8.8
>
>
> 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 was sent by Atlassian JIRA
(v6.2.3#6260)