[teiid-issues] [JBoss JIRA] (TEIID-4205) send results proactively under a cursor as it looks like the ODBC client requires a transaction.

[Ramesh Reddy (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-4205?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13238267#comment-13238267 ] 

Ramesh Reddy commented on TEIID-4205:
-------------------------------------

[~shawkins] As I remember "UseDeclareFetch=1" will do automatic cursor based walking of the results, but did not see any transaction wrapping before. It may be correct that Teiid ignored the transaction calls in earlier versions. Is there a reason why there is transaction wrapping? 

When UseDelcareFetch=0 or not available, the odbc driver (used to) download all the rows before returning the first row back to the user.

> send results proactively under a cursor as it looks like the ODBC client requires a transaction.
> ------------------------------------------------------------------------------------------------
>
>                 Key: TEIID-4205
>                 URL: https://issues.jboss.org/browse/TEIID-4205
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: ODBC, Server
>    Affects Versions: 8.7.5.6_2
>            Reporter: Debbie Steigner
>            Assignee: Steven Hawkins
>
> Currently when querying large resultsets with ODBC the results are not sent as soon as the batch is logically available (like we do for JDBC)



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)