[JBoss JIRA] (TEIID-4205) send results proactively under a cursor as it looks like the ODBC client requires a transaction.
- First Post
- Replies
- Stats
-
Go to
- ----- 2024 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2023 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2022 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2021 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2020 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2019 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2018 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2017 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2016 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2015 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2014 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2013 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2012 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2011 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2010 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2009 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
[
https://issues.jboss.org/browse/TEIID-4205?page=com.atlassian.jira.plugin...
]
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)
3143
days inactive
3143
days old
0 comments
1 participants
tags (0)
participants (1)
-
Ramesh Reddy (JIRA)