From: | Raivo Rebane <raivore55(at)gmail(dot)com> |
---|---|
To: | Craig McIlwee <craigm(at)vt(dot)edu> |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Right version of jdbc |
Date: | 2023-09-30 05:01:27 |
Message-ID: | CAMH5fpuJ4ceRF=6Fo9FXji=eD9zdEbnGU6Qiq2s7WTawyGMrBQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 <craigm(at)vt(dot)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
>
>>
From | Date | Subject | |
---|---|---|---|
Next Message | Raivo Rebane | 2023-09-30 05:18:02 | Re: Right version of jdbc |
Previous Message | Tom Lane | 2023-09-29 22:21:02 | Re: cache lookup failed for function 0 |