Try this:
Driver driver =
(Driver) Class.forName("driver URL").newInstance();
if (driver == null)
{
System.out.println("no driver found");
}
----- Original Message -----
From: "Ryszard Lach" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 18, 2001 6:40 AM
Subject: Problem with Postgresql JDBC driver
> Hi!
>
> I have serious problem with JDBC driver for postgresql. I'm using tomcat
3.2.2
> with jdk1.3.1 (I've tried 1.2.2 too). I've tried to put jdbc7.0-1.2.jar
into:
>
> $TOMCAT_HOME/lib
> $TOMCAT_HOME/webapp/my_app/WEB-INF/lib
>
> and unpacked jdbc7.0-1.2.jar into
>
> $TOMCAT_HOME/classes
> $TOMCAT_HOME/webapp/my_app/WEB-INF/classes
>
> and I still receive an error (included at bottom of the message) while
calling
> Class.forName("postgresql.Driver") in a .jsp file located in
.../webapp/my_app
> directory.
>
>
> I'm sure that classpath containing jdbc.*.jar is used by tomcat's startup
> script, but it seems I'm missing something...
>
> What could be wrong ? Do I have to configure workers or webapps in any
special
> way?
>
> Any help would be very appreciated.
>
> This is the error I receive:
>
> Error: 500
>
> Location: /test_pgsql.jsp
>
> Internal Servlet Error:
>
> javax.servlet.ServletException: No suitable driver
> at
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImp
l.java, Compiled Code)
> at
_0002ftest_0005fpgsql_0002ejsptest_0005fpgsql_jsp_1._jspService(_0002ftest_0
005fpgsql_0002ejsptest_0005fpgsql_jsp_1.java, Compiled Code)
> at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java,
Compiled Code) at javax.servlet.http.HttpServlet.service(HttpServlet.java,
Compiled
> Code)
> at
org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.ja
va, Compiled Code)
> at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java,
Compiled Code)
> at org.apache.jasper.servlet.JspServlet.service(JspServlet.java,
Compiled Code)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java,
Compiled Code)
> at
org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java,
Compiled Code)
> at org.apache.tomcat.core.Handler.service(Handler.java, Compiled
Code)
> at
org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java, Compiled
Code)
> at
org.apache.tomcat.core.ContextManager.internalService(ContextManager.java,
Compiled Code)
> at
org.apache.tomcat.core.ContextManager.service(ContextManager.java, Compiled
Code)
> at
org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection
(Ajp12ConnectionHandler.java, Compiled Code)
> at
org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java,
Compiled Code)
> at
org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java,
Compiled Code)
> at java.lang.Thread.run(Thread.java, Compiled Code)
>
> Root cause:
>
> java.sql.SQLException: No suitable driver
> at java.sql.DriverManager.getConnection(DriverManager.java,
Compiled Code)
> at java.sql.DriverManager.getConnection(DriverManager.java,
Compiled Code)
> at
_0002ftest_0005fpgsql_0002ejsptest_0005fpgsql_jsp_1._jspService(_0002ftest_0
005fpgsql_0002ejsptest_0005fpgsql_jsp_1.java, Compiled Code)
> at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java,
Compiled Code)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java,
Compiled Code)
> at
org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.ja
va, Compiled Code)
> at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java,
Compiled Code)
> at org.apache.jasper.servlet.JspServlet.service(JspServlet.java,
Compiled Code)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java,
Compiled Code)
> at
org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java,
Compiled Code)
> at org.apache.tomcat.core.Handler.service(Handler.java, Compiled
Code)
> at
org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java, Compiled
Code)
> at
org.apache.tomcat.core.ContextManager.internalService(ContextManager.java,
Compiled Code)
> at
org.apache.tomcat.core.ContextManager.service(ContextManager.java, Compiled
Code)
> at
org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection
(Ajp12ConnectionHandler.java, Compiled Code)
> at
org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java,
Compiled Code)
> at
org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java,
Compiled Code)
> at java.lang.Thread.run(Thread.java, Compiled Code)
>
>
> --
> ** Internet Designers S.A., ul. Przedmiejska 6--10, 54-201 Wrocław **
> tel. (071) 35 00 445 w. 25; fax (071) 37 35 946; http://www.id.pl/
