Forum:

HTTP Status 404 -

Ranch Hand

Posts: 88

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi Folks...

I am getting the following error when I click on the submit buttin of my form:

HTTP Status 404 -

--------------------------------------------------------------------------------

type Status report

message

descriptionThe requested resource () is not available.

I believe this could be something which people encounter regularly. I am not able to figure out why I am getting this. The the form 'action' in jsp is pointing to the correct servlet I want and in the web.xml file, the servlet is declared as well...yet I am gettting this error...The codes are as follows:

sysuserBookingForm.jsp

<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>Booking Form</title>
    </head>
     <body>
<fieldset><legend>Booking Form</legend>
<form action="sysuserBookingFormServlet" method="post" >
  <table width="500" border="0" cellspacing="0" cellpadding="0">
    <tr>
      <td><label>User Id</label></td>
      <td><%= request.getRemoteUser()%></td>
      <td><label>        
      </label></td>
    </tr>
    <tr>
      <td><label>Studio</label></td>
      <td><select name="studio">
        <option>----SELECT STUDIO----</option>
        <option value="T2045A">Studio A</option>
        <option value="T2033B">Studio B</option>
        <option value="T2033C">Studio C</option>
        <option value="T1933V">Visual Effects Studio</option>
      </select></td>
    </tr>

<tr>
      <td><label>CalDate</label></td>
      <td><label>
        <input type="text" name="Caldate" />
      (mm/dd/yyyy)</label></td>
    </tr>

<tr>
      <td><label>Dateofbooking</label></td>
      <td><label>
        <input type="text" name="dateofbooking" />
      (mm/dd/yyyy)</label></td>
    </tr>
    <tr>
      <td><label>Start Time</label></td>
      <td><label>
        <select name="bookingstarttime">
          <option>----SELECT START TIME----</option>
          <option value="0800 - 1000">0800 - 1000</option>
          <option value="1000 - 1200">1000 - 1200</option>
          <option value="1200 - 1400">1200 - 1400</option>
          <option value="1400 - 1600">1400 - 1600</option>
          <option value="1600 - 1800">1600 - 1800</option>
          <option value="1800 - 2000">1800 - 2000</option>
          <option value="2000 - 2200">2000 - 2200</option>
        </select>
      </label></td>
    </tr>
     <tr>
        <td>End Time </td>
        <td><select name="bookingendtime">
          <option>----SELECT END TIME----</option>
          <option value="0800 - 1000">0800 - 1000</option>
          <option value="1000 - 1200">1000 - 1200</option>
          <option value="1200 - 1400">1200 - 1400</option>
          <option value="1400 - 1600">1400 - 1600</option>
          <option value="1600 - 1800">1600 - 1800</option>
          <option value="1800 - 2000">1800 - 2000</option>
          <option value="2000 - 2200">2000 - 2200</option>
        </select></td>
    </tr>
     <tr>
       <td></td>
       <td><label></label></td>
     </tr>
     <tr>
       <td></td>
       <td><input type="submit" value="Submit" />
       </td>
     </tr>
  </table>
</form>
</fieldset>
</body>
</html>

sysuserBookingFormServlet

package com.ProjecteBooking4.controller;

import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.sql.Date;
import java.sql.Time;
import javax.annotation.Resource;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.sql.DataSource;

public class sysuserBookingFormServlet extends HttpServlet {
   
