Re: loading jdbc Driver in servlet - Mailing list pgsql-general

From Rob Sargent
Subject Re: loading jdbc Driver in servlet
Date
Msg-id 3B618955-9F54-41AC-967A-A7A77A7C8085@gmail.com
Whole thread Raw
In response to Re: loading jdbc Driver in servlet  (Dave Cramer <pg@fastcrypt.com>)
Responses Re: loading jdbc Driver in servlet
List pgsql-general
Tomcat version 9. Embedded in my main()

On Dec 16, 2018, at 9:30 AM, Dave Cramer <pg@fastcrypt.com> wrote:

My guess is it has something to do with your servlet classpath loader. Which servlet engine are you using ?


On Fri, 14 Dec 2018 at 16:04, Rob Sargent <robjsargent@gmail.com> wrote:


On Dec 14, 2018, at 2:02 PM, Rob Sargent <robjsargent@gmail.com> wrote:



On Dec 14, 2018, at 1:30 PM, Dave Cramer <pg@fastcrypt.com> wrote:

Strange, I wouldn't think so, but then I haven't used a raw servlet for so long I have no idea.


On Fri, 14 Dec 2018 at 13:29, Rob Sargent <robjsargent@gmail.com> wrote:

Using java 1.8, postgresql-42.1.4.jar, embedded tomcat 9

It appears to me that I need to make the call "Class.forName("org.postgresql.Driver)" when the entry is in a servlet.  Is this expected, within a servlet, or is this just post hoc ergo propter hoc at it finest and I changed something else (wittingly or not).  Same code outside of servlet does not need the forced loading of the class and the manual claims it's not need after java 1.6

I too am suspicious.  But the vagaries of javax are daunting.
But if I comment it out, as just now, “No suitable driver found...”.  I was days playing with configuration and such think that this very specific error message was telling me my CLASSPATH was wrong.

I wonder if I have an old javax installation (which I put in place just recently).


I’m using javax.servlet-api-3.1.0.jar



pgsql-general by date:

Previous
From: Dave Cramer
Date:
Subject: Re: loading jdbc Driver in servlet
Next
From: Dave Cramer
Date:
Subject: Re: loading jdbc Driver in servlet