Ryszad:
Please let me know if this works for you:
Driver driver =
(Driver) Class.forName("driver URL").newInstance();
This part of statement that you already had in your program:
(Driver) Class.forName("driver URL")
will load .class file into memory.
It is .newInstance() that will actually create and instance of Driver class.
Also make sure your URL is correct.
----- Original Message -----
From: "Luba Powell" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 18, 2001 10:46 AM
Subject: Re: Problem with Postgresql JDBC driver
> 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/
>
