October 2010 - teiid-issues - Jboss List Archives

[JBoss JIRA] Created: (TEIID-1335) Customer requesting the ability to make query planner always create dependent joins.

by Debbie Steigner (JIRA)

Customer requesting the ability to make query planner always create dependent joins. ------------------------------------------------------------------------------------ Key: TEIID-1335 URL: https://jira.jboss.org/browse/TEIID-1335 Project: Teiid Issue Type: Feature Request Components: Server Reporter: Debbie Steigner Assignee: Steven Hawkins Nike is finding that the query planner often chooses to use a non-dependent join plan, even when cost statistics have been gathered on all source systems and a dependent plan would perform much better. I've showed them how to use option makedep to force a dependent join scenario. However, it requires careful analysis of each query to setup the proper makedep parameters, and may not be feasible when working with hibernate as the client. Thus, they ask: is there any way to tell the query planner to always use dependent join for every join, no matter what. -- 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-1324) Deploy JOPR Plugin on JON/RHQ

by Cristiano Nicolai (JIRA)

Deploy JOPR Plugin on JON/RHQ ----------------------------- Key: TEIID-1324 URL: https://jira.jboss.org/browse/TEIID-1324 Project: Teiid Issue Type: Bug Components: Jopr Plugin Affects Versions: 7.2 Environment: Jboss EAP 5.1, JON 2.4, jon-plugin-pack-eap-2.4.0.GA Reporter: Cristiano Nicolai Assignee: Steven Hawkins When deploying Teiid JOPR plugin on JON, when the agent try to run the plugin there are some missing classes. Caused by: java.lang.NoClassDefFoundError: org/jboss/reflect/spi/TypeInfo at java.lang.Class.getDeclaredConstructors0(Native Method) at java.lang.Class.privateGetDeclaredConstructors(Class.java:2389) at java.lang.Class.getConstructor0(Class.java:2699) at java.lang.Class.newInstance0(Class.java:326) at java.lang.Class.newInstance(Class.java:308) at org.jboss.metatype.plugins.values.MetaValueFactoryBuilder$1.run(MetaValueFactoryBuilder.java:71) at org.jboss.metatype.plugins.values.MetaValueFactoryBuilder$1.run(MetaValueFactoryBuilder.java:46) at java.security.AccessController.doPrivileged(Native Method) at org.jboss.metatype.plugins.values.MetaValueFactoryBuilder.<clinit>(MetaValueFactoryBuilder.java:45) at org.jboss.metatype.api.values.MetaValueFactory.<clinit>(MetaValueFactory.java:41) at org.teiid.rhq.admin.DQPManagementView.<clinit>(DQPManagementView.java:68) at org.teiid.rhq.plugin.VDBComponent.getAvailability(VDBComponent.java:139) at sun.reflect.GeneratedMethodAccessor50.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.inventory.ResourceContainer$ComponentInvocationThread.call(ResourceContainer.java:525) ... 5 more Basically the missing jar is jboss-metatype.jar. I tried some classloader configuration including the missing jar in teiid-console-7.2.0.Beta1.jar/lib, but as it has dependent classes (jboss-managed.jar) that are loaded in jboss-as-5 RHQ plugin I couldn't find any solution without changing the jboss-as-5 code. Probably some sync with RHQ guys is needed because jboss-managed.jar depends on jboss-metatype.jar. My workaround for this was a code change in ApplicationServerDiscoveryComponent to include the required jar from the AS installation. private static final List<String> CLIENT_JARS = Arrays.asList( // NOTE: The jbossall-client.jar aggregates a whole bunch of other jars from the client dir via its // MANIFEST.MF Class-Path. "client/jbossall-client.jar", "client/trove.jar", "client/javassist.jar", "common/lib/jboss-security-aspects.jar", "lib/jboss-managed.jar", "lib/jboss-metatype.jar", "lib/jboss-reflect.jar", "lib/jboss-dependency.jar" ); Fixing this class dependency the plugin start to require some Teiid client classes and to solve this I just copy the teiid-7.2.0.Beta1-client.jar to teiid-console-7.2.0.Beta1.jar/lib and redeploy the plugin. -- 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

4
15
0 / 0

[JBoss JIRA] Created: (TEIID-1212) Add replication for internal materialized view tables

by Steve Hawkins (JIRA)

Add replication for internal materialized view tables ----------------------------------------------------- Key: TEIID-1212 URL: https://jira.jboss.org/browse/TEIID-1212 Project: Teiid Issue Type: Feature Request Components: Query Engine Affects Versions: 7.1 Reporter: Steve Hawkins Assignee: Steve Hawkins Fix For: 7.1.1 Internal materialized view tables and their indexes should be replicated to other cluster members. -- 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-1332) After updating ManagedComponent value via ProfileService, Teiid JOPR components get Availability down

by Cristiano Nicolai (JIRA)

