Обсуждение: How to Install PostgerSQL_Driver ( in tomcat ) ?

Dear All

I'm using :

Microsoft Windows Xp
Apache-tomcat-6.0.14
Java version  1.5.0_14
+
PostgreSQL 8.2
and
postgresql-8.2-507.jdbc3.jar

every time I wana run myApp.class I should type :
java -cp postgresql-8.2-507.jdbc3.jar . myApp

there is no problem . but when I import myApp into myJSP.jsp , tomcat brings this Error :

javax.servlet.ServletException: java.lang.NoClassDefFoundError

-----------------------

I Tried to  :
1. add a classpath=add/postgresql-8.2-507.jdbc3.jar; to env-variables
2. add the jar file to jre/lib/ext
3. add the jar file to myWebApp/WEB-INF/lib
4. add the jar file to tomcat/lib

but non of them works !

would you please help me(I'm a java beginner!)

Thanks alot
Moein
------

---

Yahoo! Answers - Get better answers from someone who knows. Try it now.

Moien <moin_e 'at' yahoo.com> writes:

> I Tried to  :
> 1. add a classpath=add/postgresql-8.2-507.jdbc3.jar; to env-variables
> 2. add the jar file to jre/lib/ext
> 3. add the jar file to myWebApp/WEB-INF/lib
> 4. add the jar file to tomcat/lib
>
> but non of them works !
>
> would you please help me(I'm a java beginner!)

This is not a JDBC related issue, you should ask that to the
tomcat lists - but normally, you can either put the JAR in
tomcat/shared/lib so that it's visible, shared and used by all
your web applications, or inside the WEB-INF/lib directory of the
docbase of your application(s) so that it's loaded only for your
application(s).

--
Guillaume Cottenceau, MNC Mobile News Channel SA, an Alcatel-Lucent Company
Av. de la Gare 10, 1003 Lausanne, Switzerland - direct +41 21 317 50 36

Hello Moien,

Usually the following locations should do:

<tomcat_home>/common/lib (at least in Tomcat 5.5)
<webapp>/WEB-INF/lib

I wonder WHICH class it is your tomcat cannot find.
Please post the jsp, esspecially the import declarations at the top.

If you can try Tomcat 5.5 or JDK 1.6

Regards,
Daniel Migowski


Moien schrieb:
> Dear All
>
> I'm using :
>
> Microsoft Windows Xp
> Apache-tomcat-6.0.14
> Java version  1.5.0_14
> +
> PostgreSQL 8.2
> and
> postgresql-8.2-507.jdbc3.jar
>
> every time I wana run myApp.class I should type :
> java -cp postgresql-8.2-507.jdbc3.jar . myApp
>
> there is no problem . but when I import myApp into myJSP.jsp , tomcat
> brings this Error :
> javax.servlet.ServletException: java.lang.NoClassDefFoundError
>
> -----------------------
>
> I Tried to  :
> 1. add a classpath=add/postgresql-8.2-507.jdbc3.jar; to env-variables
> 2. add the jar file to jre/lib/ext
> 3. add the jar file to myWebApp/WEB-INF/lib
> 4. add the jar file to tomcat/lib
>
> but non of them works !
>
> would you please help me(I'm a java beginner!)
>
> Thanks alot
> Moein
> ------
>
>
> ------------------------------------------------------------------------

Hello Moien,

Usually the following locations should do:

<tomcat_home>/common/lib (at least in Tomcat 5.5)
<webapp>/WEB-INF/lib

I wonder WHICH class it is your tomcat cannot find.
Please post the jsp, esspecially the import declarations at the top.

If you can try Tomcat 5.5 or JDK 1.6

Regards,
Daniel Migowski


Moien schrieb:
> Dear All
>
> I'm using :
>
> Microsoft Windows Xp
> Apache-tomcat-6.0.14
> Java version  1.5.0_14
> +
> PostgreSQL 8.2
> and
> postgresql-8.2-507.jdbc3.jar
>
> every time I wana run myApp.class I should type :
> java -cp postgresql-8.2-507.jdbc3.jar . myApp
>
> there is no problem . but when I import myApp into myJSP.jsp , tomcat
> brings this Error :
> javax.servlet.ServletException: java.lang.NoClassDefFoundError
>
> -----------------------
>
> I Tried to  :
> 1. add a classpath=add/postgresql-8.2-507.jdbc3.jar; to env-variables
> 2. add the jar file to jre/lib/ext
> 3. add the jar file to myWebApp/WEB-INF/lib
> 4. add the jar file to tomcat/lib
>
> but non of them works !
>
> would you please help me(I'm a java beginner!)
>
> Thanks alot
> Moein
> ------
>
>
> ------------------------------------------------------------------------

> Hello Moien,
>
> Usually the following locations should do:
>
> <tomcat_home>/common/lib (at least in Tomcat 5.5)
> <webapp>/WEB-INF/lib
>
> I wonder WHICH class it is your tomcat cannot find.
> Please post the jsp, esspecially the import declarations at the top.
>
> If you can try Tomcat 5.5 or JDK 1.6
>
> Regards,
> Daniel Migowski
>

just courious, Why  tomcat 5.5   any advice against  tomcat 6 ?

thank you

Leonel

> Dear All
>
> I'm using :
>
> Microsoft Windows Xp
> Apache-tomcat-6.0.14
> Java version  1.5.0_14
> +
> PostgreSQL 8.2
> and
> postgresql-8.2-507.jdbc3.jar
>
> every time I wana run myApp.class I should type :
> java -cp postgresql-8.2-507.jdbc3.jar . myApp
>
> there is no problem . but when I import myApp into myJSP.jsp , tomcat
> brings this Error :
>
> javax.servlet.ServletException: java.lang.NoClassDefFoundError
>

how did you "imported" your app into the jsp ??


leonel