tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Robert Turner <rturner...@yahoo.co.uk>
Subject RE: Database Driver - I have found the answer
Date Fri, 07 Sep 2001 21:04:46 GMT
I have found the answer to the problem. In the files
workers.properties and wrapper.properties there are
some classpath lines. I each I added a line with the
JSQLconnect.jar in it.

worker.inprocess.class_path=$(workers.tomcat_home)$(ps)lib$(ps)JSQLconnect.jar
wrapper.class_path=$(wrapper.tomcat_home)\lib\JSQLconnect.jar

Whether they are both needed I do not know, I am not
going to play around now that it works.

Thank you for all your help.

Robert T Turner




-----Original Message-----
>   I downloaded, yesterday, JSQLConnect but I am
failing to get it to
> work. I am using Windows XP (RC1), MSSQL7, IIS5 and
Tomcat 3.3
>
>   I have placed the jsqlconnect.jar in the tomcat
lib
> folder and have also
> placed that location in the CLASSPATH environmental
> variable.
>
>   The code I am using to test it is:
>
>   <%@ page language>   <!--
>   File: index.jsp
>   Author: Robert T Turner
>   Date: September 2001
>   -->
>   <%
>
>   Class.forName("com.jnetdirect.jsql.JSQLDriver");
>
>   Connection
myConn√ěrManager.getConnection("jdbc:JSQLConnect://loc
> alhost/database
> rectory&user√öiler&password>
>   Statement stmt>   String query> description";
>
>   ResultSet rs>
>   The error message I am getting is
>
>   Error: 500
>   Location: /jsp/index.jsp
>   Internal Servlet Error:
>
>   javax.servlet.ServletException: Unable to load
class
> com.jnetdirect.jsql.JSQLDriver
>    at
org.apache.jasper.runtime.PageContextImpl.handlePageExcept
> ion(PageContextImp
> l.java:459)
>    at
_0002findex_0002ejspindex_jsp_14._jspService(_0002findex_0
> 002ejspindex_jsp_1
> 4.java:118)
>    at
>
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.
> java:119)
>    at
>
javax.servlet.http.HttpServlet.service(HttpServlet.java:85
> 3)
>    at
>
org.apache.jasper.servlet.JspServlet$JspCountedServlet.ser
> vice(JspServlet.ja
> va:130)
>    at
>
javax.servlet.http.HttpServlet.service(HttpServlet.java:85
> 3)
>    at
>
org.apache.jasper.servlet.JspServlet$JspServletWrapper.ser
> vice(JspServlet.ja
> va:282)
>    at
>
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspSer
> vlet.java:429)
>    at
>
org.apache.jasper.servlet.JspServlet.service(JspServlet.ja
> va:500)
>    at
>
javax.servlet.http.HttpServlet.service(HttpServlet.java:85
> 3)
>    at
>
org.apache.tomcat.core.ServletWrapper.doService(ServletWra
> pper.java:405)
>    at
>
org.apache.tomcat.core.Handler.service(Handler.java:287)
>    at
>
org.apache.tomcat.core.ServletWrapper.service(ServletWrapp
> er.java:372)
>    at
>
org.apache.tomcat.core.ContextManager.internalService(Cont
> extManager.java:81
> 2)
>    at
>
org.apache.tomcat.core.ContextManager.service(ContextManag
> er.java:758)
>    at
>
org.apache.tomcat.service.connector.Ajp12ConnectionHandler
> .processConnection
> (Ajp12ConnectionHandler.java:166)
>    at
>
org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEnd
> point.java:416)
>    at
>
org.apache.tomcat.util.ThreadPool$ControlRunnable.run(Thre
> adPool.java:501)
>    at java.lang.Thread.run(Thread.java:484)
>
>   Root cause:
>   java.lang.ClassNotFoundException: Unable to load
class
> com.jnetdirect.jsql.JSQLDriver
>    at
org.apache.jasper.servlet.JasperLoader.findClass(JasperLoa
> der.java:223)
>    at
org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoa
> der.java:147)
>    at
>
java.lang.ClassLoader.loadClass(ClassLoader.java:253)
>    at
>
java.lang.ClassLoader.loadClassInternal(ClassLoader.java:3
> 13)
>    at java.lang.Class.forName0(Native Method)
>    at java.lang.Class.forName(Class.java:120)
>    at
>
_0002findex_0002ejspindex_jsp_14._jspService(_0002findex_0
> 002ejspindex_jsp_1
> 4.java:62)
>    at
>
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.
> java:119)
>    at
>
javax.servlet.http.HttpServlet.service(HttpServlet.java:85
> 3)
>    at
>
org.apache.jasper.servlet.JspServlet$JspCountedServlet.ser
> vice(JspServlet.ja
> va:130)
>    at
>
javax.servlet.http.HttpServlet.service(HttpServlet.java:85
> 3)
>    at
>
org.apache.jasper.servlet.JspServlet$JspServletWrapper.ser
> vice(JspServlet.ja
> va:282)
>    at
>
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspSer
> vlet.java:429)
>    at
>
org.apache.jasper.servlet.JspServlet.service(JspServlet.ja
> va:500)
>    at
>
javax.servlet.http.HttpServlet.service(HttpServlet.java:85
> 3)
>    at
>
org.apache.tomcat.core.ServletWrapper.doService(ServletWra
> pper.java:405)
>    at
>
org.apache.tomcat.core.Handler.service(Handler.java:287)
>    at
>
org.apache.tomcat.core.ServletWrapper.service(ServletWrapp
> er.java:372)
>    at
>
org.apache.tomcat.core.ContextManager.internalService(Cont
> extManager.java:81
> 2)
>    at
>
org.apache.tomcat.core.ContextManager.service(ContextManag
> er.java:758)
>    at
>
org.apache.tomcat.service.connector.Ajp12ConnectionHandler
> .processConnection
> (Ajp12ConnectionHandler.java:166)
>    at
>
org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEnd
> point.java:416)
>    at
>
org.apache.tomcat.util.ThreadPool$ControlRunnable.run(Thre
> adPool.java:501)
>    at java.lang.Thread.run(Thread.java:484)
>
>   Is there something I need to set up in any of the
properties files
> or xml files?
>
>   I think I am starting to round in circles, can you
help
> me?
>
>   Thanks
>   Robert T Turner


____________________________________________________________
Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mail.yahoo.ie

Mime
View raw message