September 2010 - 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

11 years, 5 months

6
18
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

11 years, 5 months

2
13
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

11 years, 5 months

6
13
0 / 0

[JBoss JIRA] Created: (TEIID-1280) Add parameters to procedure definition

by Steven Hawkins (JIRA)

Add parameters to procedure definition -------------------------------------- Key: TEIID-1280 URL: https://jira.jboss.org/browse/TEIID-1280 Project: Teiid Issue Type: Feature Request Components: Query Engine Affects Versions: 7.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Critical Fix For: 8.0 Our procedure syntax needs to add parameter definition to be independent of Designer. -- 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

11 years, 5 months

3
4
0 / 0

[JBoss JIRA] Created: (TEIID-657) Support Batched Updates in the Salesforce Connector

by John Doyle (JIRA)

Support Batched Updates in the Salesforce Connector --------------------------------------------------- Key: TEIID-657 URL: https://jira.jboss.org/jira/browse/TEIID-657 Project: Teiid Issue Type: Feature Request Components: Salesforce Connector Affects Versions: 6.0.0, 6.1.0 Reporter: John Doyle Assignee: John Doyle Salesforce supports batched updates via the WS API. Since Teiid supports batched updates as well, the SF connector should support them. -- 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

11 years, 5 months

4
9
0 / 0

[JBoss JIRA] Created: (TEIID-1131) Document/expand sequence support

by Steve Hawkins (JIRA)

Document/expand sequence support -------------------------------- Key: TEIID-1131 URL: https://jira.jboss.org/browse/TEIID-1131 Project: Teiid Issue Type: Feature Request Components: JDBC Connector, Query Engine Affects Versions: 7.0 Reporter: Steve Hawkins Assignee: Steve Hawkins Fix For: 7.1 Currently sequence workaround logic only exists for oracle and is undocumented. We should look at expanding sequence support - even for dynamic vdbs, see SQuriel's handling of system queries for retrieving sequence metadata. At least allowing the workaround logic to work for all sources that support sequences (Postgres, DB2, etc.) would be good. -- 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

11 years, 5 months

4
12
0 / 0

[JBoss JIRA] Created: (TEIID-1226) Reuse dynamic sql plans and allow for prepared statements in procedure logic

by Steve Hawkins (JIRA)

Reuse dynamic sql plans and allow for prepared statements in procedure logic ---------------------------------------------------------------------------- Key: TEIID-1226 URL: https://jira.jboss.org/browse/TEIID-1226 Project: Teiid Issue Type: Feature Request Components: Query Engine Affects Versions: 7.1 Reporter: Steve Hawkins Assignee: Steve Hawkins Priority: Minor Fix For: 8.0 Dynamic sql plans (for dynamic sql statements, lookup, and matview refreshes) should allow for plan reuse. Also procedure logic should have a mechanism to execute prepared statements for further plan reuse. -- 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

11 years, 5 months

3
4
0 / 0

[JBoss JIRA] Created: (TEIID-1248) Clob usability

by Steven Hawkins (JIRA)

Clob usability -------------- Key: TEIID-1248 URL: https://jira.jboss.org/browse/TEIID-1248 Project: Teiid Issue Type: Feature Request Components: Query Engine Affects Versions: 8.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Minor Fix For: 8.0 In many circumstances, clobs should be treated as charsequences to allow for use in string functions (concat returning clob, insert, left, etc.). There have also been customer requests to treat clobs as comparable, but that there are a lot of places including at design time where we validate against clobs being comparable that it may not be a good idea. -- 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

11 years, 6 months

2
3
0 / 0

[JBoss JIRA] Created: (TEIID-1022) Index metadata should not treat cardinality 0 as unknown

by Steven Hawkins (JIRA)

Index metadata should not treat cardinality 0 as unknown -------------------------------------------------------- Key: TEIID-1022 URL: https://jira.jboss.org/jira/browse/TEIID-1022 Project: Teiid Issue Type: Quality Risk Components: Query Engine Affects Versions: 6.0.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Minor Fix For: 7.1 The default cardinality is currently 0, which is treated as unknown, however it would be better if the default were something like -1 instead. This will require introducing a new index file version (so that older vdbs with a value of 0 can be understood as meaning unknown) and updating the teiid/designer metadata defaults for cardinality as -1. -- 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

11 years, 8 months

3
3
0 / 0

[JBoss JIRA] Created: (TEIID-942) Make ad hoc temp tables transactional

by Steven Hawkins (JIRA)

Make ad hoc temp tables transactional ------------------------------------- Key: TEIID-942 URL: https://jira.jboss.org/jira/browse/TEIID-942 Project: Teiid Issue Type: Feature Request Components: Query Engine Affects Versions: 7.1 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.1 Ad hoc temp tables are scoped to the session and should be transactional. -- 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

11 years, 8 months

2
6
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues September 2010