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
