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