[JBoss JIRA] (TEIID-2656) Teiid OData Servlet throws java.lang.NullPointerException on every GET
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-2656?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration commented on TEIID-2656:
------------------------------------------------
belong(a)redhat.com made a comment on [bug 1006961|https://bugzilla.redhat.com/show_bug.cgi?id=1006961]
Fixed before GA - setting to requires_doc_text- accordingly
> Teiid OData Servlet throws java.lang.NullPointerException on every GET
> ----------------------------------------------------------------------
>
> Key: TEIID-2656
> URL: https://issues.jboss.org/browse/TEIID-2656
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.3, 8.4
> Environment: Windows 7 64 bit
> Oracle JDK 1.7.0 update 17
> JBoss AS 7.1.1 + Teiid 8.3 (both resteasy-jaxrs 2.3.5 and 2.3.7)
> JBoss EAP 6.1 + Teiid 8.4 (resteasy-jaxrs 2.3.6)
> Reporter: John Muller
> Assignee: Steven Hawkins
> Labels: final
> Fix For: 8.4.1, 8.5
>
> Attachments: server.log, Teiid_8.4_on_JBoss_EAP_6.1Alpha_RHEL6.log
>
>
> A simple GET on any Teiid 8.3 or 8.4 OData ReST resource results in a Null Pointer:
> 11:43:20,166 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/odata].[Resteasy]] (http-localhost-127.0.0.1-8080-2) Servlet.service() for servlet Resteasy threw exception: java.lang.NullPointerException
> at com.ctc.wstx.sw.BaseStreamWriter.writeCharacters(BaseStreamWriter.java:447)
> at org.codehaus.stax2.ri.Stax2EventWriterImpl.add(Stax2EventWriterImpl.java:124)
> at org.odata4j.stax2.staximpl.StaxXMLWriter2.writeText(StaxXMLWriter2.java:108) [odata4j-core-0.8.0-SNAPSHOT-redhat.jar:]
> at org.odata4j.format.xml.AtomErrorFormatWriter.writeError(AtomErrorFormatWriter.java:31) [odata4j-core-0.8.0-SNAPSHOT-redhat.jar:]
> at org.odata4j.format.xml.AtomErrorFormatWriter.write(AtomErrorFormatWriter.java:20) [odata4j-core-0.8.0-SNAPSHOT-redhat.jar:]
> at org.odata4j.format.xml.AtomErrorFormatWriter.write(AtomErrorFormatWriter.java:15) [odata4j-core-0.8.0-SNAPSHOT-redhat.jar:]
> at org.teiid.odata.ODataExceptionMappingProvider.toResponse(ODataExceptionMappingProvider.java:55) [classes:]
> at org.teiid.odata.ODataExceptionMappingProvider.toResponse(ODataExceptionMappingProvider.java:42) [classes:]
> at org.jboss.resteasy.core.SynchronousDispatcher.executeExceptionMapper(SynchronousDispatcher.java:344) [resteasy-jaxrs-2.3.7.Final.jar:]
> at org.jboss.resteasy.core.SynchronousDispatcher.unwrapException(SynchronousDispatcher.java:373) [resteasy-jaxrs-2.3.7.Final.jar:]
> at org.jboss.resteasy.core.SynchronousDispatcher.handleApplicationException(SynchronousDispatcher.java:362) [resteasy-jaxrs-2.3.7.Final.jar:]
> at org.jboss.resteasy.core.SynchronousDispatcher.handleException(SynchronousDispatcher.java:233) [resteasy-jaxrs-2.3.7.Final.jar:]
> at org.jboss.resteasy.core.SynchronousDispatcher.handleInvokerException(SynchronousDispatcher.java:209) [resteasy-jaxrs-2.3.7.Final.jar:]
> at org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:557) [resteasy-jaxrs-2.3.7.Final.jar:]
> at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:524) [resteasy-jaxrs-2.3.7.Final.jar:]
> at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:126) [resteasy-jaxrs-2.3.7.Final.jar:]
> at org.teiid.odata.ODataServletContainerDispatcher.service(ODataServletContainerDispatcher.java:97) [classes:]
> at org.teiid.odata.ODataServlet.service(ODataServlet.java:61) [classes:]
> at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50) [resteasy-jaxrs-2.3.7.Final.jar:]
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329) [jbossweb-7.0.13.Final.jar:]
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.13.Final.jar:]
> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) [jbossweb-7.0.13.Final.jar:]
> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161) [jbossweb-7.0.13.Final.jar:]
> at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:489) [jbossweb-7.0.13.Final.jar:]
> at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153) [jboss-as-web-7.1.1.Final.jar:7.1.1.Final]
> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155) [jbossweb-7.0.13.Final.jar:]
> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [jbossweb-7.0.13.Final.jar:]
> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [jbossweb-7.0.13.Final.jar:]
> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368) [jbossweb-7.0.13.Final.jar:]
> at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) [jbossweb-7.0.13.Final.jar:]
> at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671) [jbossweb-7.0.13.Final.jar:]
> at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930) [jbossweb-7.0.13.Final.jar:]
> at java.lang.Thread.run(Unknown Source) [rt.jar:1.7.0_17]
--
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
10 years, 6 months
[JBoss JIRA] (TEIID-2660) OData procedure issues
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-2660?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration commented on TEIID-2660:
------------------------------------------------
belong(a)redhat.com made a comment on [bug 1006961|https://bugzilla.redhat.com/show_bug.cgi?id=1006961]
Fixed before GA - setting to requires_doc_text- accordingly
> OData procedure issues
> ----------------------
>
> Key: TEIID-2660
> URL: https://issues.jboss.org/browse/TEIID-2660
> Project: Teiid
> Issue Type: Bug
> Components: Server
> Affects Versions: 8.3
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Priority: Critical
> Fix For: 8.4.1, 8.5
>
>
> Calling a procedure through Teiid's odata interface has several issues. First is that joda time values are passed directly - which the runtime will not be able to convert to analogous Teiid time types. Ultimately this appears as a classcastexception, which is due to logic in the joda time AbstractPartial.compareTo method (which may be reported with an erroneous message and seems odd in general, but is their way of saying the comparison is invalid).
> Another is that the logic assumes that the url will be called with the positional ordering of the parameters preserved. We should use named parameters instead.
--
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
10 years, 6 months
[JBoss JIRA] (TEIID-2678) Query against OData source throwing java.lang.NullPointerException
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-2678?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration commented on TEIID-2678:
------------------------------------------------
belong(a)redhat.com made a comment on [bug 1012634|https://bugzilla.redhat.com/show_bug.cgi?id=1012634]
Fixed before GA - setting to requires_doc_text- accordingly
> Query against OData source throwing java.lang.NullPointerException
> ------------------------------------------------------------------
>
> Key: TEIID-2678
> URL: https://issues.jboss.org/browse/TEIID-2678
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.4.1
> Reporter: Van Halbert
> Assignee: Ramesh Reddy
> Priority: Critical
> Labels: alpha1
> Fix For: 8.4.1, 8.6
>
>
> Queries against a deployed vdb (using odata translator) are throwing java.lang.NullPointerException. The vdb is connecting to NetWeaver Flight test site . Full log is attached along with vdb. Resource-adapter can be provided if needed. This failure has been verified by two different users.
> 12:47:16,401 ERROR [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue13) Connector worker process failed for atomic-request=t53q6HQwO5Rs.6.0.0: java.lang.NullPointerException
> at org.odata4j.format.xml.AtomFeedFormatParser.getEntitySet(AtomFeedFormatParser.java:304)
> at org.odata4j.format.xml.AtomFeedFormatParser.parse(AtomFeedFormatParser.java:156)
> at org.odata4j.format.xml.AtomFeedFormatParser.parse(AtomFeedFormatParser.java:44)
> at org.teiid.translator.odata.BaseQueryExecution.parse(BaseQueryExecution.java:93)
> at org.teiid.translator.odata.BaseQueryExecution.executeWithReturnEntity(BaseQueryExecution.java:124)
> at org.teiid.translator.odata.ODataQueryExecution.execute(ODataQueryExecution.java:108)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:254) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> It should also be noted that when previewing FlightCollection in Designer the following error was produced. Not sure if it is related to the server NullPointer situation.
> 2:46:00,788 INFO [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue12) TEIID31105 Returing warning to client: TEIID17013 Wrong response from source with status 404 code 005056A509B11EE1B9A8FEC11C21D78E and message Resource not found for the segment 'flightDetails_distanceUnit'.
--
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
10 years, 6 months
[JBoss JIRA] (TEIID-2672) java.lang.AssertionError: Assertion failed in SourceState
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-2672?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration commented on TEIID-2672:
------------------------------------------------
belong(a)redhat.com made a comment on [bug 1012540|https://bugzilla.redhat.com/show_bug.cgi?id=1012540]
Fixed before GA - setting to requires_doc_text- accordingly
> java.lang.AssertionError: Assertion failed in SourceState
> ---------------------------------------------------------
>
> Key: TEIID-2672
> URL: https://issues.jboss.org/browse/TEIID-2672
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.4.1, 8.5
> Environment: Teiid 8.5 and JBoss EAP6.1.0Alpha
> Reporter: Rakesh Balguri
> Assignee: Steven Hawkins
> Fix For: 8.4.1, 8.6
>
> Attachments: Join_SQL.txt
>
>
> 23 Sep 2013 19:56:24,950 IST ERROR [org.teiid.PROCESSOR] (http-/127.0.0.1:8080-2) 74NqnxAiy8n8 TEIID30019 Unexpected exception for request 74NqnxAiy8n8.32: java.lang.AssertionError: Assertion failed.
> at org.teiid.core.util.Assertion.failed(Assertion.java:73) [teiid-common-core-8.5.0.Final.jar:8.5.0.Final]
> at org.teiid.core.util.Assertion.assertTrue(Assertion.java:68) [teiid-common-core-8.5.0.Final.jar:8.5.0.Final]
> at org.teiid.core.util.Assertion.assertTrue(Assertion.java:60) [teiid-common-core-8.5.0.Final.jar:8.5.0.Final]
> at org.teiid.query.processor.relational.SourceState.prefetch(SourceState.java:197)
> at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:223)
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278)
> at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146)
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278)
> at org.teiid.query.processor.relational.UnionAllNode.nextBatchDirect(UnionAllNode.java:151)
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278)
> at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:69)
> at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70)
> at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:84)
> at org.teiid.common.buffer.AbstractTupleSource.nextTuple(AbstractTupleSource.java:48)
> at org.teiid.query.processor.relational.SortUtility.initialSort(SortUtility.java:257)
> at org.teiid.query.processor.relational.SortUtility.sort(SortUtility.java:190)
> at org.teiid.query.processor.relational.SortNode.sortPhase(SortNode.java:109)
> at org.teiid.query.processor.relational.SortNode.getFinalBuffer(SortNode.java:202)
> at org.teiid.query.processor.relational.RelationalPlan.getFinalBuffer(RelationalPlan.java:250)
> at org.teiid.query.processor.QueryProcessor.getFinalBuffer(QueryProcessor.java:290)
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:145)
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:435)
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:320)
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51)
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:248)
> at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:307)
> at sun.reflect.GeneratedMethodAccessor87.invoke(Unknown Source) [:1.7.0_03]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_03]
> at java.lang.reflect.Method.invoke(Method.java:601) [rt.jar:1.7.0_03]
> at org.teiid.logging.LogManager$LoggingProxy.invoke(LogManager.java:121) [teiid-api-8.5.0.Final.jar:8.5.0.Final]
> at org.teiid.jboss.TransportService$2.invoke(TransportService.java:234)
> at $Proxy19.executeRequest(Unknown Source) at sun.reflect.GeneratedMethodAccessor87.invoke(Unknown Source) [:1.7.0_03]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_03]
> at java.lang.reflect.Method.invoke(Method.java:601) [rt.jar:1.7.0_03]
> at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:137)
> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) [rt.jar:1.7.0_03]
> at java.util.concurrent.FutureTask.run(FutureTask.java:166) [rt.jar:1.7.0_03]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:253)
> at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:135)
> at $Proxy19.executeRequest(Unknown Source) at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:634) [teiid-client-8.5.0.Final.jar:8.5.0.Final]
> at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:509) [teiid-client-8.5.0.Final.jar:8.5.0.Final]
> at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:261) [teiid-client-8.5.0.Final.jar:8.5.0.Final]
> at com.ca.chorus.db.DbExecutor.withResultSet(DbExecutor.java:378) [common-db-4.0.0-SNAPSHOT.jar:]
> at com.ca.chorus.db.DbExecutor.gatherResults(DbExecutor.java:883) [common-db-4.0.0-SNAPSHOT.jar:]
> at com.ca.chorus.db.DbExecutor.gatherResults(DbExecutor.java:876) [common-db-4.0.0-SNAPSHOT.jar:]
> at com.ca.mfui.chorusR2.server.service.ObjectsServiceImpl.getAuthorizedModuleLibraries(ObjectsServiceImpl.java:4623) [chorus-service-4.0.0-SNAPSHOT.jar:]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_03]
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_03]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_03]
> at java.lang.reflect.Method.invoke(Method.java:601) [rt.jar:1.7.0_03]
> at com.ca.mfui.chorusR2.servlet.ChorusGWTServlet.processCall(ChorusGWTServlet.java:272) [chorus-service-4.0.0-SNAPSHOT.jar:]
> at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:248) [gwt-servlet-2.4.0.jar:]
> at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62) [gwt-servlet-2.4.0.jar:]
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:754) [jboss-servlet-api_3.0_spec-1.0.2.Final.jar:1.0.2.Final]
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.2.Final.jar:1.0.2.Final]
> at com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:263) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:178) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:91) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:62) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58) [guice-servlet-3.0.jar:]
> at com.ca.mfui.chorusR2.servlet.TransactionFilter$1.call(TransactionFilter.java:54) [chorus-service-4.0.0-SNAPSHOT.jar:]
> at com.ca.mfui.chorusR2.servlet.TransactionFilter$1.call(TransactionFilter.java:43) [chorus-service-4.0.0-SNAPSHOT.jar:]
> at com.ca.chorus.server.transaction.TransactionRunner.invoke(TransactionRunner.java:19) [transaction-4.0.0-SNAPSHOT.jar:]
> at com.ca.chorus.server.transaction.TransactionRunner$$EnhancerByGuice$$b1a07211.CGLIB$invoke$1(<generated>)
> at com.ca.chorus.server.transaction.TransactionRunner$$EnhancerByGuice$$b1a07211$$FastClassByGuice$$8b9821a3.invoke(<generated>)
> at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228) [guice-3.0.jar:]
> at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72) [guice-3.0.jar:]
> at com.ca.chorus.aop.guice.PerfTracer.trace(PerfTracer.java:75) [common-utils-4.0.0-SNAPSHOT.jar:]
> at com.ca.chorus.aop.guice.PerfTracer.trace(PerfTracer.java:92) [common-utils-4.0.0-SNAPSHOT.jar:]
> at com.ca.chorus.server.transaction.TransactionalMethodInterceptor.invoke(TransactionalMethodInterceptor.java:31) [transaction-4.0.0-SNAPSHOT.jar:]
> at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72) [guice-3.0.jar:]
> at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:52) [guice-3.0.jar:]
> at com.ca.chorus.server.transaction.TransactionRunner$$EnhancerByGuice$$b1a07211.invoke(<generated>)
> at com.ca.mfui.chorusR2.servlet.TransactionFilter.doFilter(TransactionFilter.java:42) [chorus-service-4.0.0-SNAPSHOT.jar:]
> at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:163) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:118) [guice-servlet-3.0.jar:]
> at com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:113) [guice-servlet-3.0.jar:]
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
> at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169) [jboss-as-web-7.2.0.Alpha1-redhat-4.jar:7.2.0.Alpha1-redhat-4]
> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:145) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:336) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
> at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
> at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:653) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
> at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:920) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
> at java.lang.Thread.run(Thread.java:722) [rt.jar:1.7.0_03]
--
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
10 years, 6 months
[JBoss JIRA] (TEIID-2188) When using CONCAT2(x, y), can the source query be changed to not include the CASE statements and let Oracle do the NULL compare
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-2188?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration commented on TEIID-2188:
------------------------------------------------
belong(a)redhat.com made a comment on [bug 855016|https://bugzilla.redhat.com/show_bug.cgi?id=855016]
Fixed before GA - setting to requires_doc_text- accordingly
> When using CONCAT2(x, y), can the source query be changed to not include the CASE statements and let Oracle do the NULL compare
> -------------------------------------------------------------------------------------------------------------------------------
>
> Key: TEIID-2188
> URL: https://issues.jboss.org/browse/TEIID-2188
> Project: Teiid
> Issue Type: Enhancement
> Components: Query Engine
> Affects Versions: 7.4.4
> Reporter: Van Halbert
> Assignee: Steven Hawkins
> Fix For: 8.2
>
>
> When CONCAT2(x, y) is used, the rewritten query is very verbose in adding a CASE statement to check for nulls. Can the rewritten query not include the CASE statements and just let Oracle do the compare, because it can do it more efficiently within the CONCAT call?
> Example:
> select concat2(f1,f2) from table1
> results in
> SELECT c_0 FROM (SELECT CASE WHEN to_char(g_0.f1) IS NULL AND g_0.f2 IS NULL THEN NULL ELSE concat(nvl(to_char(g_0.f1), ''), nvl(g_0.f2, '')) END AS c_0 FROM table1 g_0)
--
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
10 years, 6 months