not able to connect to oracle DB

[rk sharma]

public class LoginServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;
	PrintWriter out;    
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		Connection connection = null;
	    Statement statement = null;
	    ResultSet rs = null;
	    response.setContentType("text/html");
	    out=response.getWriter();
	    String uname=request.getParameter("username");
        String upwd=request.getParameter("password");
	
	    try {
	    	// connecting to database
	    	
	      /*Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	      connection=DriverManager.getConnection("jdbc:odbc:rk","system","password");*/
	      Class.forName("oracle.jdbc.driver.OracleDriver");
	      connection = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","password");
	      statement = connection.createStatement();
	      rs = statement.executeQuery("SELECT * FROM dbusers");
	      // displaying data

	      while(rs.next()) {
	    	  String uname2=rs.getString("username");
	    	  String upwd2=rs.getString("password");
	    	  if (uname.equals(uname2) && upwd.equals(upwd2) && uname !=null && upwd !=null) {
	    		  response.sendRedirect("userLogged.jsp");
	    	  }
	    	  else {
	    		  response.sendRedirect("invalidLogin.jsp");
	    	  }
	        }
	    } 
	    catch (SQLException e) {
	    	e.printStackTrace();
	    }
	    catch (Exception e) {
	    	e.printStackTrace();
	    }
	    finally {
	      try {
	        if(rs != null) {
	          rs.close();
	          rs = null;
	        }
	        if(statement != null) {
	          statement.close();
	          statement = null;
	        }
	        if(connection != null) {
	          connection.close();
	          connection = null;
	        }
	      } 
	      catch (Exception e) {
	    	  e.printStackTrace();
	      }
	    }
	}
}

the error is wel known ClassCastException"
1.i attached the corresponding jar file ojdbc14.jar
2.no other errors, this is one particular program

[Philip Grove]

I cannot see any reason for a ClassCastException, please post the complete stack trace so we can see what happens.

BTW: Catching Exception is generally a bad idea as you might hide useful information