JSP problem when Tomcat runs as a Service

[Alda]

hello everybody,
I developed a JSP that connect to a DBASE-File via JDBC. Everything works fine as long as Tomcat ist startet via startup.bat in a DOS-Box. When I run Tomcat as Service I get the following error:

Internal Servlet Error:

javax.servlet.ServletException: No suitable driver
at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:459)
at dbf_0005fedit._0002fdbf_0005fedit_0002fedit_0002ejspedit_jsp_92._jspService(_0002fdbf_0005fedit_0002fedit_0002ejspedit_jsp_92.java:163)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServlet$JspCountedServlet.service(JspServlet.java:130)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:282)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:429)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:500)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
at org.apache.tomcat.core.Handler.service(Handler.java:287)
at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:812)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:758)
at org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection(Ajp12ConnectionHandler.java:166)
at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501)
at java.lang.Thread.run(Thread.java:484)

Root cause:
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:537)
at java.sql.DriverManager.getConnection(DriverManager.java:177)
at dbf_0005fedit._0002fdbf_0005fedit_0002fedit_0002ejspedit_jsp_92._jspService(_0002fdbf_0005fedit_0002fedit_0002ejspedit_jsp_92.java:93)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServlet$JspCountedServlet.service(JspServlet.java:130)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:282)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:429)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:500)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
at org.apache.tomcat.core.Handler.service(Handler.java:287)
at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:812)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:758)
at org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection(Ajp12ConnectionHandler.java:166)
at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501)
at java.lang.Thread.run(Thread.java:484)

My confuguration: Apache 1.3.20, Tomcat 3.2.2, Windows 2000.
Am I missing something? Any help is appreciated.
regards
Oliver

 

[donniea21]

Can you include the code you use to make your connection?

 

[Alda]

Sure...

String databaseDirectory="D:/programme/apache group/apache/htdocs/mapserv/data";
String url = "jdbcBF:/"+databaseDirectory;
String databaseDriverName ="zyh.sql.dbf.DBFDriver";

try {
Class.forName(databaseDriverName);
} catch(ClassNotFoundException cnfe) {
System.err.println("Treiberklasse nicht gefunden: "+cnfe);
}

String searchValue = request.getParameter("value"
Connection read_con = DriverManager.getConnection(url, "", ""
String query = "SELECT * FROM st_rec WHERE ORT='"+searchValue+"'";
Statement statement = read_con.createStatement();
ResultSet queryResult = statement.executeQuery(query);