Hi,
I tried to connect to mysql database with bean but fail with following error
:
org.apache.jasper.JasperException: Unable to compile class for
JSP/usr/local/jakarta-tomcat-3.2.1/work/localhost_8080/_0002fjsp_0002fdataba
seselect_0002ejspdatabaseselect_jsp_0.java:64: Class jsp.DatabaseSelect not
found.
DatabaseSelect select = null;
^
/usr/local/jakarta-tomcat-3.2.1/work/localhost_8080/_0002fjsp_0002fdatabases
elect_0002ejspdatabaseselect_jsp_0.java:67: Class jsp.DatabaseSelect not
found.
select= (DatabaseSelect)
^
/usr/local/jakarta-tomcat-3.2.1/work/localhost_8080/_0002fjsp_0002fdatabases
elect_0002ejspdatabaseselect_jsp_0.java:72: Class jsp.DataBaseSelect not
found.
select = (DataBaseSelect)
Beans.instantiate(this.getClass().getClassLoader(), "DataBaseSelect");
^
3 errors
I already put DataBaseSelect.java & DataBaseSelect in
/usr/local/jakarta-tomcat-3.2.1/webapps/examples/WEB-INF/classes
Looks like it fail to find the class,..so where should I put the class file
?
This is the jsp files ( in
/usr/local/jakarta-tomcat-3.2.1/webapps/examples/jsp)
<html>
<head>
<title>Select everything from a database</title>
</head>
<body>
<jsp:useBean id='select' class='DataBaseSelect' scope='page'
type="DatabaseSelect" />
<% out.print(select.connect()); %>
<br>
<% out.print(select.select()); %>
<p>Format results
<br>
<%@ page import="java.util.Vector" %>
<% Vector aResult = select.getResult(); %>
<table>
<% for (int i=0; i < aResult.size(); i++) { %>
<tr>
<td>
<% out.print(aResult.elementAt(i)); %>
</td>
</tr>
<% } %>
</table>
</body>
</html>
Thanks