[teiid-issues] [JBoss JIRA] Work started: (TEIID-1252) LOB handling strategy issues

LOB handling strategy issues ---------------------------- Key: TEIID-1252 URL: https://jira.jboss.org/browse/TEIID-1252 Project: Teiid Issue Type: Quality Risk Components: Query Engine Affects Versions: 7.1 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.1.1 LOBs returned from sources cause executions to stay alive until the user query has been completed - this is true even if the LOB values are not returned to the user. Whenever an execution is kept alive, it's associated connection is held until the execution is closed - thus source connections may be held out of their pool indefinitely. Currently each source execution will attempt to obtain a new connection from the pool, which with LOB handling will cause potentially many connections even to the same source to be held out of the their pool indefinitely.