   @Resource(name = "jdbc/DMIT")
    private DataSource dataSource;

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

String insertBookingSql = "insert into booking (FK_idfacility, FK_iduser,  FK_caldate, dateofbooking, bookingstarttime, bookingendtime) values (?,?,?,?,?,?)";

PreparedStatement insertBookingStatement;

System.out.println("hi");

//String FK_idfacility = request.getParameter("value");
//String FK_iduser = "p0248448";
//String FK_caldate = request.getParameter("date");
//String dateofbooking = request.getParameter("dateofbooking");
//String bookingstarttime = request.getParameter("bookingstarttime");
//String bookingendtime = request.getParameter("bookingendtime");

try
    {
      Connection connection = dataSource.getConnection();

insertBookingStatement = connection.prepareStatement(insertBookingSql);

//*** FIRST ROW ****

//FK_idfacility
insertBookingStatement.setString(1,"T1933V");
//insertBookingStatement.setString(1,FK_idfacility);

//FK_iduser
insertBookingStatement.setString(2, "p0248448");
//insertBookingStatement.setString(2, FK_iduser);

//FK_caldate
insertBookingStatement.setDate(3,Date.valueOf("2010-03-12"));
//insertBookingStatement.setDate(3,Date.valueOf(FK_caldate));

//dateofbooking
insertBookingStatement.setDate(4,Date.valueOf("2009-06-29"));
//insertBookingStatement.setDate(4,Date.valueOf(dateofbooking));

//bookingstarttime
insertBookingStatement.setTime(5,Time.valueOf("18:00:00"));
//insertBookingStatement.setTime(5,Time.valueOf(bookingstarttime));

//bookingendtime
insertBookingStatement.setTime(6, Time.valueOf("20:00:00"));
//insertBookingStatement.setTime(6,Time.valueOf(bookingendtime));

insertBookingStatement.executeUpdate();

//*** END OF FIRST ROW ****
connection.close();

response.getWriter().println("Database Updated Successfully");

}

catch (SQLException e)
    {

e.printStackTrace();

}

protected void processRequest(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        //response.setContentType("text/html;charset=UTF-8");

bookingFormBean bookingForm = new bookingFormBean();

//INVOKING THE SETTER METHODS OF 'bookingFormBean.java' WITH ARGUMENTS
        bookingForm.setName(request.getParameter("name"));
        bookingForm.setAdmin(request.getParameter("admin"));
        bookingForm.setstudClass(request.getParameter("studClass"));
        bookingForm.setModule(request.getParameter("module"));
        bookingForm.setcontactNo(request.getParameter("contactNo"));
        bookingForm.setstudio(request.getParameter("studio"));
        bookingForm.setdate(request.getParameter("date"));
        bookingForm.setday(request.getParameter("day"));
        bookingForm.settime(request.getParameter("time"));

request.setAttribute("bookingForm", bookingForm);

request.getRequestDispatcher("bookingConfirmed.jsp").forward(request, response);

}

// <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
    /** 
     * Handles the HTTP <code>GET</code> method.
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
//    @Override
//    protected void doGet(HttpServletRequest request, HttpServletResponse response)
//    throws ServletException, IOException {
//        processRequest(request, response);
//    }

/** 
     * Handles the HTTP <code>POST</code> method.
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        processRequest(request, response);
    }

/** 
     * Returns a short description of the servlet.
     * @return a String containing servlet description
     */
    @Override
    public String getServletInfo() {
        return "Short description";
    }//</editor-fold>

}

web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.5" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">
<servlet>
        <servlet-name>JDBCSelectServlet</servlet-name>
        <servlet-class>com.ProjecteBooking4.controller.JDBCSelectServlet</servlet-class>
    </servlet>

<servlet>
        <servlet-name>sysuserBookingFormServlet</servlet-name>
        <servlet-class>com.ProjecteBooking4.controller.sysuserBookingFormServlet</servlet-class>
    </servlet>

<servlet-mapping>
        <servlet-name>JDBCSelectServlet</servlet-name>
        <url-pattern>/JDBCSelectServlet</url-pattern>
    </servlet-mapping>

<servlet-mapping>
        <servlet-name>sysuserBookingFormServlet</servlet-name>
        <url-pattern>/sysuserBookingFormServlet</url-pattern>
    </servlet-mapping>

<session-config>
        <session-timeout>
            30
        </session-timeout>
    </session-config>
    <welcome-file-list>
        <welcome-file>JDBCSelectServlet</welcome-file>
        </welcome-file-list>

