Unable to Run Servlet

[Somnath Mallick]

Hi Everyone,

I am working on JSP/Servlet code in Eclipse and JBoss AS 5.1.0. I have created a Dynamic Web Project in Eclipse and created the classes and the JSP's. The problem that i face is that when i run the project on the server then i face a problem that none of the JSP's get displyed on the Browser. Could you please tell me what the problem is. I have attached a screen shot of my Servlet because i think my folder structure in Eclipse is incorrect.

Only the <welcome-file> tag's JSP get rendered in the browser and then nothing.

<welcome-file-list>
         <welcome-file>/Login.jsp</welcome-file>
</welcome-file-list>

My web.xml file looks like:

<?xml version="1.0" encoding="UTF-8"?>
<web-app id="WebApp_ID" version="2.4"
 xmlns="http://java.sun.com/xml/ns/j2ee"
 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">
 <display-name>CheckServlet</display-name>
 <welcome-file-list>
  <welcome-file>/Login.jsp</welcome-file>
 </welcome-file-list>
 <login-config>
  <auth-method>BASIC</auth-method>
 </login-config>
</web-app>

Also want to know that is <welcome-file-list> a mandatory tag?

[Deepak Bala]

Where are the servlets ? Did you map them with servlet-name servlet-mapping ?

Could you please tell me what the problem is

You will need to give us a more descriptive error message for us to help you. You have a welcome file called Login.jsp. Technically a JSP is a servlet. Are you able to see Login.jsp ? Welcome file lists are not mandatory.

What sort of HTTP error code is the result of your request ? 404 / 500 / 503 ?

[Somnath Mallick]

Sorry about the previous web.xml file. Here is the latest one...

<?xml version="1.0" encoding="UTF-8"?>
<web-app id="WebApp_ID" version="2.4"
 xmlns="http://java.sun.com/xml/ns/j2ee"
 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">
 <display-name>CheckServlet</display-name>
 <servlet>
  <description>To check the username and passoword and do a secure login.</description>
  <display-name>B2BLogin</display-name>
  <servlet-name>B2BLogin</servlet-name>
  <servlet-class>com.internal.loginModule.B2BLogin</servlet-class>
 </servlet>
 <servlet-mapping>
  <servlet-name>B2BLogin</servlet-name>
  <url-pattern>/B2BLogin</url-pattern>
 </servlet-mapping>
 <welcome-file-list>
  <welcome-file>/Login.jsp</welcome-file>
 </welcome-file-list>
 <login-config>
  <auth-method>FORM</auth-method>
 </login-config>
</web-app>

The thing is: without the welcome file list is i don't see any pages. I get the error message as:

HTTP Status 404 - /CheckServlet/

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

type Status report

message /CheckServlet/

description The requested resource (/CheckServlet/) is not available.


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

JBoss Web/2.1.3.GA

And with the welcome file list. I see the Login.jsp, in which i have to enter a user name and password, but after that i don't see anything. I get the error message as:

HTTP Status 404 - /CheckServlet/homePage.jsp

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

type Status report

message /CheckServlet/homePage.jsp

description The requested resource (/CheckServlet/homePage.jsp) is not available.


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

JBoss Web/2.1.3.GA

I think there must be some problem with the the servlet code as well. Because the servlet code involves a JDBC code which normally takes some time. But here i just see the error coming almost instantly.

My servlet code is:

package com.internal.loginModule;

import java.io.FileInputStream;
import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.util.Properties;

import javax.servlet.Servlet;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.internal.databaseHandler.DBConnection;

/**
 * Servlet implementation class B2BLogin
 */
public class B2BLogin extends HttpServlet
{
	private static final long serialVersionUID = 1L;

	/**
	 * @see Servlet#destroy()
	 */
	public void destroy() 
	{
		// TODO Auto-generated method stub
	}

	/**
	 * To take the request and handle the response.
	 * @see javax.servlet.http.HttpServlet#doPost(javax.servlet.http.HttpServletRequest, javax.servlet.http.HttpServletResponse)
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException 
	{
		try
		{

			Properties properties = new Properties();
			properties.load(new FileInputStream("E:\\Workspace\\HealthCheck\\lib\\databaseConnection.properties"));

			String userName = request.getParameter("userName");
			String password = request.getParameter("passWord");


			Connection connection = DBConnection.dbconnect(properties);

			boolean login = DBConnection.credentialCheck(connection, userName, password);
			
			if (login)
			{
				PreparedStatement preparedStatement = connection.prepareStatement("select * from login_credentials where PASSWORD='" + password + "'");
				boolean check = preparedStatement.execute();

				if(check)
				{
					response.sendRedirect("/HomePage.jsp");
				}
				else
				{
					response.sendRedirect("/ErrorPage.jsp");
				}

			}
			else 
			{
				response.sendRedirect("/UnknownError.jsp");
			}
		}
		catch (Exception e)
		{
			e.printStackTrace();
		}
	}
}

[Deepak Bala]

Is this a WAR or EAR ? You can mention the context path for EARs and for WARs the application WAR name becomes its context path.

If you have Hello.war the URL should be

http://localhost:8080/WAR_NAME/SERVLET_NAME/

You URL pattern says B2BLogin, however you are requesting for servlet CheckServlet, which is the display name of the application

[Somnath Mallick]

So how to change them? I checked my JBoss admin console and I found that there is a "CheckServlet.war" entry in the Embedded Web Application section but there is also a CheckServletEAR.ear in the Enterprise Application section. So, i am confused that is it a WAR or and EAR?

[Ankit Garg]

Somnath Mallick wrote:The thing is: without the welcome file list is i don't see any pages.

This is normal behavior. When you don't specify a welcome file, then trying to access your application on the context path will try to give you a directory listing which I think is disabled by default. That's why you see an error message.

And with the welcome file list. I see the Login.jsp, in which i have to enter a user name and password, but after that i don't see anything. I get the error message as:

HTTP Status 404 - /CheckServlet/homePage.jsp

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

type Status report

message /CheckServlet/homePage.jsp

description The requested resource (/CheckServlet/homePage.jsp) is not available.


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

JBoss Web/2.1.3.GA

I think there's something wrong here. As can be seen from the screen-shot, there is a file named HomePage.jsp (with a upper case H) and in your servlet too, you have HomePage.jsp, but then why is this error message showing homePage.jsp (with a lower case h)??

[Somnath Mallick]

Even I have seen that. I but i dont know from where is it picking up that! Coz everywhere in my code there is "H" and no "h".

[shivendra tripathi]

The response.sendRedirect() method expects its path parameter to be relative to the server root. try response.sendRedirect("/{your context path goes here}/HomePage.jsp");

[Somnath Mallick]

Could you please tell me what the context path should be?

Is it:

http://localhost:8080/CheckServlet/

or

/CheckServlet/

[Ankit Garg]

Context path is /CheckServlet, but don't hard code that in your servlet, use the getServletContext().getContextPath() method...

[Somnath Mallick]

Thanks Ankit! I tried with:

/CheckServlet/HomePage.jsp

But nothing happened!

So should it be?

request.getServletContext().getContextPath()

[Somnath Mallick]

One thing i see is that, when i do a "Debug on Server" and add a break point inside the doPost method. The break point is never reached! The code gives HTTP 404 error even before the break point is reached. Please help.

[Somnath Mallick]

I tried a lot of stuff but i just am not able to run the jsp servet code on the server. Could you please guide me in what i am doing incorrectly! I read some guides and tutorials but none of that helped. I created a Dynamic Web Project in Eclipse and I am giving everything that I have done! I have attached my directory structure as an attachment is that may cause a problem!

My Servlet Code:

package com.portal.loginModule;

import java.io.FileInputStream;
import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.util.Properties;

import javax.servlet.Servlet;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.portal.dbHandler.DatabaseHandler;

public class B2BLogin extends HttpServlet
{
	private static final long serialVersionUID = 1L;

	/**
	 * @see Servlet#destroy()
	 */
	public void destroy() 
	{
		// TODO Auto-generated method stub
	}

	/**
	 * To take the request and handle the response.
	 * @see javax.servlet.http.HttpServlet#doPost(javax.servlet.http.HttpServletRequest, javax.servlet.http.HttpServletResponse)
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException 
	{
		try
		{

			Properties properties = new Properties();
			properties.load(new FileInputStream("E:\\Workspace\\HealthCheck\\lib\\databaseConnection.properties"));

			String userName = request.getParameter("userName");
			String passWord = request.getParameter("passWord");
			
			String rootp = getServletConfig().getServletContext().getRealPath("/");
			System.out.println(rootp);
			response.sendRedirect(rootp + "/Login.jsp");

			Connection connection = DatabaseHandler.dbconnect(properties);

			boolean login = DatabaseHandler.credentialCheck(connection, userName, passWord);
			
			if (login)
			{
				PreparedStatement preparedStatement = connection.prepareStatement("select * from login_credentials where PASSWORD='" + passWord + "'");
				boolean check = preparedStatement.execute();

				if(check)
				{
					response.sendRedirect("HomePage.jsp");
				}
				else
				{
					response.sendRedirect("ErrorPage.jsp");
				}

			}
			else 
			{
				response.sendRedirect("UnknownError.jsp");
			}
		}
		catch (Exception e)
		{
			e.printStackTrace();
		}
	}
}

/**
 * 
 */
package com.portal.dbHandler;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Properties;

public class DatabaseHandler 
{
	
