--- "Artigas, Ricardo Y." <[EMAIL PROTECTED]>
Download a trial/single use copy from
www.j-netdirect.com
The product JSQLConnect
Robert
wrote: > I'm not quite sure but try adding the jar's
filepath
> to your tomcat startup
> script (tomcat.bat).
> look for the lines similar to below and add one more
> line for your driver.
> (see line with your_sqldriver.jar).
> Where did you download your driver from? hth.
>
> :staticClasspath
> echo Setting your CLASSPATH statically.
> if exist "%TOMCAT_HOME%\lib\ant.jar" set
> CP=%CP%;%TOMCAT_HOME%\lib\ant.jar
> if exist "%TOMCAT_HOME%\lib\jasper.jar" set
> CP=%CP%;%TOMCAT_HOME%\lib\jasper.jar
> if exist "%TOMCAT_HOME%\lib\jaxp.jar" set
> CP=%CP%;%TOMCAT_HOME%\lib\jaxp.jar
> if exist "%TOMCAT_HOME%\lib\parser.jar" set
> CP=%CP%;%TOMCAT_HOME%\lib\parser.jar
> if exist "%TOMCAT_HOME%\lib\servlet.jar" set
> CP=%CP%;%TOMCAT_HOME%\lib\servlet.jar
> if exist "%TOMCAT_HOME%\lib\webserver.jar" set
> CP=%CP%;%TOMCAT_HOME%\lib\webserver.jar
> if exist "%TOMCAT_HOME%\lib\your_sqldriver.jar" set
> CP=%CP%;%TOMCAT_HOME%\lib\your_sqldriver.jar
>
>
>
> :~)
> Ricky Y. Artigas
> Analyst/Programmer /
> Database Administrator
> Information Technology Division
> Easycall Communications Phils., Inc.
> > -------------------------------
> > IMPORTANT NOTICE:
>
> > This message (and any attachment hereto) may
> contain privileged and/or
> > confidential information specific to EasyCall. If
> you are not the intended
> > addressee indicated in this message, you may not
> copy or disseminate this
> > message (or any attachment hereto) to anyone.
> Instead, please destroy this
> > message (and any attachment hereto), and kindly
> notify the sender by reply
> > email. Any information in this message (and any
> attachment thereto) that
> > do not relate to the official business of EasyCall
> shall be understood as
> > neither given nor endorsed by the company.
> >
> >
> > -----Original Message-----
> > From: Robert Turner [SMTP:[EMAIL PROTECTED]]
> > Sent: Friday, September 07, 2001 1:30 PM
> > To: tomcat-user
> > Subject: Database Driver
> >
> > I downloaded JSQLConnect, JDBC MSSQL type 4
> driver,
> > 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="java" import="java.sql.*" %>
> > <!--
> > File: index.jsp
> > Author: Robert T Turner
> > Date: September 2001
> > -->
> > <%
> >
> > Class.forName("com.jnetdirect.jsql.JSQLDriver");
> >
> > Connection
> >
>
myConn=DriverManager.getConnection("jdbc:JSQLConnect://localhost/database=
> > Directory&user=dailer&password=phone");
> >
> > Statement stmt=myConn.createStatement();
> > String query="SELECT * FROM Misc_Numbers ORDER BY
> > description";
> >
> > ResultSet rs=stmt.executeQuery(query);
> >
> > 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.handlePageException(PageContextI
> > mpl.java:459)
> > at
> >
>
_0002findex_0002ejspindex_jsp_14._jspService(_0002findex_0002ejspindex_jsp
> > _14.java:118)
> > 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.processConnecti
> > on(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.lang.ClassNotFoundException: Unable to load
> class
> > com.jnetdirect.jsql.JSQLDriver
> > at
> >
>
org.apache.jasper.servlet.JasperLoader.findClass(JasperLoader.java:223)
> > at
> >
>
org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:147)
> > at
> >
>
java.lang.ClassLoader.loadClass(ClassLoader.java:253)
> > at
> >
>
java.lang.ClassLoader.loadClassInternal(ClassLoader.java:313)
> > at java.lang.Class.forName0(Native Method)
> > at java.lang.Class.forName(Class.java:120)
> > at
> >
>
_0002findex_0002ejspindex_jsp_14._jspService(_0002findex_0002ejspindex_jsp
> > _14.java:62)
> > 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.
>
=== message truncated ===
____________________________________________________________
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
