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

[Steven Hawkins (JIRA)]

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

Steven Hawkins resolved TEIID-1252.
-----------------------------------

    Resolution: Done


Added a method to the executionfactory to indicate if lobs are usable after close.  This addresses potential issues with the file and ws sources.  Connection utilization issues may still arise with JDBC and custom translators.

> 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.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira