java.lang.AbstractMethodError : org. postgresql.jdbc3.Jdbc3Connection.isValid(I)Z

Question

我试图从 eclipse 部署一个 java web 应用程序，在 tomcat 9.0.4 服务器、jdk 1.8 和 Postgresql 42.2.7 JDBC 连接器上，当执行程序出现以下异常时:

    FachadaSesion fachadaSesion = (FachadaSesion) application.getAttribute("fachadaSesion");     
    //System.out.print("\n\n Salida ::> " + Format.formatCalendar (Calendar.getInstance (), 2));

    MiUsuarioVO miUsuarioVO = (MiUsuarioVO)fachada.validarUsuario((String)request.getParameter("usuario"));
    session.setAttribute("usuarioInicioSession", (String)request.getParameter("usuario"));
    String pagina="";
    String idUsuario="0";
    String estadoScroll = "no";


org.apache.jasper.JasperException: Ha sucedido una excepción al procesar la página JSP [val_user.jsp] en línea [63]

60:         FachadaSesion fachadaSesion = (FachadaSesion) application.getAttribute("fachadaSesion");     
61:         //System.out.print("\n\n Salida ::> " + Format.formatCalendar (Calendar.getInstance (), 2));
62:                 
63:         MiUsuarioVO miUsuarioVO = (MiUsuarioVO)fachada.validarUsuario((String)request.getParameter("usuario"));
64:         session.setAttribute("usuarioInicioSession", (String)request.getParameter("usuario"));
65:         String pagina="";
66:         String idUsuario="0";


Stacktrace:
    at org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:593)
    at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:467)
    at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:386)
    at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:330)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
    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:53)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    at vortalHermesoft.filtro.FiltroSeguridad.doFilter(FiltroSeguridad.java:131)
    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:502)
    at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:651)
    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:651)
    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:417)
    at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
    at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:754)
    at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1376)
    at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
    at java.lang.Thread.run(Unknown Source)
Caused by: javax.servlet.ServletException: java.lang.AbstractMethodError: org.postgresql.jdbc3.Jdbc3Connection.isValid(I)Z
    at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:667)
    at org.apache.jsp.val_005fuser_jsp._jspService(val_005fuser_jsp.java:338)
    at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
    at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:444)
    ... 29 more
Caused by: java.lang.AbstractMethodError: org.postgresql.jdbc3.Jdbc3Connection.isValid(I)Z
    at org.apache.tomcat.dbcp.dbcp2.DelegatingConnection.isValid(DelegatingConnection.java:924)
    at org.apache.tomcat.dbcp.dbcp2.PoolableConnection.validate(PoolableConnection.java:282)
    at org.apache.tomcat.dbcp.dbcp2.PoolableConnectionFactory.validateConnection(PoolableConnectionFactory.java:364)
    at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2355)
    at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2338)
    at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2067)
    at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1543)
    at co.edu.unipamplona.plataforma.connection.DefinitionConnectionVortal.<init>(DefinitionConnectionVortal.java:39)
    at miVortalHermesoft.bdatos.MiUsuarioDAO.<init>(MiUsuarioDAO.java:28)
    at miVortalHermesoft.fachada.FachadaMiVortal.validarUsuario(FachadaMiVortal.java:36)
    at org.apache.jsp.val_005fuser_jsp._jspService(val_005fuser_jsp.java:208)
    ... 32 more

friend 已经在网上查了一下，说是Postgresql的版本太旧了，但是我已经下载了最新版本，它对我来说也不起作用，我不明白为什么我还是得到同样的结果异常(exception)，难道有人可以帮我一个忙吗？

Answer 1

PostgreSQL 42.2.7 JDBC 驱动程序库不包含类 org.postgresql.jdbc3.Jdbc3Connection。这意味着 Tomcat 的类路径中有一些相当旧的 JDBC 驱动程序。检查您的应用程序中打包了哪些 JDBC 驱动程序。还要检查 Tomcat 目录中是否有任何 JDBC 库，包括 lib 等子目录。