Hi
I am writing a web based application as part of a small project that I
am undertaking using servlets beans and jsp.
I already have one servlet - bean - jsp page working and I have
written another servlet - bean - jsp but I am hitting an error from
tomcat that I have no idea why it is failing. I am getting an
org.apache.jasper.JasperException: with the root cause being
java.lang.ClassNotFoundException:
Here is the code for the servlet :
package platsWeb;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.net.*;
import java.io.*;
import platsBeans.*;
public class joinGroup extends HttpServlet{
private platsWeb.dbConnection dbconn = new
platsWeb.dbConnection();
private ResultSet rs;
public void doPost(HttpServletRequest request,
HttpServletResponse response)throws ServletException, IOException{
String group_id, user_id;
user_id = request.getParameter("user_id");
group_id = request.getParameter("group");
String joinGroup =("INSERT INTO groupusers(group_id,
user_id)VALUES("+group_id+","+user_id+");");
String selectUserData = ("SELECT user_id, firstname
FROM users"+
" WHERE user_id="+user_id+";");
String getGroup = ("SELECT * FROM `group` WHERE
group_id="+group_id+";");
groupBean gb = new groupBean();
String url =("/accountfinish.jsp");
dbconn.connect();
dbconn.insert_data(joinGroup);
request.setAttribute("groupbean", gb);
rs = dbconn.select_data(getGroup);
gb.setGroup(rs);
rs = dbconn.select_data(selectUserData);
gb.setUser(rs);
getServletConfig().getServletContext();
RequestDispatcher dispatcher =
getServletContext().getRequestDispatcher(url);
dispatcher.forward(request, response);
dbconn.close_connection();
}
}
and the bean:
package platsBeans;
import java.sql.*;
public class groupBean{
private ResultSet groupRS, userRS;
private String group_name, userfirstname;
private int user_id;
public void setGroup(ResultSet in){
System.err.println("setGroup GB");
groupRS = in;
}
public void setUser(ResultSet in){
System.err.println("setUser GB");
userRS = in;
}
public String getGroup(){
try{
groupRS.next();
group_name = groupRS.getString("groupName");
}catch(SQLException sqle){
System.err.println("SQLException: "+
sqle.getMessage());
}
return group_name;
}
public String getUser(){
try{
userRS.next();
userfirstname = userRS.getString("firstname");
}catch(SQLException sqle){
System.err.println("SQLException: " +
sqle.getMessage());
}
return userfirstname;
}
}
The code seems to be failing when I use the dispatcher to forward to
the new url???
Any help would be greatly received.
Thanks in advance
Grant Collins