[
https://issues.jboss.org/browse/TEIID-5232?page=com.atlassian.jira.plugin...
]
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)