Unable to sent data from jsp to oracle database

i'm creating a web application for that. i want to create a registration page for that i've used the following code.but unable to send data.

form data

Servlet data

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.sql.*;

public class InsertRegtodb extends HttpServlet
{
/**
	 * 
	 */
	private static final long serialVersionUID = 2L;

public void doGet(HttpServletRequest request,HttpServletResponse response) 
throws ServletException,IOException
{
response.setContentType("text/html");
PrintWriter out=response.getWriter();
String fname = request.getParameter("fname");
String lname = request.getParameter("lname");
String email = request.getParameter("email");
String pass = request.getParameter("pass");
String cpass = request.getParameter("cpass");
int mobile = Integer.parseInt(request.getParameter("mobile"));
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:cmd","scott","root");
PreparedStatement stmt=con.prepareStatement("INSERT INTO REGISTRATION( FNAME, LNAME, EMAIL, PASS, CPASS, MOBILE) VALUES (?,?,?,?,?,?)");
stmt.setString(1, fname);
stmt.setString(2, lname);
stmt.setString(3, email);
stmt.setString(4, pass);
stmt.setString(5, cpass);
stmt.setLong(6, mobile);
int i=stmt.executeUpdate();
if(i!=0){  
	out.println("<b>You are successfully Registered</b>");  
  }  
  else{  
	  out.println("<b>Registration failed</b>");
   }  
}  
catch(ClassNotFoundException e){  
    out.println("Couldn't load database driver: " + e.getMessage());  
  }  
  catch(SQLException e){  
    out.println("SQLException caught: " + e.getMessage());  
  }  
  catch (Exception e){  
    out.println(e);  
}  
}  
}

i'm using oracle 11g database scott scheme... and created a table named registration using sql developer

What does "unable" mean? What, exactly, does the code do now, and what did you expect it to do instead?

unable means data submitted from the form is not storing in database.

i'm getting the below error while trying to send the data

The requested resource (/test/InsertRegtodb) is not available.

here test is project name and InsertRegtodb is servlet name.

i'm expecting this code to store data into registration table in database

Seems like the URL you're trying to submit the form to doesn't exist. At first glance the servlet accepts GET requests, whereas the form submits a POST - so that wouldn't work right off the bat. Servlet code that writes ot the DB should never be accessed via GET - so the form does the right thing, but the servlet isn't set up properly.

no actually the servlet is present is the mentioned address. but it is not connecting to it

there is one more servlet in the same folder and which is accessible from another jsp. but tis servlet is not accessible even though i have used same code as it is used for the servlet which worked for me previously

no actually the servlet is present is the mentioned address.

How do you know? The evidence suggests that it is not, yes? Maybe the web.xml is set up incorrectly? Maybe there's an error during initialization?

Maybe the web.xml is set up incorrectly?

xml is file the problem i think
ok i will see the web.xml and get back to you..

got it.

jsp to servlet connection is working.

but now i'm getting class not found exception while connecting to DB

That exception tells you which class is missing - add it to WEB/classes or WEB-INF/lib and you should be good to go.

thank you Dittmer its working