[teiid-issues] [JBoss JIRA] (TEIID-2577) Translator API to provide session backed connection

Fri Jul 12 14:36:20 EDT 2013

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

Mark Addleman commented on TEIID-2577:
--------------------------------------

Ramesh - The motivation isn't so much that we didn't want caching in the translator layer.  The issue is that the client doesn't know the *logical* schema of the stored procedure.  The *logical* schema is determined by the translator & data source. Therefore, we need a level of indirection and a way to implement that indirection.  Using traditional SQL constructs, we were trying to implement the indirection by a VARCHAR column containing a SELECT statement.  The SELECT statement could have been a constant UNION of all the rows returned by the data source but, obviously, that would be unwieldy.  Instead, we thought to have the translator populate a temp table and return a SELECT statement against that temp table.

Ultimately, I think this is entirely the wrong approach.  Instead, our stored procedure should return an XML document of the result set from the data source.  Then, the client can populate a temp table with the results.

> Translator API to provide session backed connection
> ---------------------------------------------------
>
>                 Key: TEIID-2577
>                 URL: https://issues.jboss.org/browse/TEIID-2577
>             Project: Teiid
>          Issue Type: Feature Request
>            Reporter: Mark Addleman
>            Assignee: Steven Hawkins
>
> Provide an API (probably from an ExecutionContext) to obtain a JDBC connection to the same Teiid instance under the client's session.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira