[teiid-issues] [JBoss JIRA] (TEIID-5232) Add ability to call system functions on VDB Datasource

[Steven Hawkins (JIRA)]

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

Steven Hawkins commented on TEIID-5232:
---------------------------------------

So the setup is Teiid using VDBs as sources, not vdb imports.  Then she wants to call the system function(s) on the source vdbs.  However the notion of session continuity is quite problematic here.  The user session for the top level vdb would be in no way correlated to the sessions for the source vdbs, which are just pooled connections.  If it's just the need to call teiid_session_set, the recommendation would be to add it as a UDF on the source vdbs.

> Add ability to call system functions on VDB Datasource
> ------------------------------------------------------
>
>                 Key: TEIID-5232
>                 URL: https://issues.jboss.org/browse/TEIID-5232
>             Project: Teiid
>          Issue Type: Feature Request
>            Reporter: Debbie Steigner
>            Assignee: Steven Hawkins
>
> Add ability to call the system function teiid_session_set on a EAP VDB datasource 
> When i send  : 
> select teiid_session_set('project','myProject');
> My session variable is changed only on my vdb.  I would want to send this command to my VDB EAP datasource.  I need to let my vdb's client  the opportunity to call teiid_session_set in one of my datasource dynamically.  For now, the only way i have found is putting this on my datasource configuration : 
>  <new-connection-sql>select teiid_session_set('country','BELGIUM')</new-connection-sql>
> The problem is that this sql request is only called once, at the vdb deployment.  I would like to be able to call this request at runtime.



--
This message was sent by Atlassian JIRA
(v7.5.0#75005)