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

[Debbie Steigner (JIRA)]

Debbie Steigner created TEIID-5232:
--------------------------------------

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