March 2012 - teiid-issues - Jboss List Archives

[JBoss JIRA] Created: (TEIID-669) Support "pass though" SQL commands to sources

by Ramesh Reddy (JIRA)

Support "pass though" SQL commands to sources --------------------------------------------- Key: TEIID-669 URL: https://jira.jboss.org/jira/browse/TEIID-669 Project: Teiid Issue Type: Feature Request Components: Query Engine Reporter: Ramesh Reddy Assignee: Steven Hawkins Fix For: 6.2.0 Currently there is no mechanism in Teiid, when a query is submitted to a runtime engine that is passed through the query engine unadulterated and unmodified and submitted directly to a source connector. All queries are parsed, optimized, re-written. Some times this limits the functionality in Teiid, when a user would like to execute a query that is very "source" specific. For example Oracle supports lots of Oracle specific functions that are not supported by the SQL spec, to support execution of these in Teiid user need to resort to UDF, which is cumbersome and involves modelling. Another benefit of this is also to pass DDL to sources, currently since Teiid does not support DDL, this is not possible at all. There is no-expectation that these queries are part of any data integration, these are one off queries that enhance user experience with Teiid if they use this feature. Command Payload mechanism is similar system that is used for authentication and authorization needs at the connector level, this feature can use similar techniques or use some custom extension to the language to define a query etc. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years

6
18
0 / 0

[JBoss JIRA] Created: (TEIID-1725) ResultSet metadata error with JDBC handled statements

by Steven Hawkins (JIRA)

ResultSet metadata error with JDBC handled statements ----------------------------------------------------- Key: TEIID-1725 URL: https://issues.jboss.org/browse/TEIID-1725 Project: Teiid Issue Type: Bug Components: JDBC Driver Affects Versions: 7.1 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Minor Using a preparedstatement of SET / SHOW / transaction statements will fail if resultset metadata is requested prior to execution. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 1 month

1
2
0 / 0

[JBoss JIRA] Created: (TEIID-1241) Create a WSDL based WS Resource Adapter

by Steven Hawkins (JIRA)

Create a WSDL based WS Resource Adapter --------------------------------------- Key: TEIID-1241 URL: https://jira.jboss.org/browse/TEIID-1241 Project: Teiid Issue Type: Feature Request Components: Misc. Connectors Affects Versions: 7.2 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.2 The current WS resource adapter was designed for low-level usage, which doesn't even consult a WSDL. It would be good though to update the existing adapter (or introduce a new) to utilize a WSDL. The WSDL would be used to expose the operations through connector metadata, so that the translator could create the corresponding procedures model.service.port.binding.operation(arg...). Import options could be used to limit the import to only particular services/ports. The WSDL based approach would also allow for the CXF configuration to apply to more than a single port and to more easily allow the policy definition for WS security. Additional semantic support for RPC could be considered, but would need to use JAX-RPC -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 1 month

2
13
0 / 0

[JBoss JIRA] Created: (TEIID-1714) Allow WS calls to set a timeout value

by Steven Hawkins (JIRA)

Allow WS calls to set a timeout value ------------------------------------- Key: TEIID-1714 URL: https://issues.jboss.org/browse/TEIID-1714 Project: Teiid Issue Type: Enhancement Components: XML Connector Affects Versions: 8.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.0 With the upgrade beyond CXF 2.3, there is a straightforward way to set timeouts: https://issues.apache.org/jira/browse/CXF-2991 The translator (via a new invoke method) and/or the connection factory should have the ability to specify a request timeout. It is quite cumbersome to use CXF configuration for this and is a common need. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 1 month

4
8
0 / 0

[JBoss JIRA] (TEIID-1923) AS7 based Admin Console needed for Teiid

by Ramesh Reddy (JIRA)

Ramesh Reddy created TEIID-1923: ----------------------------------- Summary: AS7 based Admin Console needed for Teiid Key: TEIID-1923 URL: https://issues.jboss.org/browse/TEIID-1923 Project: Teiid Issue Type: Task Components: AdminApi, Build/Kits Affects Versions: 8.0 Reporter: Ramesh Reddy Assignee: Ramesh Reddy Priority: Critical Currently there is NO AS7 based console administration for Teiid. It needs one. Currently only solution available is either use CLI or AdminShell or Admin API for managing a Teiid instance. -- 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

