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, 8.7.12.6_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.