PDA

View Full Version : problem while forwarding toward the error page.

guravharhsa
08-06-2008, 10: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


<%--
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


<%--
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