chat2db连接postgresql报错：Caused by: java.lang.AbstractMethodError: Receiver class org.postgresql.jdbc3.

wo1769815

于 2024-10-30 14:18:50 发布

阅读量694

点赞数 25

CC 4.0 BY-SA版权

文章标签： postgresql java 数据库

本文链接：https://blog.youkuaiyun.com/wo1769815/article/details/143363997

删除.chat2db\jdbc-lib目录下全部驱动，然后重新导入postgresql-42.5.1.jar后可以正常使用，原来导入的版本存在老版本的驱动包。

详细报错信息如下：

{"getApplicationMessage":{"env":"desktop","versions":"3.4.0","buildTime":1730200459985,"userAgent":"Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) chat2db/3.4.0 Chrome/108.0.5359.215 Electron/22.3.27 Safari/537.36"},"requestUrl":"http://127.0.0.1:10824/api/rdb/schema/list","requestParams":"{\"dataSourceId\":2,\"dataSourceName\":\"10.213.47.59\",\"databaseType\":\"POSTGRESQL\",\"databaseName\":\"sd4adb\",\"refresh\":false,\"pageNo\":1}","errorCode":"common.systemError","errorMessage":"An exception occurs, you can view the exception details in the log in the help menu.","errorDetail":"jakarta.servlet.ServletException: Handler dispatch failed: java.lang.AbstractMethodError: Receiver class org.postgresql.jdbc3.Jdbc3DatabaseMetaData does not define or inherit an implementation of the resolved method 'abstract java.sql.ResultSet getSchemas(java.lang.String, java.lang.String)' of interface java.sql.DatabaseMetaData.
   at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1096)
   at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:974)
   at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1011)
   at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:903)
   at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:564)
   at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:885)
   at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:658)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:205)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:149)
   at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:174)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:149)
   at ai.chat2db.server.start.config.interceptor.CorsFilter.doFilter(CorsFilter.java:37)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:174)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:149)
   at org.zalando.logbook.servlet.LogbookFilter.doFilter(LogbookFilter.java:76)
   at org.zalando.logbook.servlet.HttpFilter.doFilter(HttpFilter.java:32)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:174)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:149)
   at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
   at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:174)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:149)
   at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
   at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:174)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:149)
   at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
   at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:174)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:149)
   at ai.chat2db.server.start.log.LogOncePerRequestFilter.doFilterInternal(LogOncePerRequestFilter.java:32)
   at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:174)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:149)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:166)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
   at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:115)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:341)
   at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:390)
   at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
   at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:894)
   at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1741)
   at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
   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.base/java.lang.Thread.run(Unknown Source)
Caused by: java.lang.AbstractMethodError: Receiver class org.postgresql.jdbc3.Jdbc3DatabaseMetaData does not define or inherit an implementation of the resolved method 'abstract java.sql.ResultSet getSchemas(java.lang.String, java.lang.String)' of interface java.sql.DatabaseMetaData.
   at ai.chat2db.spi.sql.SQLExecutor.schemas(SQLExecutor.java:321)
   at ai.chat2db.spi.jdbc.DefaultMetaService.schemas(DefaultMetaService.java:29)
   at ai.chat2db.server.domain.core.impl.DatabaseServiceImpl.getSchemaList(DatabaseServiceImpl.java:74)
   at ai.chat2db.server.domain.core.impl.DatabaseServiceImpl.lambda$querySchema$3(DatabaseServiceImpl.java:66)
   at ai.chat2db.server.domain.core.cache.CacheManage.getList(CacheManage.java:79)
   at ai.chat2db.server.domain.core.impl.DatabaseServiceImpl.querySchema(DatabaseServiceImpl.java:61)
   at ai.chat2db.server.web.api.controller.rdb.SchemaController.list(SchemaController.java:59)
   at jdk.internal.reflect.GeneratedMethodAccessor40.invoke(Unknown Source)
   at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
   at java.base/java.lang.reflect.Method.invoke(Unknown Source)
   at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
   at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
   at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:89)
   at ai.chat2db.server.web.api.aspect.ConnectionInfoHandler.connectionInfoHandler(ConnectionInfoHandler.java:62)
   at jdk.internal.reflect.GeneratedMethodAccessor23.invoke(Unknown Source)
   at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
   at java.base/java.lang.reflect.Method.invoke(Unknown Source)
   at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:637)
   at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:627)
   at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:71)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
   at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
   at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
   at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
   at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:702)
   at ai.chat2db.server.web.api.controller.rdb.SchemaController$$SpringCGLIB$$0.list(<generated>)
   at jdk.internal.reflect.GeneratedMethodAccessor40.invoke(Unknown Source)
   at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
   at java.base/java.lang.reflect.Method.invoke(Unknown Source)
   at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:207)
   at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:152)
   at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:118)
   at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:884)
   at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:797)
   at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
   at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1081)
   ... 50 more
","solutionLink":"https://github.com/chat2db/Chat2DB/wiki/Chat2DB"}