HTTP Status 405 - HTTP method GET is not supported by this URL

[mak zoe]

Hi all, I am first here...
I am now working a servlet which will also be connected to the database.
The problem is that , it shows the following error...

type Status report

message HTTP method GET is not supported by this URL

description The specified HTTP method is not allowed for the requested resource (HTTP method GET is not supported by this URL).


I have tried the following code and also the code :: doPost(request,response);
However, both don't work...

Please help...

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

public class RegistrateServlet extends HttpServlet {
        
    /*variable for handling client info*/
    private String imei;
    private String name;
    private String password;
    /*verification will be sent back to server mobile*/
    private String verification = "z";
    /*reqLimit indicate the time limit for a valid registration, 1500 means 15mins*/
    private final int regLimit = 1500;
    PrintWriter out ; 

 protected void doGet(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {

	out = response.getWriter();
           		response.setContentType("text/html");
                	out.println("START_DATA");
                	out.println("Hi");
                	out.println("END");

  //doPost(request,response);
    } 


    protected void doPOST(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        


 		       DataInputStream in = new DataInputStream((InputStream)request.getInputStream());
   

        imei = in.readUTF();
        name = in.readUTF();
        password = in.readUTF();
        /*after connecting the data for sql database, handle the request
         *1. remove the outdated record
         *2. check for registration */
        removerecord();
        verification = regVerification();
                
        response.setContentType("text/plain");
        response.setContentLength(verification.length());
        out = response.getWriter();
        out.print(verification);

        in.close();
	out.flush();
	out.close();
 
    }

    private void removerecord() {
        String url = "jdbc:mysql://localhost:3306/test";
        Connection con;
        Statement stmt;
        String query = "delete record from record where now()+0 - time+0 > "+regLimit+";"; 

        try {
            Class.forName("com.mysql.jdbc.Driver");
        } catch (java.lang.ClassNotFoundException e) {
            System.err.println("ClassNotFoundExceptionException:"+e.getMessage());
        }
        try {
            con = DriverManager.getConnection(url);
            stmt = con.createStatement();
            //here execute the query
            stmt.executeQuery(query);
            stmt.close();
            con.close();
        }catch (SQLException e) {
            System.err.println("SQLException:" +e.getMessage());
        }
    }

    private String regVerification() {
        String url = "jdbc:mysql://localhost:3306/test";
        Connection con;
        Statement stmt;
        /* returning four kinds of verification
         * Verification a : registration successfully
                            (this also applies to those who have registrated, time update)
         * verification b : registration failure
         *                 exist user (imei) but wrong password
         * verification c : registration failure
         *                  not existing user (no corresponding imei and name)
           verification z : the default one */

        String query1 = "select password from namelist where name ='"+name+"' and imei = '"+imei+"';";
        /*query1 is used in user database for searching a particular user with imei and returning the pw*/
        
        String query2 = "select name from record where imei ='"+imei+"';";
        /*query2 is used in record database for searching a particular user with imei and return date*/
        String query3 = "insert into record (imei) value ('"+imei+"');";
        /*query3 is used for inserting a particular user*/
        String query4 = "update record set time = current_timestamp where imei ='"+imei+"';";
        /*query4 is used updating the database record (time) for a particular user*/
        try {
            con = DriverManager.getConnection(url); 
            stmt = con.createStatement();
            //here execute the query
            ResultSet rs = stmt.executeQuery(query1);
            if (rs !=null){
                String pw = rs.getString("password");
            	// appear such a user
            	// check if the password is correct
            	if (pw.equalsIgnoreCase(password)){
            		 //correct pw
            		 if (stmt.executeQuery(query2)== null){
                             //no such a user in the record
                             //add the user to the database (record)
                             stmt.executeQuery(query3);
                             verification = "a";
            		}else{
                             //there exists that user the record should be updated
                             stmt.executeQuery(query4);
                             verification = "a";
            		}
            	}else{
                    //wrong password
                    verification = "b";
            	}
            }else{
            // there is no such a user
            	verification = "c"; 
            }
            stmt.close();
            con.close();
        }catch (SQLException e) {
            System.err.println("SQLException:" +e.getMessage());
        }
        return verification;
    }


   
}
  

[James Tharakan]

The access specifier of doGet method is public...
public void doGet(HttpServletRequest request, HttpServletResponse response)

and its doPost not doPOST()

[shivendra tripathi]

James Tharakan wrote:The access specifier of doGet method is public...
public void doGet(HttpServletRequest request, HttpServletResponse response)

It's protected not public. And I still have to find out why given code doesn't work.

[James Tharakan]

shivendra tripathi wrote:It's protected not public.

Thanks for correcting me