Problem with forwarding page towards error page

Hi,
I am trying to forward page when an exception occured in current page. Now I am trying to handle the exception for duplicate entry in database .
But it not forward to the error page.
Here is page where i may get an duplicate entry exception:

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@ page language ="java" %>
<%@ page errorPage="errorpage.jsp" %>
<%@ page import="java.sql.*, javax.sql.*, javax.naming.*,java.io.*,java.util.*" %>
<!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=UTF-8">
        <title>add user</title>
        <link rel="stylesheet" href="styles/styles.css" type="text/css"> 
    </head>
    <body>
         <table width="100%" cellspacing="0" cellpadding="0" border="0">
<tr>
<td><%@ include file="/includes/logohead.jsp" %></td>
</tr> 
<tr><td><%@ include file="/toplinks.jsp"%></td></tr>
<tr><td width="100%" valign="top">
<table width="100%" cellspacing="0" cellpadding="0" border="1" borderColor=#000066>
    <tr>
<td width="80%">   
    
    <table border="1" width="50%" cellpadding="0" cellspacing="0" align="center" bordercolor="#B0C4DE">
       <% 
    String DESCRIPTION = request.getParameter("desc");   
            
     String connectionURL = "jdbc:mysql://localhost:3306/mynewdatabase";
   
     Connection connection = null;   
     PreparedStatement pstatement = null;
   
     Class.forName("com.mysql.jdbc.Driver").newInstance();
     int updateQuery = 0;

if(DESCRIPTION!=null){
     if(DESCRIPTION!="") {
            try {            
              
              connection = DriverManager.getConnection
              (connectionURL, "root", "root123");
             
              String queryString = "INSERT INTO groupid(description) VALUES (?)";
      pstatement = connection.prepareStatement(queryString);
               pstatement.setString(1,DESCRIPTION );
              
              updateQuery = pstatement.executeUpdate();
              //out.println("Q.="+updateQuery);
              if (updateQuery != 0) { %>
          
   
              <%
             
            }
              }
            
            catch (Exception ex) {
           // out.println("a"+ex.getMessage());    
           // out.println("Unable to connect to batabase.");
   
            }
            finally {
                pstatement.close();
                connection.close();
            }
  }
}
       %>
   <tr><td width="60%" class="StripFinalbold" ><font class="Fontfinalbold">The Group <%=DESCRIPTION%>  are added into Database.</font></td></tr></table>
</td></tr></table></td></tr>
   </table>
    </body>
</html>

and here is an error page:

It does not show me any exception.
Ant suggestion?
thanks in advance?
Regards
Harshal.

How are you getting the exception object in the error page even though the isErrorPage property is not set to true?

And what about the messages in the catch, do they show up if uncommented?

Sorry amit,
I had not posted full page of my error.jsp.
I had already set the iserror property true.
here is full page:

Thanks and Regards
Harshal
[ August 05, 2008: Message edited by: Harshal Gurav ]

Hi Sagar,

And what about the messages in the catch, do they show up if uncommented?

I do not want to show these message if exception is cought. just want to forward it to error.jsp page and show message displayed in error.jsp page

Thanks and Regards
Harshal
[ August 06, 2008: Message edited by: Harshal Gurav ]

Hi,
can any one help here?

Thanks and Regards
Harshal

whether you configure <error-page> in web.xml?

sorry!No need to configure in web.xml..try this simple example
index.jsp

error.jsp

Hope This Helps

Hi seetharaman ,
Thanks for your suggestion. I was not added error.jsp into web.xml but now added it.
But there is no change in OUTPUT. The jsp page direct to next page without showing error message OF ERROR PAGE.

I am using netbeans IDE.
Thanks and reagards
Harshal
[ August 06, 2008: Message edited by: Harshal Gurav ]

see my above post. and also important notes...

if you want that when exception happen your page has to forward to error page,then do not put try and catch

remove your try and catch block from your jsp

then it will run definitly

Hope This Helps

Hi seetharaman ,
you suggest code couses HTTP 500 Internal server error:

Here is an code

Where i doing wrong? please suggest.
Thanks and Regards
Harshal

try in mozilla.. in IE it is not working some time...i do not know why

Hi,
Thank you. its working on mozilla. Is there any alternative to handle the exception particularly sql exception? becouse Not all user may using mozilla.
Any suggestion?
regards
Harshal

hi

use web.xml for configure in your error page.

remove errorPage and isErrorPage from your Page directory. if any jsp throw sqlexception it redirect to error.jsp

Hope This Helps

Or, stop putting code that can cause exceptions in your JSP which should be for display.

Put the SQL in a Servlet (or better a data access object accessed in a Servlet). The Servlet checks for the SQL error and forwards to the proper page in normal conditions or the error page in exception conditions.

The error page is a complex work-around for applications that don't follow a good MVC architecture. If you move the control to a Servlet the problem disappears (as do many other related problems).