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

[Ramesh Reddy (JIRA)]

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

Ramesh Reddy commented on TEIID-2577:
-------------------------------------

You are proposing two different features here

1) Extend the Session scoped temp tables to the virtual procedures.
2) Ability to have anonymous procedure blocks

both seem useful features, (1) being more immediately useful. 

I still do not see the validity of this JIRA's issue in comparison to the Derby/H2 procedures, as I do not look at translation layer as execution of procedure construct, but as any arbitrary statement. Re-cursing back into Teiid engine for processing, seems bad not only in terms of processing, but also should expose same transactional issues as that of client layer. If this is right, I feel that it will (ab)used more for wrong reasons.
                
> 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