Note that the tomcat.bat batch file includes:
set CLASSPATH=%TOMCAT_INSTALL%\lib\tomcat.jar
which will override your previously set CLASSPATH environment
variable. For info on the recommended way to add classes to
Tomcat 3.3, please refer to:
<http://jakarta.apache.org/tomcat/tomcat-3.3-doc/tomcat-ug.html#configuring_classes>
I would recommend as a first approach, renaming the two ".zip" files
to ".jar" files and copy them to TOMCAT_HOME\lib\common.
Cheers,
Larry
> -----Original Message-----
> From: Robert Keddie [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 14, 2002 11:02 AM
> To: [EMAIL PROTECTED]
> Cc: Jim Saullo
> Subject: Novice here! Classpath issue...Tomcat 3.3/IIS5.0/Win2k/Oracle
>
>
> I recieve the following error, but I shouldn't because the
> classpath has the following :
> CLASSPATH=.;C:\jdk1.3.1;C:\Oracle\Ora81\jdbc\lib\classes111.zi
> p;C:\Oracle\Ora81\jdbc\lib\nls_charset11.zip;
>
> Im using Tomcat 3.3 on IIS 5.0 on Win 2k ... the page source
> is at the bottom.
> When I first received this error I made subfolders under
> classes/oracle/jbdc/driver/* with the oracle driver classes
> but it then couldnt process this part
> "call.registerOutParameter(2, OracleTypes.CURSOR);
> call.registerOutParameter(3, OracleTypes.CURSOR)" of the page
> source at bottom.
> Please anyone help this novice!
>
> 2002-03-14 08:25:52 - ServerXmlReader:
> Config=$TOMCAT_HOME\conf\server.xml
> 2002-03-14 08:25:52 - PathSetter: home=C:\jakarta-tomcat
> 2002-03-14 08:25:52 - ContextXmlReader: Context
> config=$TOMCAT_HOME\conf\apps-127.0.0.1.xml
> 2002-03-14 08:25:52 - ContextXmlReader: Context
> config=$TOMCAT_HOME\conf\apps-admin.xml
> 2002-03-14 08:25:52 - ContextXmlReader: Context
> config=$TOMCAT_HOME\conf\apps-examples.xml
> 2002-03-14 08:25:52 - AutoWebApp: Loaded from config:
> DEFAULT:/admin 2002-03-14 08:25:52 - AutoWebApp: Loaded from
> config: DEFAULT:/examples 2002-03-14 08:25:52 - AutoWebApp:
> Auto-Adding DEFAULT:/marion 2002-03-14 08:25:52 - AutoWebApp:
> Auto-Adding DEFAULT:/ 2002-03-14 08:25:52 - ContextManager:
> Tomcat configured and in stable state 2002-03-14 08:25:52 -
> ContextManager: Adding DEFAULT:/admin 2002-03-14 08:25:52 -
> ContextManager: Adding DEFAULT:/examples 2002-03-14 08:25:52
> - ContextManager: Adding DEFAULT:/marion 2002-03-14 08:25:52
> - ContextManager: Adding DEFAULT:/ROOT
> EmbededTomcat: Init time 2750
> 2002-03-14 08:25:53 - Http10Interceptor: Starting on 8080
> 2002-03-14 08:25:53 - Ajp12Interceptor: Starting on 8007
> 2002-03-14 08:25:53 - Ajp13Interceptor: Starting on 8009
> EmbededTomcat: Startup time 421
> 2002-03-14 10:39:55 - SessionIdGenerator: Created random
> class java.security.SecureRandom 2002-03-14 10:40:17 -
> Ctx(/marion) : Compiling: /permit_details.jsp to
> permit_details_0 2002-03-14 10:40:27 - Ctx(/marion) : compile
> error: req=R( /marion + /permit_details.jsp + null) - org.apache.
> jasper.JasperException: Unable to compile
> C:\jakarta-tomcat\work\DEFAULT\marion\permit_details_1.java:6:
> Packa ge oracle.jdbc.driver not found in import. import
> oracle.jdbc.driver.*;
> ^
> 1 error
>
> at
> org.apache.tomcat.facade.JasperLiaison.javac(JspInterceptor.java:791)
> at
> org.apache.tomcat.facade.JasperLiaison.processJspFile(JspInter
> ceptor.java:632)
> at
> org.apache.tomcat.facade.JspInterceptor.requestMap(JspIntercep
> tor.java:446)
> at
> org.apache.tomcat.core.ContextManager.processRequest(ContextMa
> nager.java:966)
> at
> org.apache.tomcat.core.ContextManager.internalService(ContextM
> anager.java:873)
> at
> org.apache.tomcat.core.ContextManager.service(ContextManager.java:831)
> at
> org.apache.tomcat.modules.server.Ajp12Interceptor.processConne
> ction(Ajp12Interceptor.java:207)
> at
> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoi
> nt.java:477)
> at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(
> ThreadPool.java:517)
> at java.lang.Thread.run(Thread.java:484)
>
> page in question:
>
> <%@ page import="marion.*" %>
>
> <%@ page import="java.sql.*" %>
>
> <%@ page import="oracle.jdbc.driver.*" %>
>
> <HTML>
> <HEAD>
> <TITLE>Permit Details</TITLE>
> <!-- author Jim Saullo [EMAIL PROTECTED] -->
> <!-- this page last revised 09/27/01 by Jim Saullo -->
> <style>
> .monospace { font-family:monospace; }
> </style>
> <script>
> function inspections(temp) {
> location=("inspections.jsp?q_nbr="+temp) }
> function reviews(revw) {
> location=("reviews.jsp?r_nbr="+revw) }
> function certificates(cert) {
> location=("certificates.jsp?s_nbr="+cert) }
> function subcon(pnbr) { location=("subcontractor.jsp?nbr="+pnbr) }
> function menu() { location=("../marion_home.html") }
> function back() { window.history.back() }
> </script>
> <LINK REL=StyleSheet href="../style.css" TYPE="text/css"
> media=screen> </HEAD>
>
>
> <table border="0" width="665" cellspacing="0"
> cellpadding="0"> <tr valign="TOP">
> <td valign="TOP" width="65" align="center"></td>
> <td valign="TOP" width="600"><body bgcolor="#FFFFFF"
> background="../images/resultback.jpg" text="#000000"><map
> name="home"><area alt="Back To MCBCC Home Page"
> coords="361,83,432,100"
> href="http://www.marioncountyfl.org/index.shtml";>
> </map><% int count=0; String spacer = "No Impact Fees";
> String p_nbr = request.getParameter("nbr");%>
>
>
> <center>
> <p><img src="../Images/title.jpg" width=433 height=102
> border=0 usemap="#home"><br>
> <a
> href="http://www.marioncountyfl.org/departments/building/index.htm";
>
> style="color:#82B7A7;font-size:16;font-weight:bold;font-family
> :verdana,arial">
> Back To Building Home Page
> </a>
> </center>
>
> <form method=post ACTION="permit_third.jsp">
> <center>
> <% marion.DbBean1 dbConn=new marion.DbBean1();
> Connection conn=(Connection)dbConn.getConnection();
> CallableStatement call=conn.prepareCall("{call
> cdp_permits.permit_number_results(?,?,?)}");
> call.setLong(1,Long.parseLong(p_nbr));
> call.registerOutParameter(2, OracleTypes.CURSOR);
> call.registerOutParameter(3, OracleTypes.CURSOR);
> call.execute(); ResultSet rset = (ResultSet)call.getObject(2);
> while(rset.next()) {%><table border=1
> width=600><tr><td><b><font color=blue>Permit
> Data:</font></b><br>
> <b>Permit
> Number:</b> <%= rset.getString(1)
> %> <b>Parcel ID:</b> <%=
> rset.getString(2)
> %> <b>Status:</b> <%=
> rset.getString(3)
> %><br><br> &nbs
> p; <b>Permit
> Type:</b> <%=
> rset.getString(4) %> - <%=
> rset.getString(5)
> %><br><br> &nbs
> p; <b>Block:</b>  
> ; &
> nbsp; <%= rset.getString(6)
> %> <b>Lot:</b> <%=
> rset.getString(7) %> <b>Total
> SQFT:</b> <%= rset.getString(8)
> %> <b>Job Value:</b> <%=
> rset.getString(31)
> %><br> &n
> bsp; <b>Subdivision:</b> &nb
> sp; <%= rset.getString(9)
> %><br> &n
> bsp; <b>Street
> Address:</b> <%= rset.getString(10)
> %> <%= rset.getString(11) %> <%= rset.getString(12)
> %> <%= rset.getString(13) %><br></td></tr></table><table
> border=1 width=600><tr><td><b><font color=blue>Applicant
> Info:</font></b><br>
> <b>Issued
> Date:</b> <%=
> rset.getString(14)
> %> <b>Type:</b>
> <%= rset.getString(15)
> %><br> &n
> bsp; <b>Name:</b> &nbs
> p;
> <%= rset.getString(16) %><b>Job Phone:</b> <%=
> rset.getString(17) %></td></tr></table><table border=1
> width=600><tr><td><b><font color=blue>Owner
> Info:</font></b><br>
> <b>Name:</b> &n
> bsp; <%=
> rset.getString(18)
> %><br> &n
> bsp; <b>Address:</b> &
> nbsp;<%= rset.getString(19)
> %><br> &n
> bsp; &nbs
> p;
> <%= rset.getString(20) %> <%=
> rset.getString(21) %> <%= rset.getString(22)
> %></td></tr></table><table border=1
> width=600><tr><td><b><font color=blue>Contractor
> Info:</font></b><br>
> <b>License
> No.:</b> <%= rset.getString(23)
> %> <b>Name:</b>
> <%= rset.getString(24)
> %><br><br> &nbs
> p; <b>Address:</b> <%=
> rset.getString(25)
> %><br> &n
> bsp; &nbs
> p; <%=
> rset.getString(26) %> <%= rset.getString(27) %> <%=
> rset.getString(28)
> %><br><br> &nbs
> p; <b>Phone:</b> <%=
> rset.getString(29) %></td></tr></table><table border=1
> width=600><tr><td><b><font color=blue>Impact
> Fees:</font> &n
> bsp;<font color=black>Other fees may be due on this
> permit</font></b><tr<th width=550> </th><th width=25>Amt
> Due</th><th width=25>Amt Paid</th></tr><%
> ResultSet rset2 = (ResultSet)call.getObject(3);
> while(rset2.next()) {%>
>
> <tr><td><%= rset2.getString(1) %></td>
> <td><%= rset2.getString(2) %></td>
> <td><%= rset2.getString(3) %></td></tr>
> <%count = count+1; %>
> <% } %>
> <% if (count == 0) { %>
> <tr><td> <%= spacer %> </td></tr>
> <% } %>
> </table><table><br><tr><td><input type="Button"
> value="Inspections" onClick=inspections(<%= rset.getString(1)
> %>)><input type="button" value="Dept. Reviews"
> onClick=reviews(<%= rset.getString(1) %>)><input
> type="button" value="Contractor" onClick=certificates(<%=
> rset.getString(30) %>)> <input type="button" value="Sub
> Contractor" onClick=subcon(<%= rset.getString(1) %>)><br><br>
> <center> <input type="Button" value="Return to Menu"
> onClick=menu()> <input type="Button" value="Back"
> onClick=back()></center></td></tr></table><%count = count+1;
> %><% } %> <% System.out.println(count); %> <%if (count == 0) { %>
> <br><br>
> <center><table border=1 width=55%><tr><td>
> <center>
> <b><font color=black size=-1>No Records Found</font></b>
> </center>
> </td></tr></table>
> <br><br>
> <table><tr><td>
> <input type="Button" value="Return to Menu" onClick=menu()>
> <input type="Button" value="Back"
> onClick=back()>
> <br><br>
> </td></tr></table></center>
> <% } %>
>
> </form>
>
>
> </p></td></tr></table>
>
> </center>
> </BODY>
> </HTML>
>
>
>
>
> Robert Keddie
> web development
> Marion County, FL
>
> --
> To unsubscribe: <mailto:[EMAIL PROTECTED]>
> For additional commands: <mailto:[EMAIL PROTECTED]>
> Troubles with the list: <mailto:[EMAIL PROTECTED]>
>
--
To unsubscribe: <mailto:[EMAIL PROTECTED]>
For additional commands: <mailto:[EMAIL PROTECTED]>
Troubles with the list: <mailto:[EMAIL PROTECTED]>