	/**
	 * To get the connection of the database.
	 * @param properties
	 * @return connection
	 * @throws InstantiationException
	 * @throws IllegalAccessException
	 * @throws ClassNotFoundException
	 */

	public static Connection dbconnect (Properties properties) throws InstantiationException, IllegalAccessException, ClassNotFoundException
	{
		Connection connection = null;
		try
		{			
			Class.forName("oracle.jdbc.xa.client.OracleXADataSource").newInstance();
		
			connection = DriverManager.getConnection(properties.getProperty("DATABASE_URL"), properties.getProperty("USER_NAME"),properties.getProperty("PASSWORD"));
			connection.setAutoCommit(false);
			System.out.println("Connected to Database...");
			
		}

		catch (SQLException sqlException) 
		{
			System.out.println("Unable to Connect... Please Try Again.");
			sqlException.printStackTrace();
		}
		return connection;
	}
	
	/**
	 * To check if the User Name exists or not in the table.
	 * @param connection
	 * @param userName
	 * @param password
	 * @return check
	 * @throws SQLException
	 */
	public static boolean credentialCheck(Connection connection, String userName, String password) throws SQLException  
	{
		boolean check;
		
		PreparedStatement preparedStatement = connection.prepareStatement("Select 'true' result from dual WHERE exists (select null from login_credentials WHERE '" + userName + "' like USERNAME)");
		ResultSet resultSet = preparedStatement.executeQuery();
		
		if (resultSet.next()) 
		{  
			check = true;  
		}
		else 
		{  
			check = false;
		} 
		return check;
	}

}

My web.xml file:

<?xml version="1.0" encoding="UTF-8"?>
<web-app id="WebApp_ID" version="2.4" xmlns="http://java.sun.com/xml/ns/j2ee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">
	<display-name>CheckServlet1</display-name>
	<servlet>
		<description>
		</description>
		<display-name>B2BLogin</display-name>
		<servlet-name>B2BLogin</servlet-name>
		<servlet-class>
		com.portal.loginModule</servlet-class>
	</servlet>
	<servlet-mapping>
		<servlet-name>B2BLogin</servlet-name>
		<url-pattern>/B2BLogin</url-pattern>
	</servlet-mapping>
</web-app>

My Login.jsp:

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
	pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<HTML>
	<HEAD>
		<TITLE>Login Form</TITLE>
	</HEAD>
	<BODY>
		<FORM action="http://localhost:9090/CheckServelt1/B2BLogin" method="POST" style="background-color:LavenderBlush;">
			<h1 style="FONT-FAMILY: 'Raavi';"><i><B FONT-FAMILY: 'Lucida Calligraphy';">B2B Login Page</B></i></h1>
	 		<br>
			<br>
			<br>
			<br>
			<br>
			<table BORDER=5    >
				<tr>
					<td >User Name:</td>
					<td><INPUT TYPE="text" NAME="userName"></td>
				</tr>
				<tr>
					<td >Password:</td>
					<td><INPUT TYPE="password" NAME="passWord"></td>
				</tr>
			</table>
			<table BORDER=0   >
				<tr>
					<td><INPUT TYPE=SUBMIT VALUE=Submit></td><td></td><td></td>
					<td><INPUT TYPE=RESET VALUE=Reset></td>
				</tr>
			</table>
		</FORM>
	</BODY>
</HTML>

My HomePage.jsp:

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Error Page</title>
</head>
<body style="background-color:LavenderBlush;">
	<h1 style="FONT-FAMILY: 'Raavi';"><i><B FONT-FAMILY: 'Lucida Calligraphy';">Health Report Home Page</B></i></h1>
	<br>
	<br>
	<br>
	<br>
	<br>
	<br>
	<table BORDER=5    >
		<tr>
			<i><A  >1. Create User</A></i>
		</tr>
		<tr>
			<i><A  >2. Daily Report</A></i>
		</tr>
		<tr>
			<i><A  >3. Hourly Report</A></i>
		</tr>
	</table>
	</body>
</html>

I am trying to run it on Tomcat 5.5.28! When I start the server and run the project on the server i open the URL

http://localhost:9090/CheckServlet1/B2BLogin/Login.jsp

I get the following error:

HTTP Status 404 - /CheckServlet1/B2BLogin/Login.jsp

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

type Status report

message /CheckServlet1/B2BLogin/Login.jsp

description The requested resource (/CheckServlet1/B2BLogin/Login.jsp) is not available.


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

Apache Tomcat/5.5.28

Sorry for the long post. Lets just say I am pretty frustrated maybe i am doing some minor mistakes which i cant just figure out! Please help. I am desperate!