August 2011 - teiid-issues - Jboss List Archives

[JBoss JIRA] Created: (TEIID-1474) Add query hint to limit parallel execution of union members

by Howard Abrams (JIRA)

Add query hint to limit parallel execution of union members ----------------------------------------------------------- Key: TEIID-1474 URL: https://issues.jboss.org/browse/TEIID-1474 Project: Teiid Issue Type: Feature Request Reporter: Howard Abrams 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

12 years, 10 months

2
7
0 / 0

[JBoss JIRA] Created: (TEIID-1515) ODBC does not report primarykeys on the tables

by Ramesh Reddy (JIRA)

ODBC does not report primarykeys on the tables ---------------------------------------------- Key: TEIID-1515 URL: https://issues.jboss.org/browse/TEIID-1515 Project: Teiid Issue Type: Bug Components: ODBC Affects Versions: 7.3, 7.2, 7.1.1 Reporter: Ramesh Reddy Assignee: Ramesh Reddy Priority: Critical Fix For: 7.1.1 ODBC Driver upon retrieval of metadata is not reporting the Primary Key information. Also it does not report "isNullable" property correctly. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 10 months

2
3
0 / 0

[JBoss JIRA] Created: (TEIID-1532) ODBC prepared statement handling can hang

by Steven Hawkins (JIRA)

ODBC prepared statement handling can hang ----------------------------------------- Key: TEIID-1532 URL: https://issues.jboss.org/browse/TEIID-1532 Project: Teiid Issue Type: Bug Components: Server Affects Versions: 7.1.1 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.4 preparedstatement execution through odbc can hang since we are never sending a synch. But we must only send a synch if there are no pending messages. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 10 months

1
2
0 / 0

[JBoss JIRA] Created: (TEIID-1569) Documentation on creating UDF, extending ExecutionFactory and defining @Translator name should indicate what to do with the translator name

by Van Halbert (JIRA)

Documentation on creating UDF, extending ExecutionFactory and defining @Translator name should indicate what to do with the translator name ------------------------------------------------------------------------------------------------------------------------------------------- Key: TEIID-1569 URL: https://issues.jboss.org/browse/TEIID-1569 Project: Teiid Issue Type: Enhancement Components: Documentation Affects Versions: 7.1.1 Reporter: Van Halbert Assignee: Steven Hawkins Priority: Minor A user was trying to follow the documentation (http://docs.jboss.org/teiid/7.3.0.Final/developer-guide/en-US/html_single...) on creating a UDF and have it pushed down to the source. But they didn't make the correlation between the process of extending the ExecutionFactory and then having to use the defined @Translator name. It wasn't obvious to them. Therefore, I think it would be good to indicated in the "Required" segment of the example of extending the Oracle Connector: Required - extend the OracleExecutionFactory and add SCORE and CONTAINS as supported functions. For this example, we'll call the class MyOracleExecutionFactory. Add the org.teiid.translator.Translator annotation to the class, e.g. @Translator(name="myoracle") ------ Add a follow on sentence to indicate that the @Translator name (i.e., "myoracle") is the name to assign to the translator for the physical model for which the custom translator will be used (or something like that). -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 10 months

3
3
0 / 0

[JBoss JIRA] Created: (TEIID-1561) Database Calender is not correctly being set in JDBC Translator

by Ramesh Reddy (JIRA)

Database Calender is not correctly being set in JDBC Translator --------------------------------------------------------------- Key: TEIID-1561 URL: https://issues.jboss.org/browse/TEIID-1561 Project: Teiid Issue Type: Bug Components: JDBC Connector Affects Versions: 7.1 Reporter: Ramesh Reddy Assignee: Ramesh Reddy Fix For: 7.4 When the JDBC translator extends the timezone property to set database calender, it is incorrectly being initialized for the executing thread. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 10 months

2
2
0 / 0

[JBoss JIRA] Created: (TEIID-1554) NullPointerException in NodeEditor

