problem while forwarding toward the error page.

guravharhsa · 08-06-2008, 09:05 AM

Hi,
in my jsp page when sql exception occurs, i forward to the page error.jsp to display the message. but it not working . here is an page

Code:

<%-- 
    Document   : groupaddok
    Created on : Aug 4, 2008, 4:20:31 PM
    Author     : user1
--%>

<%@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%">&nbsp;&nbsp;&nbsp;
    
    <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.jsp page

Code:

<%-- 
    Document   : errorpage
    Created on : Aug 5, 2008, 4:34:03 PM
    Author     : user1
--%>

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@ page isErrorPage="true" import="java.io.*,java.sql.*" %>
<!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>JSP Page</title>
    </head>
    <body>
<%-- Exception Handler --%>
<font color="red">
    <P> THE ENTRY<%= exception.toString()%> ARE DUPLICATE IN  DATABASE</p><br>
</font>
<%
out.println("<!--");
StringWriter sw = new StringWriter();
PrintWriter pw = new PrintWriter(sw);
exception.printStackTrace(pw);
out.print(sw);
sw.close();
pw.close();
out.println("-->");
%>

<p> here is an test </p>

    </body>
</html>

Any suggestion is highly appreciated
Thanks and Regards
haresh