Received: from ns.crystaldonuts.com ([38.194.228.45]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id eAM367s40617 for ; Tue, 21 Nov 2000 22:06:07 -0500 (EST) (envelope-from tony@uickarate.com) Received: (qmail 5227 invoked from network); 22 Nov 2000 03:03:59 -0000 Received: from unknown (HELO uickarate.com) (64.148.169.10) by 38.194.228.45 with SMTP; 22 Nov 2000 03:03:59 -0000 Message-ID: <3A1B3733.E4A0868E@uickarate.com> Date: Tue, 21 Nov 2000 21:02:11 -0600 From: Tony Nakamura X-Mailer: Mozilla 4.73 [Kondara-ja] (X11; I; Linux 2.2.16-1k7 i686) X-Accept-Language: ja MIME-Version: 1.0 To: Greg Speegle CC: pgsql-interfaces Subject: Re: Tomcat & JDBC References: <3A1B11B4.1FA5AC73@uickarate.com> <3A1B16D4.76F6B49C@10happythings.com> Content-Type: text/plain; charset=iso-2022-jp Content-Transfer-Encoding: 7bit X-Archive-Number: 200011/231 X-Sequence-Number: 267 Wow!! You must be able to see my computer... It was exactly what's needed. I guess it was the typical newbie question?? In anycase, thanks a lot, Greg!! Tony Greg Speegle wrote: > 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