October 2012 - teiid-issues - Jboss List Archives

[JBoss JIRA] Created: (TEIID-1543) Add a query hint to limit the number of concurrent source queries

by Steven Hawkins (JIRA)

Add a query hint to limit the number of concurrent source queries ----------------------------------------------------------------- Key: TEIID-1543 URL: https://issues.jboss.org/browse/TEIID-1543 Project: Teiid Issue Type: Sub-task Components: Query Engine Affects Versions: 7.4 Reporter: Steven Hawkins Assignee: Steven Hawkins We would like a new query hint to limit the number of parallel executions of union members. This is useful in two situations: 1. When the queries are expensive, but the overall union contains a limit that is most likely to be fulfilled by the first member of the union 2. When the queries are backed by a common resource which may be overloaded by multiple queries The addition of a hint would make this manageable by the client; perhaps something like "/*+ parallel=2*/"? -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 5 months

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

13 years, 5 months

3
4
0 / 0

[JBoss JIRA] (TEIID-2282) Teiid JDBC driver to suport using certificate where the CN name is not same as the server name

by Jack Ma (JIRA)

Jack Ma created TEIID-2282: ------------------------------ Summary: Teiid JDBC driver to suport using certificate where the CN name is not same as the server name Key: TEIID-2282 URL: https://issues.jboss.org/browse/TEIID-2282 Project: Teiid Issue Type: Feature Request Reporter: Jack Ma Assignee: Steven Hawkins Priority: Optional At MSSQL jdbc driver, there is a driver property "hostNameInCertificate" allowing to use the certificate where the cn name is different from the server hostname. Could teiid jdbs driver provide similar functionality? -- 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

13 years, 5 months

2
1
0 / 0

[JBoss JIRA] (TEIID-2273) org.teiid.query.sql.lang.SubqueryFromClause does not quote keywords in the alias

by Mark Addleman (JIRA)

Mark Addleman created TEIID-2273: ------------------------------------ Summary: org.teiid.query.sql.lang.SubqueryFromClause does not quote keywords in the alias Key: TEIID-2273 URL: https://issues.jboss.org/browse/TEIID-2273 Project: Teiid Issue Type: Bug Reporter: Mark Addleman Assignee: Steven Hawkins new SubqueryFromClause("user", QueryParser.getQueryParser() .parseCommand("select 1")).toString() yields (SELECT 1) AS user it should be (SELECT 1) AS "user" Briefly looking at the code, I think the problem is in org.teiid.query.sql.visitor.SQLStringVisitor.escapeSinglePart(String).escape. Shouldn't it check SQLStringVisitor.isReservedWord(String)? -- 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

13 years, 5 months

2
3
0 / 0

[JBoss JIRA] (TEIID-2132) Teiid 8.0 API does not expose boundport in Mbean attribute for Teiid-JDBC

by Akshay Harale (JIRA)

Akshay Harale created TEIID-2132: ------------------------------------ Summary: Teiid 8.0 API does not expose boundport in Mbean attribute for Teiid-JDBC Key: TEIID-2132 URL: https://issues.jboss.org/browse/TEIID-2132 Project: Teiid Issue Type: Bug Components: Server Affects Versions: 8.0 Environment: jboss 7, teiid 8, windows 7 Reporter: Akshay Harale Assignee: Steven Hawkins Priority: Minor When offset is set for jboss from standalone.xml or standalone.conf.bat file, the bound port is not displyed in MBean server. For example, <socket-binding-group name="standard-sockets" default-interface="public" port-offset="${jboss.socket.binding.port-offset:25}"> In above line if I set the value as 25 then that should be added to the default socket port values and exposed as bound port value in MBean server. But in case of teiid the "teiid-jdbc" 's boundPort value is not exposed by the jboss. All other boundPorts values are correctly shown in Mbean, except teiid-jdbc -- 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

13 years, 5 months

3
3
0 / 0

