java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.sql.SQLException: An error occurred while processing request.

Pentaho BI Platform Tracking | Alena Karneichyk | 8 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    It's impossible to create analyzer report based on database tables data source using table from data services created from csv file *BTW* it happens only with *analyzer report* if you try to create an *interactive report* based on the same datsource the report is created *successfully* without any errors. *Expected Result*: analyzer report based on datasource with data services created from csv file is created successfully *without any errors* Here the full *error output*: {noformat} WITH SET [*NATIVE_CJ_SET_WITH_SLICER] AS 'FILTER([*BASE_MEMBERS__CONTACTFIRSTNAME_], NOT ISEMPTY ([Measures].[SALES]))' SET [*NATIVE_CJ_SET] AS '[*NATIVE_CJ_SET_WITH_SLICER]' SET [*SORTED_ROW_AXIS] AS 'ORDER([*CJ_ROW_AXIS],[CONTACTFIRSTNAME].CURRENTMEMBER.ORDERKEY,BASC)' SET [*BASE_MEMBERS__Measures_] AS '{[Measures].[SALES]}' SET [*CJ_ROW_AXIS] AS 'GENERATE([*NATIVE_CJ_SET], {([CONTACTFIRSTNAME].CURRENTMEMBER)})' SET [*BASE_MEMBERS__CONTACTFIRSTNAME_] AS '[CONTACTFIRSTNAME].[CONTACTFIRSTNAME].MEMBERS' SELECT [*BASE_MEMBERS__Measures_] ON COLUMNS ,[*SORTED_ROW_AXIS] ON ROWS FROM [last] 2016-08-16 10:45:21,834 ERROR [com.pentaho.analyzer.b.c] Ticket Number: 1471333521834 2016-08-16 10:45:21,834 ERROR [com.pentaho.analyzer.b.c] Exception in AJAX handler. java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.sql.SQLException: An error occurred while processing request. at com.pentaho.analyzer.report.ReportRequestService.get(SourceFile:219) at com.pentaho.analyzer.content.controller.n.a(SourceFile:168) at com.pentaho.analyzer.content.controller.b.b(SourceFile:202) at com.pentaho.analyzer.content.AnalyzerContentGenerator.a(SourceFile:311) at com.pentaho.analyzer.content.AnalyzerContentGenerator.createContent(SourceFile:157) at org.pentaho.platform.web.http.api.resources.GeneratorStreamingOutput.generateContent(GeneratorStreamingOutput.java:236) at org.pentaho.platform.web.http.api.resources.GeneratorStreamingOutput.write(GeneratorStreamingOutput.java:163) at org.pentaho.platform.web.http.api.resources.GeneratorStreamingOutputProvider.writeTo(GeneratorStreamingOutputProvider.java:54) at org.pentaho.platform.web.http.api.resources.GeneratorStreamingOutputProvider.writeTo(GeneratorStreamingOutputProvider.java:33) at com.sun.jersey.spi.container.ContainerResponse.write(ContainerResponse.java:302) at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1510) 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.JAXRSServlet.service(JAXRSServlet.java:109) at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) at org.pentaho.platform.web.servlet.JAXRSServlet.service(JAXRSServlet.java:114) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:185) at com.pentaho.platform.web.http.filters.PentahoEnterpriseWebContextFilter.doFilter(SourceFile:74) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:87) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:399) at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109) at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:191) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174) at org.pentaho.platform.web.http.security.PentahoBasicProcessingFilter.doFilterHttp(PentahoBasicProcessingFilter.java:115) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at org.pentaho.platform.web.http.filters.HttpSessionPentahoSessionIntegrationFilter.doFilter(HttpSessionPentahoSessionIntegrationFilter.java:263) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:188) at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at com.pentaho.ui.servlet.SystemStatusFilter.doFilter(SourceFile:87) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:114) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.pentaho.platform.web.http.filters.WebappRootForwardingFilter.doFilter(WebappRootForwardingFilter.java:70) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.pentaho.platform.web.http.filters.PentahoPathDecodingFilter.doFilter(PentahoPathDecodingFilter.java:34) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:522) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1095) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:672) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1502) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1458) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745) Caused by: java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.sql.SQLException: An error occurred while processing request. at java.util.concurrent.FutureTask.report(FutureTask.java:122) at java.util.concurrent.FutureTask.get(FutureTask.java:206) at com.pentaho.analyzer.report.ReportRequestService.get(SourceFile:175) ... 86 more Caused by: java.lang.RuntimeException: java.sql.SQLException: An error occurred while processing request. at com.pentaho.analyzer.report.ReportManagerImpl.runReport(SourceFile:322) at com.pentaho.analyzer.report.ReportManagerImpl.runReport(SourceFile:139) at com.pentaho.analyzer.report.ReportRequestService$2.a(SourceFile:275) at com.pentaho.analyzer.report.ReportRequestService$2.call(SourceFile:270) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) ... 1 more Caused by: java.sql.SQLException: An error occurred while processing request. at org.pentaho.di.trans.dataservice.jdbc.ThinResultSet.close(ThinResultSet.java:77) at org.apache.commons.dbcp.DelegatingResultSet.close(DelegatingResultSet.java:187) at org.apache.commons.dbcp.DelegatingResultSet.close(DelegatingResultSet.java:187) at mondrian.olap.Util.close(Util.java:2317) at mondrian.rolap.SqlStatement.close(SqlStatement.java:295) at mondrian.rolap.SqlTupleReader.prepareTuples(SqlTupleReader.java:553) at mondrian.rolap.SqlTupleReader.readMembers(SqlTupleReader.java:568) at mondrian.rolap.RolapNativeSet$SetEvaluator.executeList(RolapNativeSet.java:262) at mondrian.rolap.RolapNativeSet$SetEvaluator.execute(RolapNativeSet.java:195) at mondrian.olap.fun.FilterFunDef$BaseIterCalc.evaluateIterable(FilterFunDef.java:122) at mondrian.calc.impl.AbstractIterCalc.evaluate(AbstractIterCalc.java:50) at mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:1089) at mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:100) at mondrian.rolap.RolapNamedSetEvaluator.evaluateTupleIterable(RolapNamedSetEvaluator.java:66) at mondrian.mdx.NamedSetExpr$1.evaluateIterable(NamedSetExpr.java:98) at mondrian.calc.impl.AbstractIterCalc.evaluate(AbstractIterCalc.java:50) at mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:1089) at mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:100) at mondrian.rolap.RolapNamedSetEvaluator.evaluateTupleIterable(RolapNamedSetEvaluator.java:66) at mondrian.mdx.NamedSetExpr$1.evaluateIterable(NamedSetExpr.java:98) at mondrian.olap.fun.GenerateFunDef$GenerateListCalcImpl.evaluateList(GenerateFunDef.java:114) at mondrian.calc.impl.AbstractListCalc.evaluate(AbstractListCalc.java:65) at mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:1089) at mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:100) at mondrian.rolap.RolapNamedSetEvaluator.evaluateTupleIterable(RolapNamedSetEvaluator.java:66) at mondrian.mdx.NamedSetExpr$1.evaluateIterable(NamedSetExpr.java:98) at mondrian.olap.fun.OrderFunDef$CalcImpl.evaluateList(OrderFunDef.java:203) at mondrian.calc.impl.AbstractListCalc.evaluate(AbstractListCalc.java:65) at mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:1089) at mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:100) at mondrian.rolap.RolapNamedSetEvaluator.evaluateTupleIterable(RolapNamedSetEvaluator.java:66) at mondrian.mdx.NamedSetExpr$1.evaluateIterable(NamedSetExpr.java:98) at mondrian.rolap.RolapResult.executeAxis(RolapResult.java:977) at mondrian.rolap.RolapResult.evalLoad(RolapResult.java:801) at mondrian.rolap.RolapResult.loadMembers(RolapResult.java:757) at mondrian.rolap.RolapResult.<init>(RolapResult.java:401) at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:672) at mondrian.rolap.RolapConnection.access$000(RolapConnection.java:52) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:623) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:621) ... 4 more {noformat}

    Pentaho BI Platform Tracking | 8 months ago | Alena Karneichyk
    java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.sql.SQLException: An error occurred while processing request.
  2. 0

    *Actual result* Data used : Dados --> Integer Type Binary --> Binary Type When we add binary fields to the pivot table with another field type , we have a popup with the message "something went wrong" and in log we have this error : {code:xml} java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.sql.SQLException: An error occurred while processing request. at com.pentaho.analyzer.report.ReportRequestService.get(SourceFile:219) at com.pentaho.analyzer.content.controller.n.a(SourceFile:175) at com.pentaho.analyzer.content.controller.b.b(SourceFile:206) at com.pentaho.analyzer.content.AnalyzerContentGenerator.a(SourceFile:294) at com.pentaho.analyzer.content.AnalyzerContentGenerator.createContent(SourceFile:151) at org.pentaho.platform.web.http.api.resources.GeneratorStreamingOutput.generateContent(GeneratorStreamingOutput.java:237) at org.pentaho.platform.web.http.api.resources.GeneratorStreamingOutput.write(GeneratorStreamingOutput.java:162) at org.pentaho.platform.pdi.ContentGeneratorServlet.service(ContentGeneratorServlet.java:66) at javax.servlet.http.HttpServlet.service(HttpServlet.java:668) at Proxya29a4333_2037_4b4f_9e2e_4292dc498a1f.service(Unknown Source) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:684) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:503) at org.ops4j.pax.web.service.jetty.internal.HttpServiceServletHandler.doHandle(HttpServiceServletHandler.java:69) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:137) at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:557) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:231) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1086) at org.ops4j.pax.web.service.jetty.internal.HttpServiceContext.doHandle(HttpServiceContext.java:240) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:429) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:193) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1020) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135) at org.ops4j.pax.web.service.jetty.internal.JettyServerHandlerCollection.handle(JettyServerHandlerCollection.java:75) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116) at org.eclipse.jetty.server.Server.handle(Server.java:370) at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:494) at org.eclipse.jetty.server.AbstractHttpConnection.content(AbstractHttpConnection.java:982) at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.content(AbstractHttpConnection.java:1043) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:865) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235) at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:696) at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:53) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608) at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543) at java.lang.Thread.run(Unknown Source) Caused by: java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.sql.SQLException: An error occurred while processing request. at java.util.concurrent.FutureTask.report(Unknown Source) at java.util.concurrent.FutureTask.get(Unknown Source) at com.pentaho.analyzer.report.ReportRequestService.get(SourceFile:175) ... 35 more Caused by: java.lang.RuntimeException: java.sql.SQLException: An error occurred while processing request. at com.pentaho.analyzer.report.ReportManagerImpl.runReport(SourceFile:326) at com.pentaho.analyzer.report.ReportManagerImpl.runReport(SourceFile:145) at com.pentaho.analyzer.report.ReportRequestService$2.a(SourceFile:275) at com.pentaho.analyzer.report.ReportRequestService$2.call(SourceFile:270) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) ... 1 more Caused by: java.sql.SQLException: An error occurred while processing request. at org.pentaho.di.trans.dataservice.jdbc.ThinResultSet.close(ThinResultSet.java:76) at mondrian.olap.Util.close(Util.java:2317) at mondrian.rolap.SqlStatement.close(SqlStatement.java:292) at mondrian.spi.impl.SqlStatisticsProvider.getColumnCardinality(SqlStatisticsProvider.java:136) at mondrian.rolap.RolapStatisticsCache.getColumnCardinality(RolapStatisticsCache.java:171) at mondrian.rolap.RolapStatisticsCache.getColumnCardinality(RolapStatisticsCache.java:137) at mondrian.rolap.RolapStar$Column.getCardinality(RolapStar.java:1024) at mondrian.rolap.FastBatchingCellReader.preloadColumnCardinality(FastBatchingCellReader.java:461) at mondrian.rolap.FastBatchingCellReader.loadAggregations(FastBatchingCellReader.java:240) at mondrian.rolap.RolapResult.phase(RolapResult.java:603) at mondrian.rolap.RolapResult.executeBody(RolapResult.java:1027) at mondrian.rolap.RolapResult.<init>(RolapResult.java:504) at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:662) at mondrian.rolap.RolapConnection.access$000(RolapConnection.java:52) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:613) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:611) ... 4 more {code} *Error occurs too in 7.0 GA*

    Pentaho BI Platform Tracking | 3 months ago | Ronye Sarreira
    java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.sql.SQLException: An error occurred while processing request.
  3. 0

    java.sql.SQLException: No value specified for parameter 1解决办法_IT知识问答_希赛网

    educity.cn | 2 years ago
    java.sql.SQLException: No value specified for parameter 1 代码如下 public boolean login(UserInfo user)throws Exception{ //用户登录 boolean flag=false; int userNo=Integer.parseInt(user.getUserNo()); String password=user.getPassword(); //测试是否从现在的user对象中取到了值 System.out.println(userNo+"我是USER对象的userNo"); System.out.println(password+"我是USER对象的password"); DatabaseConnection dbc=new DatabaseConnection();//取得数据库连接和关闭对象; try{ String sql="SELECT userNo FROM userInfo where userNo= and password= "; this.conn=dbc.getConnection(); this.pst=conn.prepareStatement(sql); //this.pst.setInt(1, userNo);//给sql中参数赋值 this.pst.setLong(1, userNo); this.pst.setString(2, password); ResultSet rs=pst.executeQuery(); if(rs.next()){//传入用户账号和对应的密码都存在时为真 flag=true; System.out.println(rs.getString(userNo)+"我是从数据库里取出来的"); System.out.print(flag+"测试flag");//测试flag,看是否进入了if里面,true则进入了 rs.close(); } }catch(Exception e){ e.printStackTrace(); }finally{ if(this.pst!=null){ this.pst.close(); } this.conn.close(); } return flag; } 报的错误信息如:
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    java.sql.SQLException: No suitable driver - Toolbox for IT Groups

    ittoolbox.com | 9 months ago
    java.sql.SQLException: No suitable driver at java.sql.DriverManager.getConnection(DriverManager .java:545) at java.sql.DriverManager.getConnection(DriverManager .java:171) at com.stc.sql.framework.jdbc.DBConnectionFactory.cre ateConnection(DBConnectionFactory.java:372) at com.stc.sql.framework.jdbc.DBConnectionFactory.get Connection(DBConnectionFactory.java:281) at com.stc.etl.engine.impl.SimpleTask.getConnection(S impleTask.java:254) at com.stc.etl.engine.impl.Extractor.getSelectData(Ex tractor.java:376) at com.stc.etl.engine.impl.Extractor.process(Extracto r.java:190) at com.stc.etl.engine.impl.ETLTaskThread.run(ETLTaskT hread.java:147)
  6. 0

    1 more error - Java Programming Help - KnowCoding.com

    knowcoding.com | 2 years ago
    java.sql.SQLException: Protocol violation at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java:134) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java:179) at oracle.jdbc.dbaccess.DBError.check_error(DBError.j ava:1160) at oracle.jdbc.ttc7.Ocommoncall.receive(Ocommoncall.j ava:149) at oracle.jdbc.ttc7.TTC7Protocol.rollback(TTC7Protoco l.java:488) at oracle.jdbc.driver.OracleConnection.rollback(Oracl eConnection.java:1412) at net.sf.hibernate.transaction.JDBCTransaction.rollb ack(JDBCTransaction.java:86) at com.azure.spark.database.hibernate.util.HibernateU til.doSessionWork(HibernateUtil.java:90) at com.azure.spark.database.hibernate.util.HibernateU til.doSessionWork(HibernateUtil.java:59) at com.azure.spark.database.hibernate.util.HibernateU til.get(HibernateUtil.java:569) at com.azure.spark.database.hibernate.util.HibernateS ession.get(HibernateSession.java:340) at com.azure.spark.taskcontroller.TaskControllerCompo nent.taskCompleted(TaskControllerComponent.java:11 54) at com.azure.spark.taskcontroller.TaskControllerCompo nent.onTaskEvent(TaskControllerComponent.java:1111 ) at com.azure.spark.taskcontroller.tasks.AbstractTaskC omponent.run(AbstractTaskComponent.java:354)

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      An error occurred while processing request.

      at org.pentaho.di.trans.dataservice.jdbc.ThinResultSet.close()
    2. org.pentaho.di
      ThinResultSet.close
      1. org.pentaho.di.trans.dataservice.jdbc.ThinResultSet.close(ThinResultSet.java:77)
      1 frame
    3. Commons DBCP
      DelegatingResultSet.close
      1. org.apache.commons.dbcp.DelegatingResultSet.close(DelegatingResultSet.java:187)
      2. org.apache.commons.dbcp.DelegatingResultSet.close(DelegatingResultSet.java:187)
      2 frames
    4. mondrian.olap
      Util.close
      1. mondrian.olap.Util.close(Util.java:2317)
      1 frame
    5. mondrian.rolap
      RolapNativeSet$SetEvaluator.execute
      1. mondrian.rolap.SqlStatement.close(SqlStatement.java:295)
      2. mondrian.rolap.SqlTupleReader.prepareTuples(SqlTupleReader.java:553)
      3. mondrian.rolap.SqlTupleReader.readMembers(SqlTupleReader.java:568)
      4. mondrian.rolap.RolapNativeSet$SetEvaluator.executeList(RolapNativeSet.java:262)
      5. mondrian.rolap.RolapNativeSet$SetEvaluator.execute(RolapNativeSet.java:195)
      5 frames
    6. mondrian.olap.fun
      FilterFunDef$BaseIterCalc.evaluateIterable
      1. mondrian.olap.fun.FilterFunDef$BaseIterCalc.evaluateIterable(FilterFunDef.java:122)
      1 frame
    7. mondrian.calc.impl
      AbstractIterCalc.evaluate
      1. mondrian.calc.impl.AbstractIterCalc.evaluate(AbstractIterCalc.java:50)
      1 frame
    8. mondrian.rolap
      RolapNamedSetEvaluator.evaluateTupleIterable
      1. mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:1089)
      2. mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:100)
      3. mondrian.rolap.RolapNamedSetEvaluator.evaluateTupleIterable(RolapNamedSetEvaluator.java:66)
      3 frames
    9. mondrian.mdx
      NamedSetExpr$1.evaluateIterable
      1. mondrian.mdx.NamedSetExpr$1.evaluateIterable(NamedSetExpr.java:98)
      1 frame
    10. mondrian.calc.impl
      AbstractIterCalc.evaluate
      1. mondrian.calc.impl.AbstractIterCalc.evaluate(AbstractIterCalc.java:50)
      1 frame
    11. mondrian.rolap
      RolapNamedSetEvaluator.evaluateTupleIterable
      1. mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:1089)
      2. mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:100)
      3. mondrian.rolap.RolapNamedSetEvaluator.evaluateTupleIterable(RolapNamedSetEvaluator.java:66)
      3 frames
    12. mondrian.mdx
      NamedSetExpr$1.evaluateIterable
      1. mondrian.mdx.NamedSetExpr$1.evaluateIterable(NamedSetExpr.java:98)
      1 frame
    13. mondrian.olap.fun
      GenerateFunDef$GenerateListCalcImpl.evaluateList
      1. mondrian.olap.fun.GenerateFunDef$GenerateListCalcImpl.evaluateList(GenerateFunDef.java:114)
      1 frame
    14. mondrian.calc.impl
      AbstractListCalc.evaluate
      1. mondrian.calc.impl.AbstractListCalc.evaluate(AbstractListCalc.java:65)
      1 frame
    15. mondrian.rolap
      RolapNamedSetEvaluator.evaluateTupleIterable
      1. mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:1089)
      2. mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:100)
      3. mondrian.rolap.RolapNamedSetEvaluator.evaluateTupleIterable(RolapNamedSetEvaluator.java:66)
      3 frames
    16. mondrian.mdx
      NamedSetExpr$1.evaluateIterable
      1. mondrian.mdx.NamedSetExpr$1.evaluateIterable(NamedSetExpr.java:98)
      1 frame
    17. mondrian.olap.fun
      OrderFunDef$CalcImpl.evaluateList
      1. mondrian.olap.fun.OrderFunDef$CalcImpl.evaluateList(OrderFunDef.java:203)
      1 frame
    18. mondrian.calc.impl
      AbstractListCalc.evaluate
      1. mondrian.calc.impl.AbstractListCalc.evaluate(AbstractListCalc.java:65)
      1 frame
    19. mondrian.rolap
      RolapNamedSetEvaluator.evaluateTupleIterable
      1. mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:1089)
      2. mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:100)
      3. mondrian.rolap.RolapNamedSetEvaluator.evaluateTupleIterable(RolapNamedSetEvaluator.java:66)
      3 frames
    20. mondrian.mdx
      NamedSetExpr$1.evaluateIterable
      1. mondrian.mdx.NamedSetExpr$1.evaluateIterable(NamedSetExpr.java:98)
      1 frame
    21. mondrian.rolap
      RolapConnection$1.call
      1. mondrian.rolap.RolapResult.executeAxis(RolapResult.java:977)
      2. mondrian.rolap.RolapResult.evalLoad(RolapResult.java:801)
      3. mondrian.rolap.RolapResult.loadMembers(RolapResult.java:757)
      4. mondrian.rolap.RolapResult.<init>(RolapResult.java:401)
      5. mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:672)
      6. mondrian.rolap.RolapConnection.access$000(RolapConnection.java:52)
      7. mondrian.rolap.RolapConnection$1.call(RolapConnection.java:623)
      8. mondrian.rolap.RolapConnection$1.call(RolapConnection.java:621)
      8 frames
    22. Java RT
      Thread.run
      1. java.util.concurrent.FutureTask.run(FutureTask.java:266)
      2. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
      3. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
      4. java.lang.Thread.run(Thread.java:745)
      4 frames