Unable to direct to page after login

[aristal wang]

Can anyone offer me assistance?

I have a servlet "Login.java" that is directed to different url depending on the login domain.

The login jsp is in "Tomcat 5.5\webapps\FYP" folder and the directed pages are in the "Tomcat 5.5\webapps\FYP\WEB-INF\classes" folder.

When i try to login using tomcat as the server, I get the following error.
"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)."

The servlet code is as follow:

import java.sql.*;
import java.io.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
 
public class Login extends HttpServlet
{
public void service (String gotoPage, HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException
 
{

//Get current session or create new one
 HttpSession session = req.getSession(true);
      
      //Get login info
      String Domain = req.getParameter("Domain");
       String username = req.getParameter("username");
      String password = req.getParameter("password");
      
      PrintWriter out = res.getWriter();
      
try
{
System.out.println("\nEstablishing Connection - Pls Wait... \n");

//Connect to the database specified in the URL
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc  :-o	  dbc  :mrgreen:  B1");
System.out.println("Connection Established.\n");
 
//Create a SELECT statement object
Statement statmt = con.createStatement();
      
      /*For COntractor*/
      if (Domain.equals("Contractor"))
      {
      //Issue the SELECT statement
      String querySt = "SELECT Engineer_Name, FROM Organisation WHERE Engineer_Name = ? AND Password = ?";
          
  // use PreparedStatement for more security and more easy
  PreparedStatement pstmt = con.prepareStatement(querySt); 
  pstmt.setString(1, username); // set the 1st quesmark(?) icon value to the user input username
  pstmt.setString(2, password); // set the 2nd quesmark(?) icon value to the user input password
  ResultSet rs = pstmt.executeQuery(querySt);
    
  if (rs.next())
  {
  // Got result mean username and password are correct
  gotoPage="/FYP/SupplierMainProj.jsp";
  //Retrieve each column in the row
  }
  else
  {
  // No result mean incorrect username and password
  gotoPage="/FYP/login.jsp";
      }
             
      //RequestDispatcher dispatcher =getServletContext().getRequestDispatcher(gotoPage);
//dispatcher.forward(req, res);     
      }
      
      /*For COntractor*/
      if (Domain.equals("Contractor"))
      {
      //Issue the SELECT statement
      String querySt = "SELECT Project_Engineer, Password FROM Supplier WHERE Project_Engineer = ? AND Password = ?";
          
  // use PreparedStatement for more security and more easy
  PreparedStatement pstmt = con.prepareStatement(querySt); 
  pstmt.setString(1, username); // set the 1st quesmark(?) icon value to the user input username
  pstmt.setString(2, password); // set the 2nd quesmark(?) icon value to the user input password
  ResultSet rs = pstmt.executeQuery(querySt);
    
  if (rs.next())
  {
  // Got result mean username and password are correct
  gotoPage="/FYP/Sub_main_proj.jsp";
  }
  else
  {
  // No result mean incorrect username and password
  gotoPage="/FYP/login.jsp";
      }
            
      RequestDispatcher dispatcher =getServletContext().getRequestDispatcher(gotoPage);
dispatcher.forward(req, res);
}

//Close Statement and Connection
statmt.close();
con.close();
System.out.println("\nConnection Closed - Operation Successful."); 
}

catch(Exception E)
{
//Print out the Exception Error
System.out.println("Error:" +E );
} 
}
}
 
/*private void gotoPage(String address,HttpServletRequest request,HttpServletResponse response)
throws ServletException, IOException 
{
RequestDispatcher dispatcher =getServletContext().getRequestDispatcher(address);
dispatcher.forward(request, response);
}*/
 

I have tried changing the "doGet" to "doPost" and service but the error merely change from "GET" to "POST". I have also tried removing the /FYP/ but it doesnt work either.

Can anyone offer me some assistance? Your assistance is very much appreciated.

Thanks.

[BSouther: Added UBB CODE tags]
[ January 05, 2007: Message edited by: Ben Souther ]

[Bosun Bello]

Don't override the service method. Use GET or POST.

[aristal wang]

I've tried get and post but it displays the error

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

Can there be any other thing that might have gone wrong?

pls help...

[Ulf Dittmer]

I don't see either doGet or doPost - how is the service method invoked?

Please use CODE tags around code of any length. It becomes much easier to read that way.

[aristal wang]

Sorry the doPost and doGet are replaced by service in the code. I've tried doPost doGet earlier but it doesnt work.


Please help!!!

[Ulf Dittmer]

The service method shown above does not override the one in HttpServlet, because it has a different signature. Thus it will not be called unless you do so explicitly somewhere. The default service/doGet/doPost methods that are being called just return the "doGet/doPost not allowed" errors that you are seeing.
[ January 05, 2007: Message edited by: Ulf Dittmer ]

[Jigar Naik]

just copy and paste the folloing code in your servlet.... and than see the console...

  

protected void doGet(HttpServletRequest req, HttpServletResponse resp)throws ServletException,IOException {
System.out.println("Inside Servlet...");
 
}

[aristal wang]

I'm sorry but which part of the code shld i put it into?

[Ulf Dittmer]

You'd put it into the servlet, on the same level as the "service" method.