[teiid-issues] [JBoss JIRA] (TEIID-4744) Prior execution is not being closed in transactional secenario

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-4744?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-4744.
-----------------------------------
    Fix Version/s: 9.2
       Resolution: Done


Calling close in the serial case more quickly.

> Prior execution is not being closed in transactional secenario
> --------------------------------------------------------------
>
>                 Key: TEIID-4744
>                 URL: https://issues.jboss.org/browse/TEIID-4744
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>            Reporter: Ramesh Reddy
>            Assignee: Steven Hawkins
>             Fix For: 9.2
>
>
> When working in transactional scenario, where all the queries in plan are executed serially in a given thread, however, JDBC drivers like Netezza do not allow to keep more than single statement open on a given connection.
> To work with this issue, Teiid provides a translator override called "ThreadBound" where it forces the previous statement to finish executing (it caches the results if needs to be) before it can execute the next source command on the same connection.  It looks like Teiid is not closing the prior statement before it moves on to execute the next statement.



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)