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.zip;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(JspInterceptor.java:632)
at org.apache.tomcat.facade.JspInterceptor.requestMap(JspInterceptor.java:446)
at
org.apache.tomcat.core.ContextManager.processRequest(ContextManager.java:966)
at
org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:873)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:831)
at
org.apache.tomcat.modules.server.Ajp12Interceptor.processConnection(Ajp12Interceptor.java:207)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.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> <b>Permit
Type:</b> <%= rset.getString(4)
%> - <%= rset.getString(5)
%><br><br> <b>Block:</b> <%=
rset.getString(6) %> <b>Lot:</b> <%=
rset.getString(7) %> <b>Total SQFT:</b> <%=
rset.getString(8) %> <b>Job Value:</b> <%=
rset.getString(31)
%><br> <b>Subdivision:</b> <%=
rset.getString(9)
%><br> <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> <b>Name:</b> <%=
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> <%=
rset.getString(18)
%><br> <b>Address:</b> <%=
rset.getString(19)
%><br> <%=
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> <b>Address:</b> <%=
rset.getString(25)
%><br> <%=
rset.getString(26) %> <%= rset.getString(27) %> <%= rset.getString(28)
%><br><br> <b>Phone:</b> <%=
rset.getString(29) %></td></tr></table><table border=1 width=600><tr><td><b><font
color=blue>Impact
Fees:</font> <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]>
