Thread: more post & Tom

this is the error: I think it doesnt find the postgres driver.

Do you know something about postgresql.jar?

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

Error: 500

Localización: /e2.jsp

Error interno del Servlet:

javax.servlet.ServletException: org.postgresql.Driverat org.apache.jasper.runtime.PageContextImpl.handlePageException(Unknown Source)at e2_1._jspService(e2_1.java:121)at org.apache.jasper.runtime.HttpJspBase.service(Unknown Source)at javax.servlet.http.HttpServlet.service(HttpServlet.java)at org.apache.tomcat.facade.ServletHandler.doService(Unknown Source)at org.apache.tomcat.core.Handler.invoke(Unknown Source)at org.apache.tomcat.core.Handler.service(Unknown Source)at org.apache.tomcat.facade.ServletHandler.service(Unknown Source)at org.apache.tomcat.core.ContextManager.internalService(Unknown Source)at org.apache.tomcat.core.ContextManager.service(Unknown Source)at org.apache.tomcat.modules.server.Ajp12Interceptor.processConnection(Unknown Source)at org.apache.tomcat.util.net.TcpWorkerThread.runIt(Unknown Source)at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(Unknown Source)at java.lang.Thread.run(Thread.java:475)
Causa Raíz:
java.lang.ClassNotFoundException: org.postgresql.Driverat org.apache.tomcat.util.depend.DependClassLoader.loadClassInternal1(Unknown Source)at org.apache.tomcat.util.depend.DependClassLoader12$1.run(Unknown Source)at java.security.AccessController.doPrivileged(Native Method)at org.apache.tomcat.util.depend.DependClassLoader12.loadClass(Unknown Source)at java.lang.ClassLoader.loadClass(ClassLoader.java:243)at java.lang.Class.forName0(Native Method)at java.lang.Class.forName(Class.java:120)at e2_1._jspService(e2_1.java:67)at org.apache.jasper.runtime.HttpJspBase.service(Unknown Source)at javax.servlet.http.HttpServlet.service(HttpServlet.java)at org.apache.tomcat.facade.ServletHandler.doService(Unknown Source)at org.apache.tomcat.core.Handler.invoke(Unknown Source)at org.apache.tomcat.core.Handler.service(Unknown Source)at org.apache.tomcat.facade.ServletHandler.service(Unknown Source)at org.apache.tomcat.core.ContextManager.internalService(Unknown Source)at org.apache.tomcat.core.ContextManager.service(Unknown Source)at org.apache.tomcat.modules.server.Ajp12Interceptor.processConnection(Unknown Source)at org.apache.tomcat.util.net.TcpWorkerThread.runIt(Unknown Source)at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(Unknown Source)at java.lang.Thread.run(Thread.java:475)

Re: more post & Tom (qué? ;)

From

"Joe Shevland"

Date:

21 March 2002, 02:27:26

You're right, its not finding the driver classes.

Put the 'postgresql.jar' file under the:

  WEB-INF/lib

subdirectory of your web application and it should be picked up automatically (you will need to restart Tomcat) -
eitherthis for individual web applications (what I do), or you can put it under one of the main Tomcat lib directories
like<tc>/lib/apps or <tc>/lib/common which will make it available to all web applications. You've used the correct
classname though, so that should do it. Looks like you're not using a connection pool which might be something you want
tolook at if page responsiveness is important. 

Cheers,
Joe

-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org [mailto:pgsql-jdbc-owner@postgresql.org]On Behalf Of Gonzalo Aranda
Sent: Thursday, 21 March 2002 5:18
To: pgsql-jdbc@postgresql.org
Subject: [JDBC] more post & Tom


this is the error: I think it doesnt find the postgres driver.
Do you know something about postgresql.jar?
------------------------------------------------------------
Error: 500
Localización: /e2.jsp
Error interno del Servlet:

javax.servlet.ServletException: org.postgresql.Driver
    at org.apache.jasper.runtime.PageContextImpl.handlePageException(Unknown Source)
    at e2_1._jspService(e2_1.java:121)
[snip]
    at java.lang.Thread.run(Thread.java:475)
Causa Raíz:
java.lang.ClassNotFoundException: org.postgresql.Driver
[snip]