by Mark Addleman (JIRA)

NullPointerException in NodeEditor ---------------------------------- Key: TEIID-1554 URL: https://issues.jboss.org/browse/TEIID-1554 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.3 Reporter: Mark Addleman Assignee: Steven Hawkins NPE in NodeEditor with the following SQL: SQL SELECT B."SYSID", B."USERID", (SELECT COUNT(*) FROM (SELECT * FROM notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT("SECURITY.BASEUSER", XMLATTRIBUTES(B."SYSID",B."USERID")) as String)) as foo) as C_notesForObject, 'SECURITY.BASEUSER' as "_objecttype_" FROM "SECURITY.BASEUSER" as B ORDER BY B."USERID" ASC LIMIT 10 Stack trace: org.teiid.jdbc.TeiidSQLException: org.teiid.core.TeiidException at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:109) at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:69) at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:497) at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:214) at com.ca.chorus.db.DbExecutor.withResultSet(DbExecutor.java:198) at com.ca.chorus.db.DbExecutor.gatherResults(DbExecutor.java:367) at com.ca.chorus.db.DbExecutor.gatherResults(DbExecutor.java:361) at com.ca.chorus.teiidtest.TestTeiid.run(TestTeiid.java:72) at com.ca.chorus.teiidtest.TestTeiid.main(TestTeiid.java:24) Caused by: [TeiidException] 1 [NullPointerException] at org.teiid.client.ResultsMessage.setException(ResultsMessage.java:177) at org.teiid.dqp.internal.process.RequestWorkItem.sendError(RequestWorkItem.java:557) at org.teiid.dqp.internal.process.RequestWorkItem.attemptClose(RequestWorkItem.java:335) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:218) at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:188) at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:116) at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:290) 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:619) Caused by: java.lang.NullPointerException at org.teiid.query.optimizer.relational.plantree.NodeEditor.findAllNodesHelper(NodeEditor.java:123) at org.teiid.query.optimizer.relational.plantree.NodeEditor.findAllNodes(NodeEditor.java:102) at org.teiid.query.optimizer.relational.rules.RuleCollapseSource.execute(RuleCollapseSource.java:85) at org.teiid.query.optimizer.relational.RelationalPlanner.executeRules(RelationalPlanner.java:458) at org.teiid.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:227) at org.teiid.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:148) at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:429) at org.teiid.dqp.internal.process.PreparedStatementRequest.generatePlan(PreparedStatementRequest.java:138) at org.teiid.dqp.internal.process.Request.processRequest(Request.java:452) at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:372) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:174) ... 7 more -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 10 months

3
11
0 / 0

[JBoss JIRA] Created: (TEIID-1445) ConcurrentModificationException during the startup of the Server

by Ramesh Reddy (JIRA)

ConcurrentModificationException during the startup of the Server ---------------------------------------------------------------- Key: TEIID-1445 URL: https://issues.jboss.org/browse/TEIID-1445 Project: Teiid Issue Type: Bug Components: Server Affects Versions: 7.2 Reporter: Ramesh Reddy Assignee: Steven Hawkins Priority: Minor Fix For: 7.3 Seems like this is some timing issue. java.util.ConcurrentModificationException at java.util.AbstractList$Itr.checkForComodification(AbstractList.java:372) at java.util.AbstractList$Itr.next(AbstractList.java:343) at org.teiid.adminapi.impl.ModelMetaData.getValidationErrors(ModelMetaData.java:222) at org.teiid.adminapi.impl.ModelMetaData.getErrors(ModelMetaData.java:210) at org.teiid.adminapi.impl.VDBMetaData.getValidityErrors(VDBMetaData.java:249) at org.teiid.adminapi.impl.VDBMetaData.isValid(VDBMetaData.java:264) at org.teiid.deployers.VDBDeployer.loadMetadata(VDBDeployer.java:355) at org.teiid.deployers.VDBDeployer.access$2(VDBDeployer.java:315) at org.teiid.deployers.VDBDeployer$1.run(VDBDeployer.java:308) at org.jboss.util.threadpool.RunnableTaskWrapper.run(RunnableTaskWrapper.java:147) 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:619) -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 10 months

4
14
0 / 0

[JBoss JIRA] Created: (TEIID-1555) NPE on server when admin-console requests for the "vdb requests"

by Ramesh Reddy (JIRA)

NPE on server when admin-console requests for the "vdb requests" ---------------------------------------------------------------- Key: TEIID-1555 URL: https://issues.jboss.org/browse/TEIID-1555 Project: Teiid Issue Type: Bug Components: Server Affects Versions: 7.4 Reporter: Ramesh Reddy Fix For: 7.4 17:14:51,642 ERROR [rhq] Exception getting the AdminApi in getRequestsUsingVDB java.lang.reflect.UndeclaredThrowableException: Failed to invoke method 'getRequestsUsingVDB' on component 'RuntimeEngineDeployer' with parameters [SimpleMetaType:java.lang.String:bqt, SimpleMetaType:int:1]. at org.jboss.profileservice.management.KernelBusRuntimeComponentDispatcher.invoke(KernelBusRuntimeComponentDispatcher.java:201) at org.jboss.profileservice.management.DelegatingComponentDispatcherImpl.invoke(DelegatingComponentDispatcherImpl.java:69) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.jboss.aop.Dispatcher.invoke(Dispatcher.java:121) at org.jboss.aspects.remoting.AOPRemotingInvocationHandler.invoke(AOPRemotingInvocationHandler.java:82) at org.jboss.profileservice.remoting.ProfileServiceInvocationHandler.invoke(ProfileServiceInvocationHandler.java:97) at org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:891) at org.jboss.remoting.transport.local.LocalClientInvoker.invoke(LocalClientInvoker.java:106) at org.jboss.remoting.Client.invoke(Client.java:1724) at org.jboss.remoting.Client.invoke(Client.java:629) at org.jboss.aspects.remoting.InvokeRemoteInterceptor.invoke(InvokeRemoteInterceptor.java:60) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.aspects.remoting.MergeMetaDataInterceptor.invoke(MergeMetaDataInterceptor.java:74) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.aspects.security.SecurityClientInterceptor.invoke(SecurityClientInterceptor.java:65) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.aop.generatedproxies.AOPProxy$1.invoke(AOPProxy$1.java) at org.jboss.profileservice.management.ManagedOperationDelegate.invoke(ManagedOperationDelegate.java:64) at org.teiid.rhq.admin.DQPManagementView.executeManagedOperation(DQPManagementView.java:526) at org.teiid.rhq.admin.DQPManagementView.getRequestsForVDB(DQPManagementView.java:443) at org.teiid.rhq.admin.DQPManagementView.executeVdbOperation(DQPManagementView.java:291) at org.teiid.rhq.admin.DQPManagementView.executeOperation(DQPManagementView.java:183) at org.teiid.rhq.plugin.Facet.execute(Facet.java:232) at org.teiid.rhq.plugin.Facet.invokeOperation(Facet.java:293) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 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:482) 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:619) Caused by: java.lang.NullPointerException at org.teiid.jboss.deployers.RuntimeEngineDeployer.getRequestsUsingVDB(RuntimeEngineDeployer.java:391) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.jboss.reflect.plugins.introspection.ReflectionUtils.invoke(ReflectionUtils.java:59) at org.jboss.reflect.plugins.introspection.ReflectMethodInfoImpl.invoke(ReflectMethodInfoImpl.java:150) at org.jboss.joinpoint.plugins.BasicMethodJoinPoint.dispatch(BasicMethodJoinPoint.java:66) at org.jboss.beans.info.plugins.AbstractBeanInfo.invoke(AbstractBeanInfo.java:300) at org.jboss.kernel.plugins.dependency.AbstractKernelControllerContext.invoke(AbstractKernelControllerContext.java:286) at org.jboss.kernel.plugins.registry.basic.BasicKernelBus$3.dispatch(BasicKernelBus.java:96) at org.jboss.kernel.plugins.registry.basic.BasicKernelBus$3.dispatch(BasicKernelBus.java:99) at org.jboss.kernel.plugins.registry.basic.BasicKernelBus.execute(BasicKernelBus.java:54) at org.jboss.kernel.plugins.registry.basic.BasicKernelBus.invoke(BasicKernelBus.java:92) at org.jboss.profileservice.management.KernelBusRuntimeComponentDispatcher.invoke(KernelBusRuntimeComponentDispatcher.java:186) at org.jboss.profileservice.management.DelegatingComponentDispatcherImpl.invoke(DelegatingComponentDispatcherImpl.java:69) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.jboss.aop.Dispatcher.invoke(Dispatcher.java:121) at org.jboss.aspects.remoting.AOPRemotingInvocationHandler.invoke(AOPRemotingInvocationHandler.java:82) at org.jboss.profileservice.remoting.ProfileServiceInvocationHandler.invoke(ProfileServiceInvocationHandler.java:97) at org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:891) at org.jboss.remoting.transport.local.LocalClientInvoker.invoke(LocalClientInvoker.java:106) at org.jboss.remoting.Client.invoke(Client.java:1724) at org.jboss.remoting.Client.invoke(Client.java:629) at org.jboss.aspects.remoting.InvokeRemoteInterceptor.invoke(InvokeRemoteInterceptor.java:60) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.aspects.remoting.MergeMetaDataInterceptor.invoke(MergeMetaDataInterceptor.java:74) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.aspects.security.SecurityClientInterceptor.invoke(SecurityClientInterceptor.java:65) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.aop.generatedproxies.AOPProxy$1.invoke(AOPProxy$1.java) at org.jboss.profileservice.management.ManagedOperationDelegate.invoke(ManagedOperationDelegate.java:64) at org.teiid.rhq.admin.DQPManagementView.executeManagedOperation(DQPManagementView.java:526) at org.teiid.rhq.admin.DQPManagementView.getRequestsForVDB(DQPManagementView.java:443) at org.teiid.rhq.admin.DQPManagementView.executeVdbOperation(DQPManagementView.java:291) at org.teiid.rhq.admin.DQPManagementView.executeOperation(DQPManagementView.java:183) at org.teiid.rhq.plugin.Facet.execute(Facet.java:232) at org.teiid.rhq.plugin.Facet.invokeOperation(Facet.java:293) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 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:482) 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:619) at org.jboss.aspects.remoting.InvokeRemoteInterceptor.invoke(InvokeRemoteInterceptor.java:72) ... 23 more -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 10 months

2
2
0 / 0

[JBoss JIRA] Created: (TEIID-1327) API request: Fine grained security

by Mark Addleman (JIRA)

API request: Fine grained security ----------------------------------- Key: TEIID-1327 URL: https://jira.jboss.org/browse/TEIID-1327 Project: Teiid Issue Type: Feature Request Components: Query Engine Affects Versions: 7.1 Reporter: Mark Addleman Assignee: Steven Hawkins I'd like an API to implement fine grained security checks. The use case is to create a permission from each table+column requested, each stored procedure and other database objects and validate the user id and permission against an external security manager. -- 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, 10 months

3
23
0 / 0

[JBoss JIRA] Created: (TEIID-1530) ODBC identifer matching issues

by Steven Hawkins (JIRA)

ODBC identifer matching issues ------------------------------ Key: TEIID-1530 URL: https://issues.jboss.org/browse/TEIID-1530 Project: Teiid Issue Type: Bug Components: Server Affects Versions: 7.1 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.4 The odbc system query matching only allows literals that have basic characters. A lesser issue is that it also does not consider postgres escaping, which changes how formating characters are entered. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 10 months

1
3
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues August 2011