Message-ID: <3A1B16D4.76F6B49C@10happythings.com>
Date: Tue, 21 Nov 2000 18:44:04 -0600
From: Greg Speegle <Greg@10happythings.com>
MIME-Version: 1.0
To: Tony Nakamura <tony@uickarate.com>
CC: pgsql-interfaces <pgsql-interfaces@postgresql.org>
Subject: Re: Tomcat & JDBC
References: <Pine.BSF.4.21.0011161505570.11653-100000@kraeusen.nbrewer.com>
	<3A1B11B4.1FA5AC73@uickarate.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit


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