JSP-Mysql:-Bad handshake problem

[Madhulika Bahl]

Hi
 I am using resin-1.2.3 and mysql at backend on windows 2000...I am trying to connect 
to mysql thru my JSP's but gotta bad handshake...I am using mysql-jdbc driver...
My JSP code is like this..

%@ page language="java" import=" java.sql.*, java.util.*" %>
  <%@ page import="sqlBean" %>
  <%@ page import="empQBean" %>

  <jsp:useBean id="empQBean" class="empQBean" scope="page" />

  <%
   empQBean.setConnection();
    if(empQBean.getEmp1()) {
      while(empQBean.getNextEmployee())  {
       String eid = empQBean.getColumn("empid");
       String last = empQBean.getColumn("lastname");
       String first = empQBean.getColumn("first");
       String ext = empQBean.getColumn("extension");

  %>
 

and In my empQBean I am trying to make connection..

empQBean

public class empQBean extends sqlBean {
  String empSql = "select * from employee";
  ResultSet rs = null;
  Statement stmt = null;

 public boolean getEmp1() throws Exception {
      stmt = myCon.createStatement();
      rs = stmt.executeQuery(empSql);
      return( rs != null);
   }
  
  public boolean getNextEmployee() throws Exception {
    return rs.next();
    }
    
   public String getColumn(String inCol) throws Exception {
      return rs.getString(inCol);
    }   
 }

sqlBean

public abstract class sqlBean {
  private String myDriver = "org.gjt.mm.mysql.Driver";
  private String myUrl = "jdbc:mysql://localhost:3306/test";
  
  protected Connection myCon;
  public sqlBean() {}
  
  public void setConnection() throws Exception {
    Class.forName(myDriver);
    myCon = DriverManager.getConnection(myUrl);
   }
   
}

So please tell me why I am getting bad handshake problem.....
 Thanks
 Madhulika