[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...
]
Steven Hawkins commented on TEIID-4205:
---------------------------------------
Now my approach will be to disable the implicit use of transaction wrapping around an odbc
cursor.
This is much simpler as we'll look for "BEGIN;declare " and strip off the
BEGIN. I would like to make this default behavior given that we are also ignoring the
associated savepoint/release. We can also add a switch to allow the transaction to be
honored.
[~rareddy] or others have thoughts on this?
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)
3142
days inactive
3142
days old
0 comments
1 participants
tags (0)
participants (1)
-
Steven Hawkins (JIRA)