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(PageContextImpl.java,
Compiled Code)
at
_0002ftest_0005fpgsql_0002ejsptest_0005fpgsql_jsp_1._jspService(_0002ftest_0005fpgsql_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.java,
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_0005fpgsql_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.java,
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/
