之前，MySQL使用的是5.7版本，驱动使用FineBI默认提供的mysql-connector-java-5.1.49-bin.jar，该阶段，连MySQL与MyCat（1.6.7）均没有问题，MyCat展示的是逻辑主表，可以正常操作、执行报表统计。 现在，MySQL升级到8.0.33版本，FineBI使用默认驱动无法正常连接MySQL了，因此手动替换了webapps\webroot\WEB-INF\lib路径下的驱动为mysql-connector-java-8.0.29.jar，此时FineBI可以正常访问8.0的MySQL，但无法连接MyCat了，创建的连接直接报错。 又尝试了8.0.13、8.0.29版本的jar驱动，均无法连接MyCat。 因为FineBI 5.1.16版本尚不支持驱动的自定义，同一类型数据库只能使用一个驱动，有什么办法可以解决无法连接MyCat的问题？ 报错信息如下： 2023/08/24 19:11:50 http-nio-37799-exec-6 ERROR connection us_mycat get tables and views fail:java.sql.SQLSyntaxErrorException: com.alibaba.druid.sql.ast.expr.SQLInListExpr cannot be cast to com.alibaba.druid.sql.ast.expr.SQLBinaryOpExprjava.lang.RuntimeException: java.sql.SQLSyntaxErrorException: com.alibaba.druid.sql.ast.expr.SQLInListExpr cannot be cast to com.alibaba.druid.sql.ast.expr.SQLBinaryOpExprat com.fr.data.operator.DataOperator.doWithConnection(DataOperator.java) ~at com.fr.data.operator.DataOperator.getTableProcedure(DataOperator.java) ~at com.fr.data.core.DataCoreUtils.getTables(DataCoreUtils.java) ~at com.finebi.common.impl.provider.DefaultDatabaseConnectionProvider.getConnectionTableProcedures(DefaultDatabaseConnectionProvider.java:79) ~at com.finebi.burger.impl.service.FineConnectionServiceImpl.getTablesByConnectionName(FineConnectionServiceImpl.java:81) ~at com.finebi.spider.web.action.v5.conf.FineConnectionAction.getTablesByConnName(FineConnectionAction.java:40) ~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.fr.third.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205) ~at com.fr.third.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133) ~at com.fr.third.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97) ~at com.fr.third.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:854) ~at com.fr.third.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:765) ~at com.fr.third.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85) ~at com.fr.third.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967) ~at com.fr.third.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901) ~at com.fr.third.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970) ~at com.fr.third.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861) ~at javax.servlet.http.HttpServlet.service(HttpServlet.java:687) ~at com.fr.third.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846) ~at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) ~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 com.fr.decision.webservice.BackupActivator$1.doFilter(BackupActivator.java:77) ~at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~at com.fr.decision.webservice.filter.TenantFilter.doFilter(TenantFilter.java:55) ~at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~at com.fr.decision.base.DecisionServletInitializer$6.doFilterInternal(DecisionServletInitializer.java:259) ~at com.fr.third.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) ~at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~at com.fr.decision.base.VirtualFilterChain.doFilter(VirtualFilterChain.java:34) ~at com.fr.decision.base.DecisionServletInitializer$4.doFilter(DecisionServletInitializer.java:191) ~at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~at com.fr.decision.webservice.filter.CookieCheckFilter.doFilterInternal(CookieCheckFilter.java:37) ~at com.fr.third.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) ~at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~at com.fr.plugin.system.operation.ops.filter.OpsIgnoreFilter.doFilter(Unknown Source) ~at com.fr.decision.base.DecisionServletInitializer$5.doFilter(DecisionServletInitializer.java:220) ~at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~at com.fr.third.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197) ~at com.fr.third.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) ~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:197) ~at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) ~at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:543) ~at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) ~at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) ~at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) ~at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:367) ~at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:639) ~at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) ~at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:882) ~at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1647) ~at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) ~at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) ~at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) ~at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) ~at java.lang.Thread.run(Thread.java:750) ~Caused by: java.sql.SQLSyntaxErrorException: com.alibaba.druid.sql.ast.expr.SQLInListExpr cannot be cast to com.alibaba.druid.sql.ast.expr.SQLBinaryOpExprat com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) ~at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916) ~at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:972) ~at com.mysql.cj.jdbc.DatabaseMetaDataUsingInfoSchema.executeMetadataQuery(DatabaseMetaDataUsingInfoSchema.java:71) ~at com.mysql.cj.jdbc.DatabaseMetaDataUsingInfoSchema.getTables(DatabaseMetaDataUsingInfoSchema.java:872) ~at com.fr.data.core.db.dialect.base.key.table.procedure.DialectFetchTableProcedureKey.execute(DialectFetchTableProcedureKey.java:48) ~at com.fr.data.core.db.dialect.base.key.table.procedure.DialectFetchTableProcedureKey.execute(DialectFetchTableProcedureKey.java:19) ~at com.fr.data.core.db.dialect.AbstractDialect.execute(AbstractDialect.java) ~at com.fr.data.core.db.dialect.DefaultDialect.getTableProcedure(DefaultDialect.java:197) ~at com.fr.data.operator.DataOperator$5.apply(DataOperator.java) ~at com.fr.data.operator.DataOperator$5.apply(DataOperator.java) ~... 70 more
