Uploaded image for project: 'Pentaho Reporting and Pentaho Report Designer'
  1. Pentaho Reporting and Pentaho Report Designer
  2. PRD-6006

Regression: SQL queries with parameters broken in PRD

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: Urgent
    • Resolution: Fixed
    • Affects Version/s: 8.1.0 GA
    • Fix Version/s: 8.2.0 GA
    • Component/s: None
    • Labels:
    • Story Points:
      0
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.
    • Sprint Team:
      Tatooine (Maint)
    • Steps to Reproduce:
      Hide

      Create a query using Oracle's JDBC driver and use parameters in your query.

      Show
      Create a query using Oracle's JDBC driver and use parameters in your query.

      Description

      During the work on PDB-2004, there was a call added to the JDBC driver to get the class of query parameters on java.sql.PreparedStatement. Oracle's driver does not implement this method and throws an error, making it impossible to use Oracle's driver with query parameters.

      SEVERE: Mapped exception to response: 501
      javax.ws.rs.WebApplicationException: pt.webdetails.cda.dataaccess.QueryException: Unsupported feature
                        at pt.webdetails.cda.CdaUtils.doQuery(CdaUtils.java:187)
                        at pt.webdetails.cda.CdaUtils.doQueryPost(CdaUtils.java:135)
                        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
                        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
                        at java.lang.reflect.Method.invoke(Method.java:498)
                        at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)
                        at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$TypeOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:185)
                        at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)
                        at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302)
                        at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
                        at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108)
                        at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
                        at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)
                        at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1542)
                        at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1473)
                        at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1419)
                        at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1409)
                        at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:409)
                        at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:558)
                        at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:733)
                        at org.pentaho.platform.web.servlet.JAXRSPluginServlet.service(JAXRSPluginServlet.java:115)
                        at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
                        at org.pentaho.platform.web.servlet.JAXRSPluginServlet.service(JAXRSPluginServlet.java:120)
                        at pt.webdetails.cpf.JAXRSCLPluginServlet.service(JAXRSCLPluginServlet.java:37)
                        at org.pentaho.platform.web.servlet.PluginDispatchServlet.service(PluginDispatchServlet.java:92)
                        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
                        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
                        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
                        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
                        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
                        at org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:235)
                        at com.pentaho.platform.web.http.filters.PentahoEnterpriseWebContextFilter.doFilter(SourceFile:86)
                        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
                        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
                        at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:90)
                        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
                        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
                        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:317)
                        at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)
                        at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
                        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
                        at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:115)
                        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
                        at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)
                        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
                        at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
                        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
                        at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:194)
                        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
                        at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:158)
                        at org.pentaho.platform.web.http.security.PentahoBasicProcessingFilter.doFilterInternal(PentahoBasicProcessingFilter.java:128)
                        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
                        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
                        at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
                        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
                        at org.pentaho.platform.web.http.filters.HttpSessionPentahoSessionIntegrationFilter.doFilter(HttpSessionPentahoSessionIntegrationFilter.java:276)
                        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
                        at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:169)
                        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
                        at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214)
                        at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177)
                        at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
                        at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)
                        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
                        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
                        at com.pentaho.ui.servlet.SystemStatusFilter.doFilter(SourceFile:87)
                        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
                        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
                        at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:117)
                        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
                        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
                        at org.pentaho.platform.web.http.filters.WebappRootForwardingFilter.doFilter(WebappRootForwardingFilter.java:73)
                        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
                        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
                        at org.pentaho.platform.web.http.filters.PentahoPathDecodingFilter.doFilter(PentahoPathDecodingFilter.java:54)
                        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
                        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
                        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
                        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
                        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504)
                        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
                        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
                        at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:650)
                        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
                        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
                        at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803)
                        at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
                        at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:790)
                        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459)
                        at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
                        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
                        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
                        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
                        at java.lang.Thread.run(Thread.java:748)
      Caused by: pt.webdetails.cda.dataaccess.QueryException: Unsupported feature
                        at pt.webdetails.cda.dataaccess.PREDataAccess.performRawQuery(PREDataAccess.java:174)
                        at pt.webdetails.cda.dataaccess.SimpleDataAccess.queryDataSource(SimpleDataAccess.java:134)
                        at pt.webdetails.cda.dataaccess.AbstractDataAccess.doQuery(AbstractDataAccess.java:259)
                        at pt.webdetails.cda.CdaEngine.doQuery(CdaEngine.java:141)
                        at pt.webdetails.cda.CdaEngine.doExportQuery(CdaEngine.java:167)
                        at pt.webdetails.cda.CdaCoreService.doQuery(CdaCoreService.java:76)
                        at pt.webdetails.cda.CdaUtils.doQueryInternal(CdaUtils.java:140)
                        at pt.webdetails.cda.CdaUtils.doQuery(CdaUtils.java:173)
                        ... 94 more
      Caused by: java.sql.SQLException: Unsupported feature
                        at oracle.jdbc.driver.OracleParameterMetaData.getParameterClassName(OracleParameterMetaData.java:211)
                        at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.parametrize(SimpleSQLReportDataFactory.java:356)
                        at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.parametrizeAndQuery(SimpleSQLReportDataFactory.java:277)
                        at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:179)
                        at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SQLReportDataFactory.queryData(SQLReportDataFactory.java:142)
                        at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStaticInternal(CompoundDataFactory.java:172)
                        at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStatic(CompoundDataFactory.java:154)
                        at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:67)
                        at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryInternal(CachingDataFactory.java:411)
                        at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryData(CachingDataFactory.java:299)
                        at pt.webdetails.cda.dataaccess.PREDataAccess.performRawQuery(PREDataAccess.java:128)
                        ... 101 more
      

        Attachments

        1. _1_1.prpt.zip
          5 kB
        2. prd-6006_44.prpt
          5 kB
        3. prd-6006_90.prpt
          5 kB
        4. PRD-6006_exception.txt
          50 kB
        5. prd-6006.prpt
          4 kB
        6. Screenshot_20180525_205206.png
          Screenshot_20180525_205206.png
          145 kB
        7. Screenshot_20180525_210010.png
          Screenshot_20180525_210010.png
          99 kB
        8. Screenshot_20180601_124121.png
          Screenshot_20180601_124121.png
          166 kB
        9. Screenshot_20180601_124228.png
          Screenshot_20180601_124228.png
          120 kB
        10. Screenshot_20180601_124256.png
          Screenshot_20180601_124256.png
          62 kB
        11. Screenshot_20180601_124320.png
          Screenshot_20180601_124320.png
          120 kB
        12. Screenshot_20180601_124332.png
          Screenshot_20180601_124332.png
          110 kB
        13. Screen Shot 2018-05-24 at 1.49.06 PM.png
          Screen Shot 2018-05-24 at 1.49.06 PM.png
          217 kB
        14. Screen Shot 2018-05-24 at 1.50.58 PM.png
          Screen Shot 2018-05-24 at 1.50.58 PM.png
          433 kB
        15. Screen Shot 2018-05-24 at 2.02.12 PM.png
          Screen Shot 2018-05-24 at 2.02.12 PM.png
          253 kB

          Issue Links

            Activity

              People

              • Assignee:
                scosta Sandra Costa
                Reporter:
                lboudreau Luc Boudreau
              • Votes:
                3 Vote for this issue
                Watchers:
                22 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: