Re: problem with the Tomcat

If you want to use the driver universally the best place to put is
$JAVA_HOME/jre/lib/ext where $JAVA_HOME is where you have installed Java.

Alternatively put /usr/java/local/lib/pg73jdbc2.jar in your CLASSPATH,
something like

CLASSPATH=$CLASSPATH:/usr/java/local/lib/pg73jdbc2.jar

Lastly you can tell tomcat to load your driver by adding it to TOMCAT_OPTS,
like
TOMCAT_OPTS=$TOMCAT_OPTS:/usr/java/local/lib/pg73jdbc2.jar
I am not very sure about the last option.

> -----Original Message-----
> From: Tiago Leonardo Broilo [SMTP:broilo(at)em(dot)pucrs(dot)br]
> Sent: 04 February 2003 17:14
> To: J M Okomba
> Cc: pgsql-jdbc(at)postgresql(dot)org
> Subject: Re: [JDBC] problem with the Tomcat
>
> But at the moment to install the Tomcat it already creates all the
> directories and places in this in case that jdbc2_0-stdext.jar in the
> directory/opt/jakarta-tomcat-4.1.18/common/lib and this driver to
> pg73jdbc2.jar (located in/usr/java/local/lib) is special for the use of
> data base with the Postgresql, that is used for any interface of local
> user (local computer) and in this case the data base is functioning 100%.
>
> J M Okomba wrote:
>
>
> The best place to place the driver is common/lib directory of tomcat
> or
> WEB-INF/lib directory of your web application.
>
>
> -----Original Message-----
> From: Tiago Leonardo Broilo [ SMTP:broilo(at)em(dot)pucrs(dot)br
> <mailto:SMTP:broilo(at)em(dot)pucrs(dot)br>]
> Sent: 04 February 2003 15:52
> To: pgsql-jdbc(at)postgresql(dot)org
> <mailto:pgsql-jdbc(at)postgresql(dot)org>
> Subject: [JDBC] problem with the Tomcat
>
> I have PostgreSQL 7.3,jdbc driver pg73jdbc2.jar
> (located in /usr/java/local/lib), J2SE 1.4.1 and
> jakarta-tomcat-4.1.18.
> I'm using from a project.
> I have a problem with the Tomcat, therefore any
> application in servlet and jsp that I make it does not
> find driver of the database and the one exception
> that it appears is only this:
> "Exception! java.lang.ClassNotFoundException: to
> org.postgresql.Driver at
> to org.apache.catalina.loader "
> or Class.forName() throws ClassNotFoundException so you will
> need you
> catch and handle it.
> Although to have made right everything that is
> necessary in the Tomcat
> when to the use of database.
> Since already I thank the aid of all.
>
>
>
>
>
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> <http://www.postgresql.org/users-lounge/docs/faq.html>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to
> majordomo(at)postgresql(dot)org <mailto:majordomo(at)postgresql(dot)org>
>
>
>
> --
> --------------------------------------------------------------
> A/C Tiago Leonardo Broilo
> E-mail: broilo(at)em(dot)pucrs(dot)br <mailto:broilo(at)em(dot)pucrs(dot)br>
> Pontifical Catholic University of Rio Grande do Sul - PUCRS
> Dept. of Mechanical and Mechatronics Engineering - DEM
> Av. Ipiranga, 6681 - Prédio 30
> Prédio 30/Bloco 7
> CEP 90619-900 Porto Alegre/RS
> Brazil
> Fone (51)3320-3500 ramal 4393
> <http://www.em.pucrs.br/~labcim>
> ----------------------------------------------------------------
>
>