[JBoss JIRA] (TEIID-2270) WS procedure metadata should be updated

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-2270: ------------------------------------- Summary: WS procedure metadata should be updated Key: TEIID-2270 URL: https://issues.jboss.org/browse/TEIID-2270 Project: Teiid Issue Type: Bug Components: Server Affects Versions: 8.2 Reporter: Paul Richardson Assignee: Steven Hawkins Fix For: 8.2 Using designer 8, I deploy the state service example models (found [here|https://github.com/phantomjinx/teiid-soap-example]) to an 8.2 beta1 teiid server. The models deploy successfully and the teiid connection in designer displays the catalog and stateService/stateServiceView schemas. However, running the following query {{exec stateServiceView.getAllStateInfo();}} results in a generic TeiidException in designer's status view. This exception comes from a NullPointerException that is displayed in the jboss server log. The log of the jboss server is attached, detailing the following events: # start of the server with the stateService data source and USStates vdb already deployed # connection and execution of the query from designer -- 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

13 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-1979) The RAR should be unbundled when packaged in the jboss kit

by Van Halbert (JIRA)

Van Halbert created TEIID-1979: ---------------------------------- Summary: The RAR should be unbundled when packaged in the jboss kit Key: TEIID-1979 URL: https://issues.jboss.org/browse/TEIID-1979 Project: Teiid Issue Type: Task Components: Build/Kits Reporter: Van Halbert Assignee: Steven Hawkins Fix For: 8.0 The RAR file should be unbundled, instead of zipped up, when it is packaged in the jboss kit. This change is being pushed up stream. -- 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

13 years, 5 months

4
11
0 / 0

[JBoss JIRA] (TEIID-992) Improve update of source costing statistics

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-992?page=com.atlassian.jira.plugin.... ] Ramesh Reddy updated TEIID-992: ------------------------------- Fix Version/s: (was: 8.2) Will work when TEIID-245 is worked > Improve update of source costing statistics > ------------------------------------------- > > Key: TEIID-992 > URL: https://issues.jboss.org/browse/TEIID-992 > Project: Teiid > Issue Type: Sub-task > Components: Misc. Connectors, Query Engine > Reporter: Marc Shirley > Assignee: Ramesh Reddy > > It is very important that we support the ability to update source statistics at runtime. This is important due to the changing nature of read/write sources and differences between a development data source and a production data source. > The following options should be possible: > 1) Update model/source statistics on VDB deployment. > 2) Update model/source statistics on connector startup. > 3) Update model/source statistics on at a scheduled time. > 4) Update model/source statistics upon a manual request. > case 5920 -- 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

13 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-992) Improve update of source costing statistics

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-992?page=com.atlassian.jira.plugin.... ] Ramesh Reddy updated TEIID-992: ------------------------------- Parent: TEIID-245 Issue Type: Sub-task (was: Feature Request) > Improve update of source costing statistics > ------------------------------------------- > > Key: TEIID-992 > URL: https://issues.jboss.org/browse/TEIID-992 > Project: Teiid > Issue Type: Sub-task > Components: Misc. Connectors, Query Engine > Reporter: Marc Shirley > Assignee: Ramesh Reddy > Fix For: 8.2 > > > It is very important that we support the ability to update source statistics at runtime. This is important due to the changing nature of read/write sources and differences between a development data source and a production data source. > The following options should be possible: > 1) Update model/source statistics on VDB deployment. > 2) Update model/source statistics on connector startup. > 3) Update model/source statistics on at a scheduled time. > 4) Update model/source statistics upon a manual request. > case 5920 -- 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

13 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2035) DeleteDataSource method on Admin API does not completely delete the Connection Factory

by Ramesh Reddy (JIRA)

Ramesh Reddy created TEIID-2035: ----------------------------------- Summary: DeleteDataSource method on Admin API does not completely delete the Connection Factory Key: TEIID-2035 URL: https://issues.jboss.org/browse/TEIID-2035 Project: Teiid Issue Type: Bug Reporter: Ramesh Reddy Assignee: Ramesh Reddy ConnectionFactory requires a two step creation process 1) create the resource-adaptor section 2) connection factory section The delete is removing the (2) and not (1). Thus any subsequent creates using the same name fails. -- 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

13 years, 5 months

2
6
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues October 2012