[teiid-issues] [JBoss JIRA] (TEIID-5232) Add ability to call system functions on VDB Datasource
Steven Hawkins (JIRA)
issues at jboss.org
Thu Jan 25 16:42:00 EST 2018
[ https://issues.jboss.org/browse/TEIID-5232?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13524129#comment-13524129 ]
Steven Hawkins commented on TEIID-5232:
---------------------------------------
[~dsteigne] I don't quite follow what is being requested here. Is it saying that there is vdb, that uses datasources which are other vdbs and they want to be able to call a session function on those?
> 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)
More information about the teiid-issues
mailing list