[JBoss JIRA] Created: (TEIID-1377) Teiid Designer (DTP) Execute All sends all queries at once to Server - Server should handle these bulk queries
8:56 a.m.
Teiid Designer (DTP) Execute All sends all queries at once to Server - Server should
handle these bulk queries
--------------------------------------------------------------------------------------------------------------
Key: TEIID-1377
URL: https://jira.jboss.org/browse/TEIID-1377
Project: Teiid
Issue Type: Feature Request
Components: Query Engine
Affects Versions: 7.1.1
Reporter: Paul Nittel
Assignee: Steven Hawkins
When a series of SELECT statements are sent to the server via Execute All, the server
should execute the SQL statements in appropriate fashion (as when the queries are directed
to other RDBMSes, such as Oracle).
At present, no exceptions are thrown, but the queries fail to execute.
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
8:59 a.m.
New subject: [JBoss JIRA] Commented: (TEIID-1377) Teiid Designer (DTP) Execute All sends all queries at once to Server - Server should handle these bulk queries
[
https://jira.jboss.org/browse/TEIID-1377?page=com.atlassian.jira.plugin.s...
]
John Doyle commented on TEIID-1377:
-----------------------------------
I could look into turning this option off in DTP for Teiid.
Teiid Designer (DTP) Execute All sends all queries at once to Server
- Server should handle these bulk queries
--------------------------------------------------------------------------------------------------------------
Key: TEIID-1377
URL: https://jira.jboss.org/browse/TEIID-1377
Project: Teiid
Issue Type: Feature Request
Components: Query Engine
Affects Versions: 7.1.1
Reporter: Paul Nittel
Assignee: Steven Hawkins
When a series of SELECT statements are sent to the server via Execute All, the server
should execute the SQL statements in appropriate fashion (as when the queries are directed
to other RDBMSes, such as Oracle).
At present, no exceptions are thrown, but the queries fail to execute.
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:37 a.m.
New subject: [JBoss JIRA] Commented: (TEIID-1377) Teiid Designer (DTP) Execute All sends all queries at once to Server - Server should handle these bulk queries
[
https://jira.jboss.org/browse/TEIID-1377?page=com.atlassian.jira.plugin.s...
]
Paul Nittel commented on TEIID-1377:
------------------------------------
That's one way of dealing with it. :-)
I don't know how often people use the multiple-command execution. It worked with our
old SQL Explorer.
Teiid Designer (DTP) Execute All sends all queries at once to Server
- Server should handle these bulk queries
--------------------------------------------------------------------------------------------------------------
Key: TEIID-1377
URL: https://jira.jboss.org/browse/TEIID-1377
Project: Teiid
Issue Type: Feature Request
Components: Query Engine
Affects Versions: 7.1.1
Reporter: Paul Nittel
Assignee: Steven Hawkins
When a series of SELECT statements are sent to the server via Execute All, the server
should execute the SQL statements in appropriate fashion (as when the queries are directed
to other RDBMSes, such as Oracle).
At present, no exceptions are thrown, but the queries fail to execute.
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:48 a.m.
New subject: [JBoss JIRA] Commented: (TEIID-1377) Teiid Designer (DTP) Execute All sends all queries at once to Server - Server should handle these bulk queries
[
https://jira.jboss.org/browse/TEIID-1377?page=com.atlassian.jira.plugin.s...
]
John Doyle commented on TEIID-1377:
-----------------------------------
Didn't realize that it worked with SQL Explorer. I'm just wondering if this
really a Teiid issue or a Tooling issue. What happens if multiple statements are sent
from the shell?
Teiid Designer (DTP) Execute All sends all queries at once to Server
- Server should handle these bulk queries
--------------------------------------------------------------------------------------------------------------
Key: TEIID-1377
URL: https://jira.jboss.org/browse/TEIID-1377
Project: Teiid
Issue Type: Feature Request
Components: Query Engine
Affects Versions: 7.1.1
Reporter: Paul Nittel
Assignee: Steven Hawkins
When a series of SELECT statements are sent to the server via Execute All, the server
should execute the SQL statements in appropriate fashion (as when the queries are directed
to other RDBMSes, such as Oracle).
At present, no exceptions are thrown, but the queries fail to execute.
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
10:14 a.m.
New subject: [JBoss JIRA] Commented: (TEIID-1377) Teiid Designer (DTP) Execute All sends all queries at once to Server - Server should handle these bulk queries
[
https://jira.jboss.org/browse/TEIID-1377?page=com.atlassian.jira.plugin.s...
]
Ramesh Reddy commented on TEIID-1377:
-------------------------------------
Do not know of such feature now or before. May be SQLExplorer executed one after another.
JDBC is blocking API. Teiid only supports update queries in the batch mode.
Teiid Designer (DTP) Execute All sends all queries at once to Server
- Server should handle these bulk queries
--------------------------------------------------------------------------------------------------------------
Key: TEIID-1377
URL: https://jira.jboss.org/browse/TEIID-1377
Project: Teiid
Issue Type: Feature Request
Components: Query Engine
Affects Versions: 7.1.1
Reporter: Paul Nittel
Assignee: Steven Hawkins
When a series of SELECT statements are sent to the server via Execute All, the server
should execute the SQL statements in appropriate fashion (as when the queries are directed
to other RDBMSes, such as Oracle).
At present, no exceptions are thrown, but the queries fail to execute.
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
10:20 a.m.
New subject: [JBoss JIRA] Commented: (TEIID-1377) Teiid Designer (DTP) Execute All sends all queries at once to Server - Server should handle these bulk queries
[
https://jira.jboss.org/browse/TEIID-1377?page=com.atlassian.jira.plugin.s...
]
Paul Nittel commented on TEIID-1377:
------------------------------------
I have no idea how SQL Explorer did it. SQuirreL sends the queries one at a time--I
watched. Steve H. thought it might be a nice enhancement (to handle the bulk shipment
apparently done by SQL Scrapbook).
It could be a bug in DTP?
Teiid Designer (DTP) Execute All sends all queries at once to Server
- Server should handle these bulk queries
--------------------------------------------------------------------------------------------------------------
Key: TEIID-1377
URL: https://jira.jboss.org/browse/TEIID-1377
Project: Teiid
Issue Type: Feature Request
Components: Query Engine
Affects Versions: 7.1.1
Reporter: Paul Nittel
Assignee: Steven Hawkins
When a series of SELECT statements are sent to the server via Execute All, the server
should execute the SQL statements in appropriate fashion (as when the queries are directed
to other RDBMSes, such as Oracle).
At present, no exceptions are thrown, but the queries fail to execute.
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
2:56 p.m.
New subject: [JBoss JIRA] Commented: (TEIID-1377) Teiid Designer (DTP) Execute All sends all queries at once to Server - Server should handle these bulk queries
[
https://issues.jboss.org/browse/TEIID-1377?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-1377:
---------------------------------------
Was this addressed on the DTP side?
Teiid Designer (DTP) Execute All sends all queries at once to Server
- Server should handle these bulk queries
--------------------------------------------------------------------------------------------------------------
Key: TEIID-1377
URL: https://issues.jboss.org/browse/TEIID-1377
Project: Teiid
Issue Type: Feature Request
Components: Query Engine
Affects Versions: 7.1.1
Reporter: Paul Nittel
Assignee: Steven Hawkins
When a series of SELECT statements are sent to the server via Execute All, the server
should execute the SQL statements in appropriate fashion (as when the queries are directed
to other RDBMSes, such as Oracle).
At present, no exceptions are thrown, but the queries fail to execute.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
3:08 p.m.
New subject: [JBoss JIRA] Commented: (TEIID-1377) Teiid Designer (DTP) Execute All sends all queries at once to Server - Server should handle these bulk queries
[
https://issues.jboss.org/browse/TEIID-1377?page=com.atlassian.jira.plugin...
]
John Doyle commented on TEIID-1377:
-----------------------------------
No, I didn't make any changes there.
Teiid Designer (DTP) Execute All sends all queries at once to Server
- Server should handle these bulk queries
--------------------------------------------------------------------------------------------------------------
Key: TEIID-1377
URL: https://issues.jboss.org/browse/TEIID-1377
Project: Teiid
Issue Type: Feature Request
Components: Query Engine
Affects Versions: 7.1.1
Reporter: Paul Nittel
Assignee: Steven Hawkins
When a series of SELECT statements are sent to the server via Execute All, the server
should execute the SQL statements in appropriate fashion (as when the queries are directed
to other RDBMSes, such as Oracle).
At present, no exceptions are thrown, but the queries fail to execute.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
1:29 p.m.
New subject: [JBoss JIRA] (TEIID-1377) Teiid Designer (DTP) Execute All sends all queries at once to Server - Server should handle these bulk queries
[
https://issues.jboss.org/browse/TEIID-1377?page=com.atlassian.jira.plugin...
]
Steven Hawkins updated TEIID-1377:
----------------------------------
Fix Version/s: 8.0
We have handling for this scenario in ODBC, so we'll look at adding it to JDBC as
well.
Teiid Designer (DTP) Execute All sends all queries at once to Server
- Server should handle these bulk queries
--------------------------------------------------------------------------------------------------------------
Key: TEIID-1377
URL: https://issues.jboss.org/browse/TEIID-1377
Project: Teiid
Issue Type: Feature Request
Components: Query Engine
Affects Versions: 7.1.1
Reporter: Paul Nittel
Assignee: Steven Hawkins
Fix For: 8.0
When a series of SELECT statements are sent to the server via Execute All, the server
should execute the SQL statements in appropriate fashion (as when the queries are directed
to other RDBMSes, such as Oracle).
At present, no exceptions are thrown, but the queries fail to execute.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
2:37 p.m.
New subject: [JBoss JIRA] (TEIID-1377) Teiid Designer (DTP) Execute All sends all queries at once to Server - Server should handle these bulk queries
[
https://issues.jboss.org/browse/TEIID-1377?page=com.atlassian.jira.plugin...
]
Steven Hawkins updated TEIID-1377:
----------------------------------
Fix Version/s: 8.1
(was: 8.0)
Affects: Release Notes
Given that there is an easy fix in DTP, moving out of 8.0 bucket. The general approach to
the fix would be to make the script parsing logic from the odbc client generic and use it
from the JDBC client to issue individual queries. Better support for getMoreResults
methods would also need to be added.
Teiid Designer (DTP) Execute All sends all queries at once to Server
- Server should handle these bulk queries
--------------------------------------------------------------------------------------------------------------
Key: TEIID-1377
URL: https://issues.jboss.org/browse/TEIID-1377
Project: Teiid
Issue Type: Feature Request
Components: Query Engine
Affects Versions: 7.1.1
Reporter: Paul Nittel
Assignee: Steven Hawkins
Fix For: 8.1
When a series of SELECT statements are sent to the server via Execute All, the server
should execute the SQL statements in appropriate fashion (as when the queries are directed
to other RDBMSes, such as Oracle).
At present, no exceptions are thrown, but the queries fail to execute.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
10:09 a.m.
New subject: [JBoss JIRA] (TEIID-1377) Teiid Designer (DTP) Execute All sends all queries at once to Server - Server should handle these bulk queries
[
https://issues.jboss.org/browse/TEIID-1377?page=com.atlassian.jira.plugin...
]
Steven Hawkins updated TEIID-1377:
----------------------------------
Fix Version/s: 8.2
(was: 8.1)
Pushing to 8.2
Teiid Designer (DTP) Execute All sends all queries at once to Server
- Server should handle these bulk queries
--------------------------------------------------------------------------------------------------------------
Key: TEIID-1377
URL: https://issues.jboss.org/browse/TEIID-1377
Project: Teiid
Issue Type: Feature Request
Components: Query Engine
Affects Versions: 7.1.1
Reporter: Paul Nittel
Assignee: Steven Hawkins
Fix For: 8.2
When a series of SELECT statements are sent to the server via Execute All, the server
should execute the SQL statements in appropriate fashion (as when the queries are directed
to other RDBMSes, such as Oracle).
At present, no exceptions are thrown, but the queries fail to execute.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
7:57 a.m.
New subject: [JBoss JIRA] (TEIID-1377) Teiid Designer (DTP) Execute All sends all queries at once to Server - Server should handle these bulk queries
[
https://issues.jboss.org/browse/TEIID-1377?page=com.atlassian.jira.plugin...
]
Steven Hawkins updated TEIID-1377:
----------------------------------
Fix Version/s: (was: 8.2)
Priority: Minor (was: Major)
Complexity: Medium
This was fixed on the Designer side. The default DTP logic had changed and needed a tweak
to recognize a ; statement delimiter. So the priority of getting multi-statement handling
into Teiid is fairly low.
Teiid Designer (DTP) Execute All sends all queries at once to Server
- Server should handle these bulk queries
--------------------------------------------------------------------------------------------------------------
Key: TEIID-1377
URL: https://issues.jboss.org/browse/TEIID-1377
Project: Teiid
Issue Type: Feature Request
Components: Query Engine
Affects Versions: 7.1.1
Reporter: Paul Nittel
Assignee: Steven Hawkins
Priority: Minor
When a series of SELECT statements are sent to the server via Execute All, the server
should execute the SQL statements in appropriate fashion (as when the queries are directed
to other RDBMSes, such as Oracle).
At present, no exceptions are thrown, but the queries fail to execute.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
4236
days inactive
4927
days old
11 comments
5 participants
participants (5)
-
John Doyle (JIRA) -
Paul Nittel (JIRA)
-
Ramesh Reddy (JIRA)
-
Steven Hawkins (JIRA)
-
Steven Hawkins (Updated) (JIRA)