12 years, 1 month

2
4
0 / 0

[JBoss JIRA] Created: (TEIID-1064) Create connector for Google Spreadsheets.

by John Doyle (JIRA)

Create connector for Google Spreadsheets. ----------------------------------------- Key: TEIID-1064 URL: https://jira.jboss.org/jira/browse/TEIID-1064 Project: Teiid Issue Type: Feature Request Components: Misc. Connectors Affects Versions: 7.1 Reporter: John Doyle Assignee: John Doyle Connectivity to Google spreadsheets for Teiid was identified as a desirable feature. I've hacked together a little prototype code that can access Google Spreadsheets through the Table feed. http://code.google.com/apis/spreadsheets/data/3.0/developers_guide_java.h... I envision the connector as driven by a text file for it's metadata just like the Text connector is. I imagine it would be possible to create some tooling that could define a model from the same text file, but that is out of the scope of this Jira. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 1 month

6
13
0 / 0

[JBoss JIRA] Created: (TEIID-1386) Support exception handling in the procedures

by Ramesh Reddy (JIRA)

Support exception handling in the procedures -------------------------------------------- Key: TEIID-1386 URL: https://issues.jboss.org/browse/TEIID-1386 Project: Teiid Issue Type: Feature Request Components: Query Engine Affects Versions: 7.2 Reporter: Ramesh Reddy Assignee: Steven Hawkins Currently the in Teiid procedure language there is no exception handling logic. For example if a INSERT fails due to unique key constraint, there is no way to catch that and do some other operation. Currently the procedure will exit the procedure will error. -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 1 month

2
7
0 / 0

[JBoss JIRA] (TEIID-1956) WHERE clause throws org.teiid.jdbc.TeiidSQLException: Index: 2, Size: 1

by Pramod Kumar (JIRA)

Pramod Kumar created TEIID-1956: ----------------------------------- Summary: WHERE clause throws org.teiid.jdbc.TeiidSQLException: Index: 2, Size: 1 Key: TEIID-1956 URL: https://issues.jboss.org/browse/TEIID-1956 Project: Teiid Issue Type: Bug Affects Versions: 7.6 Environment: Operating system: Windows 7 Eclipse Version: Helios Service Release 1 Reporter: Pramod Kumar Assignee: Steven Hawkins I am trying to execute a query similar to the following query: select count(*) from SCHEMA1.STUDENTVIEW as STD_VIEW left join SCHEMA1.LIBRARY LIB on STD_VIEW.sid = LIB.sid where LIB.sid = STD_VIEW.sid and LIB.semister = '4'; The above query works fine in DB2. But throws org.teiid.jdbc.TeiidSQLException: Index: 2, Size: 1 when trying to execute in Teiid Designer version 7.6. -- 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

12 years, 1 month

5
29
0 / 0

[JBoss JIRA] (TEIID-1925) In RHQ Plugin the View VDB Requests action fails with NoSuchMethod org.teiid.rhq.plugin.objects.RequestMetadata.getRequestId()

by Ted Jones (JIRA)

Ted Jones created TEIID-1925: -------------------------------- Summary: In RHQ Plugin the View VDB Requests action fails with NoSuchMethod org.teiid.rhq.plugin.objects.RequestMetadata.getRequestId() Key: TEIID-1925 URL: https://issues.jboss.org/browse/TEIID-1925 Project: Teiid Issue Type: Bug Components: Jopr Plugin Affects Versions: 7.4.1 Reporter: Ted Jones Assignee: Ted Jones Fix For: 7.7, 7.4.1 Need to change the rhq-plugin.xml to call getExecutionId() instead of getRequestId() -- 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

12 years, 1 month

4
11
0 / 0

[JBoss JIRA] Created: (TEIID-1517) Use tree logic for dependent joins, subquery set, and partitioned joins

by Steven Hawkins (JIRA)

Use tree logic for dependent joins, subquery set, and partitioned joins ----------------------------------------------------------------------- Key: TEIID-1517 URL: https://issues.jboss.org/browse/TEIID-1517 Project: Teiid Issue Type: Feature Request Components: Query Engine Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.0 The tree logic would help each of the given areas of functionality. Currently subqueryin produces a linear search, partitioning is limited by the bucketing logic, and dependent joins will only create a tree of a limited size. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 1 month

2
5
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues March 2012