Re: Right version of jdbc - Mailing list pgsql-general

From Craig McIlwee
Subject Re: Right version of jdbc
Date
Msg-id CAGqBcTYn7vpx2T+-AM_kS7fszGZfZMULLZw6DqXe=Dq6TnCkNQ@mail.gmail.com
Whole thread Raw
In response to Re: Right version of jdbc  (Dave Cramer <davecramer@postgres.rocks>)
Responses Re: Right version of jdbc
List pgsql-general
> 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.


Craig

pgsql-general by date:

Previous
From: postgresql439848@heinz-it.de
Date:
Subject: Re: Right version of jdbc
Next
From: pf@pfortin.com
Date:
Subject: cache lookup failed for function 0