After updating ManagedComponent value via ProfileService, Teiid JOPR components get Availability down ------------------------------------------------------------------------------------------------------ Key: TEIID-1332 URL: https://jira.jboss.org/browse/TEIID-1332 Project: Teiid Issue Type: Bug Components: Jopr Plugin Affects Versions: 7.2 Environment: JbossAS 5.1 Reporter: Cristiano Nicolai Assignee: Steven Hawkins Attachments: SimpleUpdate.java After updating some Teiid ManagementComponent value via ProfileService their availability status in Admin Console are showed as down but after refreshing the page causes the status to be up again. The main problem is that the ManagementView isn't refreshed after the ManagementComponent is updated. To fix it, all Teiid JOPR components (DataRoleComponent, PlatformComponent, TranslatorComponent, VDBComponent) must call managementView.load() after updating the ManagementComponent in updateResourceConfiguration method. This problem cause the JON Agent Plugin to report the JON server that the services are DOWN. -- 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

4
5
0 / 0

[JBoss JIRA] Created: (TEIID-1271) Add more logging for pushdown decisions

by Steven Hawkins (JIRA)

Add more logging for pushdown decisions --------------------------------------- Key: TEIID-1271 URL: https://jira.jboss.org/browse/TEIID-1271 Project: Teiid Issue Type: Quality Risk Components: Query Engine Affects Versions: 7.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Minor Fix For: 7.1.1 It may not be immediately obvious why something doesn't push down. It would be good to have some form of logging in ruleraiseaccess/criteriacapabilityvalidationvisitor. -- 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
2
0 / 0

[JBoss JIRA] Created: (TEIID-1277) Add documentation/article about how to use the "import web-service as relational model" generated model.

by Ramesh Reddy (JIRA)

Add documentation/article about how to use the "import web-service as relational model" generated model. -------------------------------------------------------------------------------------------------------- Key: TEIID-1277 URL: https://jira.jboss.org/browse/TEIID-1277 Project: Teiid Issue Type: Task Components: Documentation Affects Versions: 7.1 Reporter: Ramesh Reddy Fix For: 7.1.1 Currently there is no documentation about how to use the models generated by WSDL to Relational Model importer in the Teiid Designer. I am not sure where the document needs to exist, as to in Teiid or Teiid Designer or just as an WIKI article, but Teiid MUST have this. -- 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-1049) Create data source for each VDB deployed automaticaly

by Ramesh Reddy (JIRA)

Create data source for each VDB deployed automaticaly ----------------------------------------------------- Key: TEIID-1049 URL: https://jira.jboss.org/jira/browse/TEIID-1049 Project: Teiid Issue Type: Feature Request Components: Embedded Affects Versions: 7.0 Reporter: Ramesh Reddy Priority: Minor Fix For: 7.0 When a VDB is deployed, auto create a data source for the deployed VDB using the Teiid's "embedded" data source class. -- 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

3
5
0 / 0

[JBoss JIRA] Created: (TEIID-1306) Add support for JSON data sources (JSON translator, JSON-to-table mapping functions).

by Ken Johnson (JIRA)

Add support for JSON data sources (JSON translator, JSON-to-table mapping functions). ------------------------------------------------------------------------------------- Key: TEIID-1306 URL: https://jira.jboss.org/browse/TEIID-1306 Project: Teiid Issue Type: Feature Request Components: Misc. Connectors Affects Versions: 7.1 Reporter: Ken Johnson Assignee: Steven Hawkins Fix For: 7.2 Consider adding support in Teiid to consume services (as data sources) that return JSON payloads rather than XML payloads. This is an increasingly common integration scenario. The approach used for XML processing seems to be a compatible pattern for this use case. -- 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, 10 months

2
6
0 / 0

[JBoss JIRA] Created: (TEIID-586) Like pushdown handling

by Steven Hawkins (JIRA)

Like pushdown handling ---------------------- Key: TEIID-586 URL: https://jira.jboss.org/jira/browse/TEIID-586 Project: Teiid Issue Type: Bug Components: LDAP Connector, Query Engine, Salesforce Connector Affects Versions: 6.0.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Minor Fix For: 6.2.0 Both salesforce and ldap like semantics are not the same as SQL. We could capture this with more capabilities supportsLikeCaseSensitive and supportsLikeWildcardSingleCharacter repectively, or another approach would be to allow the connector to generically indicate partial support and have the query engine both push down the conjunct and leave a copy to be applied after the query. With either explicit supports or generic partial support it would only applicable to top level where clause conjuncts. -- 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, 10 months

2
3
0 / 0

[JBoss JIRA] Created: (TEIID-1170) Support subqueries in temp table update/delete criteria

by Steve Hawkins (JIRA)

Support subqueries in temp table update/delete criteria ------------------------------------------------------- Key: TEIID-1170 URL: https://jira.jboss.org/browse/TEIID-1170 Project: Teiid Issue Type: Feature Request Affects Versions: 6.0.0 Reporter: Steve Hawkins Assignee: Steve Hawkins Priority: Minor Fix For: 8.0 Subqueries are currently not supported in temp table update/delete criteria. -- 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, 10 months

2
1
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues October 2010