July 2010 - teiid-issues - Jboss List Archives

[JBoss JIRA] Created: (TEIID-829) revamp code table caching

by Steven Hawkins (JIRA)

revamp code table caching ------------------------- Key: TEIID-829 URL: https://jira.jboss.org/jira/browse/TEIID-829 Project: Teiid Issue Type: Feature Request Components: Query Engine Affects Versions: 6.3.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 6.3.0 Code tables have several design issues: 1. the cache should allow for eviction and possibly expiration. 2. the cache should be backed by the common caching facility. 3. should allow for explicit scoping - at a minimum global vs. vdb, but additional may be good to allow session and request. 4. the implementation should be minimally blocking (in terms of both query execution and use of synchronization). -- 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

13 years, 9 months

2
8
0 / 0

[JBoss JIRA] Created: (TEIID-892) Add a capability to control bulk insert batch size

by Steven Hawkins (JIRA)

Add a capability to control bulk insert batch size -------------------------------------------------- Key: TEIID-892 URL: https://jira.jboss.org/jira/browse/TEIID-892 Project: Teiid Issue Type: Feature Request Components: Connector API, Query Engine Affects Versions: 7.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Minor Fix For: 7.0 Based upon a recent customer conversation our default batching strategy to the connector may not be the most performant for large datasets. In general our current approach limits batches to a maximum = processor batch size (default 2000). We already have a property connector batch size, but it's across all connectors - and is mostly irrelevant since the source fetch size will have a larger impact on performance and the result batches are resized to the processor batch size anyway. The only time connector batch size really matters is if we bring back "remote" connectors. -- 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

13 years, 9 months

2
3
0 / 0

[JBoss JIRA] Created: (TEIID-1162) Document the recommended approach to using entitlements

by Van Halbert (JIRA)

Document the recommended approach to using entitlements ------------------------------------------------------- Key: TEIID-1162 URL: https://jira.jboss.org/browse/TEIID-1162 Project: Teiid Issue Type: Task Components: Documentation Reporter: Van Halbert Assignee: Steve Hawkins Priority: Blocker Document the recommended approach to using entitlements and indicate what happens when permissions are applied to a Virtual Layer for which the underlying (virtual) model already has entitlements assigned. Any concerns, regarding how data might be accidentally exposed, should be highlighted. Yes, we say an experienced person should be the one responsible for security, but we must also provide direction to this person in order that they be successful. -- 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, 9 months

2
4
0 / 0

[JBoss JIRA] Created: (TEIID-1028) Make Materialized Views first class objects in the system

by Van Halbert (JIRA)

Make Materialized Views first class objects in the system --------------------------------------------------------- Key: TEIID-1028 URL: https://jira.jboss.org/jira/browse/TEIID-1028 Project: Teiid Issue Type: Feature Request Reporter: Van Halbert Assignee: Steven Hawkins Fix For: 7.1 Rework the MetMatrix materialized views functionality to make mat views first class objects in the system. Full materialization control to an external source was being discussed as a designer based activity. -- 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

13 years, 9 months

2
2
0 / 0

[JBoss JIRA] Created: (TEIID-1175) SqlServer 2005 - Queries failing due to negative values being treated as positive values

by Warren Gibson (JIRA)

SqlServer 2005 - Queries failing due to negative values being treated as positive values ---------------------------------------------------------------------------------------- Key: TEIID-1175 URL: https://jira.jboss.org/browse/TEIID-1175 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.1 Reporter: Warren Gibson Assignee: Steve Hawkins It appears results are being returned without consideration for the negative(-) sign - RDBMS_Test_Queries_1000_TestQuery169 SELECT SmallA.IntKey FROM SmallA WHERE SmallA.StringNum > 11 AND SmallA.StringNum < 15 ORDER BY IntKey Query suite is expecting 3 rows returned. Query results straight to source returns: 36 37 38 Query results from Teiid: 10 11 12 13 36 37 38 Source contains the following for IntKey and StringNum IntKey StringNum 0 -24 1 <null> 2 -22 3 -21 4 -20 5 -19 6 -18 7 -17 8 -16 9 -15 10 -14 11 -13 12 -12 13 -11 14 -10 15 -9 16 -8 17 <null> 18 -6 19 -5 20 -4 21 -3 22 -2 23 -1 24 0 25 1 26 2 27 3 28 4 29 5 30 6 31 7 32 8 33 <null> 34 10 35 11 36 12 37 13 38 14 39 15 40 16 41 17 42 18 43 19 44 20 45 21 46 22 47 23 48 24 -- 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, 9 months

2
10
0 / 0

[JBoss JIRA] Created: (TEIID-1167) Add support for primary key handling in temp tables

by Steve Hawkins (JIRA)

Add support for primary key handling in temp tables --------------------------------------------------- Key: TEIID-1167 URL: https://jira.jboss.org/browse/TEIID-1167 Project: Teiid Issue Type: Feature Request Components: Query Engine Affects Versions: 7.1 Reporter: Steve Hawkins Assignee: Steve Hawkins Fix For: 7.1 We should add support for primary keys in our temp tables. With indexing, this support will also be used as the basis for our intermediate view level caching. -- 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, 9 months

1
3
0 / 0

[JBoss JIRA] Created: (TEIID-1173) Provide a facility to create "empty" VDBs for preview purpose

by Ramesh Reddy (JIRA)

Provide a facility to create "empty" VDBs for preview purpose ------------------------------------------------------------- Key: TEIID-1173 URL: https://jira.jboss.org/browse/TEIID-1173 Project: Teiid Issue Type: Task Components: Server Affects Versions: 7.0 Reporter: Ramesh Reddy Assignee: Ramesh Reddy Fix For: 7.1 For supporting the preview functionality, Designer team requests to be able to deploy a VDB with no models in them, so that required models can be merged into it later on. However currently this fails because, Teiid VDB deployer check to make sure there is a model and it has metadata. This restriction needs to be relaxed for preview VDBs. -- 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, 9 months

2
3
0 / 0

[JBoss JIRA] Created: (TEIID-1153) Turned of ProfileService authenticatiion and it caused an NPE in the Teiid RHQ Plugin

by Van Halbert (JIRA)

Turned of ProfileService authenticatiion and it caused an NPE in the Teiid RHQ Plugin ------------------------------------------------------------------------------------- Key: TEIID-1153 URL: https://jira.jboss.org/browse/TEIID-1153 Project: Teiid Issue Type: Bug Components: Jopr Plugin Environment: SOA-P Reporter: Van Halbert Assignee: Steve Hawkins Turned of ProfileService authenticatiion and it caused an NPE in the Teiid RHQ Plugin, Exception: java.lang.Exception: Discovery component invocation failed. at org.rhq.core.pc.util.DiscoveryComponentProxyFactory$ComponentInvocationThread.call(DiscoveryComponentProxyFactory.java:270) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:637) Caused by: java.lang.NullPointerException at org.teiid.rhq.plugin.util.ProfileServiceUtil.getSimpleValue(ProfileServiceUtil.java:296) at org.teiid.rhq.plugin.PlatformDiscoveryComponent.discoverResources(PlatformDiscoveryComponent.java:66) at sun.reflect.GeneratedMethodAccessor339.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.rhq.core.pc.util.DiscoveryComponentProxyFactory$ComponentInvocationThread.call(DiscoveryComponentProxyFactory.java:266) ... 5 more -- 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, 9 months

3
3
0 / 0

[JBoss JIRA] Created: (TEIID-907) Add a sample connector template for starting a new connector development

by Ramesh Reddy (JIRA)

Add a sample connector template for starting a new connector development ------------------------------------------------------------------------ Key: TEIID-907 URL: https://jira.jboss.org/jira/browse/TEIID-907 Project: Teiid Issue Type: Sub-task Components: Documentation, Misc. Connectors Reporter: Ramesh Reddy Assignee: Ramesh Reddy Fix For: 7.0 To be distributed with the CDK eclipse plugin development, we need a sample connector code. This CDK plug-in will use this code and token replace various elements in this and provide user with a very simple skeleton connector code for developer to start writing a custom connector. -- 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

13 years, 9 months

2
2
0 / 0

[JBoss JIRA] Created: (TEIID-860) Add odbc support

by Steven Hawkins (JIRA)

Add odbc support ---------------- Key: TEIID-860 URL: https://jira.jboss.org/jira/browse/TEIID-860 Project: Teiid Issue Type: Feature Request Components: Query Engine, Server Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 6.3 Support for ODBC should be added to the server. H2 has an emulation mode for pg odbc that could serve as our template as well. Just like the OA system tables, we would need to add pg system tables (possibly adding a mechanism to inject additional system vdbs, rather than adding more tables to the system.vdb). Clients would use http://www.postgresql.org/ftp/odbc/versions/ -- 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

13 years, 9 months

4
7
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues July 2010