Re: Tomcat & JDBC

I was able to get tomcat to work with postgres by putting the jar file
in /usr/local/tomcat/lib, which is the default place for tomcat to look
for libraries in my installation.

Also, are you using the right jar file? I know you can name it whatever
you want, but the download name I have is jdbc7_0-1_2.jar, while the
old jar file was called postgresql.jar.

Good luck,
Greg Speegle

Tony Nakamura wrote:

> Thanks everyone for the help on JDBC.  I finally got JDBC to work.
> ....of course, I am facing an another one.  So please help me if you could.
> Thanks in advance.
>
> My DB connection works perfectly when I am writing an application, but
> it gives the ClassNotFoundException error when I write a servlet.  I am
> pretty
> sure it's the setting for tomcat that  I am using.  I have set following in
> the tomcat.properties
> file:
>
> wrapper.bin.parameters=-Djdbc.drivers=org.postgresql.Driver
> wrapper.classpath=/usr/local/lib/postgresql.jar
>
> I am also setting the CLASSPATH environmental variable, so
> I've tried wrapper.bin.parameter=NONE and didn't work.
>
> Tony