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

[Ramesh Reddy (JIRA)]

Ramesh Reddy created TEIID-4744:
-----------------------------------

             Summary: 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


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)