Hi, I copied the postgres driver to Tomcat/lib. PS C:\Program Files\Apache Software Foundation\Tomcat 9.0\lib> dir post* Directory: C:\Program Files\Apache Software Foundation\Tomcat 9.0\lib Mode LastWriteTime Length Name ---- ------------- ------ ---- -a---- 28.09.2023 14:40 1081604 postgresql-42.6.0.jar but Tomcat remains to give error - java.sql.SQLException: No suitable driver found for jdbc:postgresql://localhost:5432/mushroom_database I am using Postgres 15. May be I have to use more older one ?
Raivo On Sat, Sep 30, 2023 at 6:32 AM Craig McIlwee <cra...@vt.edu> wrote: > > for some reason the postgresql jar is not in the classpath. > > This is due to the way that Tomcat loads drivers, which is documented at > [1]. In short, the JDBC driver should be placed in the tomcat/lib > directory and removed from the application's WEB-INF/lib directory. After > doing that, I was able to get past the "No suitable driver" exception. > > OP, you should read that entire page, and in particular the portion at > [2]. By registering a "Resource" with Tomcat, you can let it manage a > connection pool for you (if you aren't already using something like > PgBouncer or pgpool) and, if registered at the container level, in the > future you can share that pool across all of your web applications in the > container. > > [1] > https://tomcat.apache.org/tomcat-9.0-doc/jndi-datasource-examples-howto.html#DriverManager,_the_service_provider_mechanism_and_memory_leaks > [2] > https://tomcat.apache.org/tomcat-9.0-doc/jndi-datasource-examples-howto.html#PostgreSQL > > Craig > >>