Bug 861446
Summary: | Support "pass though" SQL commands to sources | |||
---|---|---|---|---|
Product: | [JBoss] JBoss Enterprise SOA Platform 5 | Reporter: | Rick Wagner <rwagner> | |
Component: | EDS | Assignee: | jolee | |
Status: | CLOSED CURRENTRELEASE | QA Contact: | Filip Nguyen <fnguyen> | |
Severity: | unspecified | Docs Contact: | ||
Priority: | unspecified | |||
Version: | 5.3.0 GA | CC: | belong, dlesage, felias, fnguyen, jpechane, rareddy, vhalbert | |
Target Milestone: | ER1 | |||
Target Release: | 5.3.1 | |||
Hardware: | Unspecified | |||
OS: | Unspecified | |||
Whiteboard: | ||||
Fixed In Version: | Doc Type: | Bug Fix | ||
Doc Text: |
Previously, there was no easy mechanism to allow a source specific query to be submitted to the runtime engine. Users needed to resort to user defined functions which can be unnecessarily complex.
Source specific queries (or "native queries") can now be set in Teiid Designer. The runtime engine will then use this native query as an inline view instead of the respective table name within a FROM clause.
|
Story Points: | --- | |
Clone Of: | ||||
: | 880831 (view as bug list) | Environment: | ||
Last Closed: | 2013-07-09 15:39:43 UTC | Type: | Bug | |
Regression: | --- | Mount Type: | --- | |
Documentation: | --- | CRM: | ||
Verified Versions: | Category: | --- | ||
oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | ||
Cloudforms Team: | --- | Target Upstream Version: | ||
Embargoed: | ||||
Bug Depends On: | ||||
Bug Blocks: | 880831, 857488 |
Description
Rick Wagner
2012-09-28 15:43:49 UTC
Steven Hawkins <shawkins> updated the status of jira TEIID-669 to Resolved Steven Hawkins <shawkins> made a comment on jira TEIID-669 with TEIID-2176, TEIID-2177, and the existing native-query support I'm marking this issue as resolved as to limit what it covers. New issues can be created to cover incremental improvements or some form of a pass through query mode directly from the client. Ramesh Reddy <rareddy> made a comment on jira TEIID-669 JLee, I thought the only changes we are going to do for EDS 5.3 was in the JBDS which are going in their rollup. The extension properties for native query for relational sources is already in the 5.3. These TEIID-2176, TEIID-2177 JIRAs expand the native query support to other sources and also provide native procedure support which we are not approved for 5.3 re-adding as a blocker as engineering has found an issue. backport to follow (soon). Committed r4525 to https://svn.jboss.org/repos/teiid/branches/7.7.x Verified in 5.3.1 ER1 with JBDS SOA/BRMS tooling 5.0.1 (released on CSP 7th November). It is possible to set the native query in Teiid Designer in source model. The native query will be then embedded as inline view in FROM clause. Steven Hawkins <shawkins> updated the status of jira TEIID-669 to Closed |