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

[Ramesh Reddy (JIRA)]

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

Ramesh Reddy commented on TEIID-2929:
-------------------------------------

Steve, I was thinking this available for both ODBC and JDBC or any protocol with following being true
> have the vdb properties simply be default values for the session/execution properties. I think this makes sense for well known properties at least.

Using this VDB developer can set/force properties on all connections to be made to that VDB, I do not  understand the concerns you mention above. I was thinking, at the connection time session service set all the vdb properties on server.

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