<jsp:forward page=""/> not working

[abhiavi kumar]

This is my .JSP file, there are two <jsp:forward page> in this code, the one in the "else" part works, while the other does not.

<%@ page import="java.sql.*,java.util.*" %>


<%

				try
		        {
					Class.forName("oracle.jdbc.driver.OracleDriver");
						Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
						Connection con= DriverManager.getConnection("jdbc:odbc:etrans","etrans","etrans");
			
					PreparedStatement ps = con.prepareStatement("select id,question,answer from login  where id=? and question=? and answer=? ");
                                        PreparedStatement np = con.prepareStatement("update login set password=? where id=?");
			        ps.setString(1,request.getParameter("id"));
					
					ps.setString(2,request.getParameter("question"));
					ps.setString(3,request.getParameter("answer"));
					np.setString(1,request.getParameter("newpassword"));
					np.setString(2,request.getParameter("id"));
					ResultSet rs = ps.executeQuery();

					
					if(rs.next())
					{
						ResultSet bs = np.executeQuery();
						session.putValue("id",request.getParameter("id"));

					  //session.putValue("question",request.getParameter("question"));
                                          //session.putValue("answer",request.getParameter("answer"));
                         System.out.println("3333333333333333"+session.getValue("id"));


%>	
                                           <jsp:forward page="home.html"/>

<%
						System.out.println("3333333333333333");
			         }
			         else
			         {
				        System.out.println("44444444444444");	
%>
					     <jsp:forward page="Login.jsp"/>
<%
                      }
         		   }
			       catch(Exception e)
			       {
					   e.printStackTrace();
			       }
%>

Everything actually works as it should, if the required details are entered and correct, the "password" value in the "Login" table of my backend does get updated, but after that, the code <jsp:forward page="home.html"/> does not work, all I see is a white page with nothing on it.

The <jsp:forward page = login.jsp"/> code in my else part does work though, it works as intended if the entered details are wrong or if nothing is entered (The required details are entered in the previous page).

The problem seems to be because of "ResultSet bs = np.executeQuery();", if I remove this, the <jsp:forward page="home.html"/> does work like it should. but I need this code to update the password in my table. so is there any reason for <jsp:forward page> to not work after an update?

thanks...

[Stefan Evans]

#1: Check your logs for an error message.

#2: None of this code belongs in a JSP. Put java code in a java class. There is absolutely no presentation logic here, it should be in a servlet.

#3: Use a JNDI datasource rather than opening a new database connection every time would be preferable.

[jagrutkumar dalwadi]

Also jsp file is used for showing data/view purpose only. It should not contain Business logic or controller related code.
Controller related code should be in servlet and business logic should be in Pojo.
As per the good programming practise, scriptlets should not be used in jsp file, rather use jsp standard actions.