FineBI5.1.24能不能支持Postgresql14.2

按文档的提示下载驱动及上传后不能联接数据库, 是不是不能支持Postgresql14.2,只能到12,如果能支持要怎样操作呢?

https://help.fanruan.com/finebi/doc-view-290.html

https://help.fanruan.com/finebi/doc-view-1540.html?source=4

微信截图_20220729143021.png

错误提示为:

com.fr.third.alibaba.druid.pool.GetConnectionTimeoutException: wait millis 10001, active 0, maxActive 50, creating 0, createErrorCount 6 at com.fr.third.alibaba.druid.pool.DruidDataSource.getConnectionInternal(DruidDataSource.java:1833) at com.fr.third.alibaba.druid.pool.DruidDataSource.getConnectionDirect(DruidDataSource.java:1483) at com.fr.third.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1463) at com.fr.third.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1452) at com.fr.third.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:100) at com.fr.stable.pool.DataSourceAdapter.getConnection(DataSourceAdapter.java:60) at com.fr.stable.pool.DataSourceWrapper.getConnection(DataSourceWrapper.java:252) at com.fr.data.pool.MemoryConnection.create(MemoryConnection.java:190) at com.fr.data.auth.Authentication.authenticate(Authentication.java:57) at com.fr.data.impl.JDBCDatabaseConnection.createConnection(JDBCDatabaseConnection.java:257) at com.fr.data.impl.JDBCDatabaseConnection.testConnection(JDBCDatabaseConnection.java:239) at com.fr.decision.webservice.v10.datasource.connection.processor.impl.JDBCConnectionProcessor.testConnection(JDBCConnectionProcessor.java:217) at com.fr.decision.webservice.v10.datasource.connection.processor.impl.ConnectionProcessorFactory.testConnectionWithSchemaReturn(ConnectionProcessorFactory.java:61) at com.fr.decision.webservice.v10.datasource.connection.ConnectionService.testConnection(ConnectionService.java:74) 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.decision.config.ConfigInterceptor.intercept(ConfigInterceptor.java:34) at com.fr.decision.webservice.v10.datasource.connection.ConnectionService$$EnhancerByCGLIB$$a4fd73f2.testConnection(<generated>) at com.fr.web.controller.decision.api.config.ConnectionsResource.testConnectionData(ConnectionsResource.java:169) at com.fr.web.controller.decision.api.config.ConnectionsResource$$FastClassBySpringCGLIB$$ebdd6e1a.invoke(<generated>) at com.fr.third.net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:205) at com.fr.third.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:737) at com.fr.third.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) at com.fr.third.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92) at com.fr.third.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at com.fr.third.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:672) at com.fr.web.controller.decision.api.config.ConnectionsResource$$EnhancerBySpringCGLIB$$1b8a4773.testConnectionData(<generated>) 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.doPost(FrameworkServlet.java:872) at javax.servlet.http.HttpServlet.service(HttpServlet.java:707) 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.decision.xss.filter.XssFilter.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.plugin.decision.hw.security.filter.ConnectionTestFilter.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:748) Caused by: org.postgresql.util.PSQLException: 不支援 10 验证类型。请核对您已经组态 pg_hba.conf 文件包含客户端的IP位址或网路区段,以及驱动程序所支援的验证架构模式已被支援。 at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:614) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:222) at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49) at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:194) at org.postgresql.Driver.makeConnection(Driver.java:450) at org.postgresql.Driver.connect(Driver.java:252) at com.fr.third.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1666) at com.fr.third.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1732) at com.fr.third.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2903)

FineBI qzwsa 发布于 2022-7-29 14:30
1min目标场景问卷 立即参与
回答问题
悬赏:4 F币 + 添加悬赏
提示:增加悬赏、完善问题、追问等操作,可使您的问题被置顶,并向所有关注者发送通知
共2回答
最佳回答
0
好好生活好好学习Lv7资深互助
发布于2022-7-29 14:36

postgresql-42.4.0.7z

旧的备份一下,拿这个试试

最佳回答
0
用户6NWif5139660Lv6资深互助
发布于2022-7-29 14:32(编辑于 2022-7-29 14:32)

文档的驱动不支持 14.2  你去下载个支持14.2 的

  • qzwsa qzwsa(提问者) 在哪里有下载,麻烦给下驱动 网址,谢谢
    2022-07-29 14:36 
  • 3关注人数
  • 322浏览人数
  • 最后回答于:2022-7-29 14:36
    请选择关闭问题的原因
    确定 取消
    返回顶部