<security-constraint>
        <display-name>sysadmin pages</display-name>
        <web-resource-collection>
            <web-resource-name>sysadmin pages</web-resource-name>
            <description/>
            <url-pattern>/sysadmin/*</url-pattern>
            <http-method>GET</http-method>
            <http-method>POST</http-method>
            <http-method>HEAD</http-method>
            <http-method>PUT</http-method>
            <http-method>OPTIONS</http-method>
            <http-method>TRACE</http-method>
            <http-method>DELETE</http-method>
        </web-resource-collection>
        <auth-constraint>
            <description/>
            <role-name>sysadmin</role-name>
            </auth-constraint>
        </security-constraint>
    <security-constraint>
        <display-name>sysuser pages</display-name>
        <web-resource-collection>
            <web-resource-name>sysuser pages</web-resource-name>
            <description/>
            <url-pattern>/sysuser/*</url-pattern>
            <http-method>GET</http-method>
            <http-method>POST</http-method>
            <http-method>HEAD</http-method>
            <http-method>PUT</http-method>
            <http-method>OPTIONS</http-method>
            <http-method>TRACE</http-method>
            <http-method>DELETE</http-method>
        </web-resource-collection>
        <auth-constraint>
            <description/>
            <role-name>sysuser</role-name>
            </auth-constraint>
        </security-constraint>
    <login-config>
        <auth-method>FORM</auth-method>
        <realm-name/>
        <form-login-config>
            <form-login-page>/login.jsp</form-login-page>
            <form-error-page>/loginerror.jsp</form-error-page>
            </form-login-config>
        </login-config>
    <security-role>
        <description>Adminstrators of the system</description>
        <role-name>sysadmin</role-name>
    </security-role>
    <security-role>
        <description>Non adminstrative users of the system, like students and lecturers</description>
        <role-name>sysuser</role-name>
    </security-role>
    </web-app>

I really hope someone can advise. Thanks..

Devaka Cooray

Sheriff

Posts: 7342

1404

I like...

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Please IsolateTheProblem instead of posting the whole lengthy code of your Servlet.

For now, what I can guess is, your problem might be with the following statement

request.getRequestDispatcher("bookingConfirmed.jsp").forward(request, response);

Are you sure that bookingConfirmed.jsp exists? Also, you may also want to insert a forward-slash at the beginning:
/bookingConfirmed.jsp

Author of ExamLab - a free SCJP / OCPJP exam simulator
What would SCJP exam questions look like? -- OCPJP Online Training -- Twitter -- How to Ask a Question

Varnam Aayiram

Ranch Hand

Posts: 88

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi Devaka Cooray ...

Thanks for the reply. I have commented out this line:

I was hoping now this line will get printed to the browser

But it's not, I am still getting the same error as before..

Jaikiran Pai

Sheriff

Posts: 10445

227

I like...

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Varnam Aayiram wrote:

I was hoping now this line will get printed to the browser

response.getWriter().println("Database Updated Successfully");

But it's not, I am still getting the same error as before..

That statement is never processed. You are sending a POST request and the doPost() in the code that you posted, doesn't lead to that statement.

[My Blog] [JavaRanch Journal]

Varnam Aayiram

Ranch Hand

Posts: 88

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi Jaikiran Pai ..

Thanks for pointing it out to me. I am still having the problem and I now suspect it's something to do with the folders. All I want to do now is just to make sure that the servlet gets called and writes "This is a test" when the submit button is clicked on the form.

My folder structure is as follows:

I realise that if I were to place sysuserBookingForm.jsp outside the 'sysuser' folder(as in within the Webpages folder but not under any subfolder), and run the project, the form opens up and I click on the submit button, the servlet is invoked and "This is a test" appears in the browser, which is exactly what I want. However this dosen't happen when the sysuserBookingForm.jsp is within the sysuser folder. Do I have to make changes to the form action? I tried the following, this:

was changed to this:

It still gives me the same error. What then is the correct way to call/invoke the servlet from a jsp file that is located in a subfolder of the WebPages folder?

Bear Bibeault

Sheriff

Posts: 67752

173

I like...