Printable View
iam getting this error in processing of my jsp page
http status 500
this is error in my code
org.apache.jasper.JasperException: An exception occurred processing JSP page /insertion.jsp at line 26
23: <% int sid=Integer.parseInt(request.getParameter("stdid") );
24: String sname=request.getParameter("stdname");
25: int avgmark=Integer.parseInt(request.getParameter("avg "));
26: ps.setInt(1,sid);
27: ps.setString(2,sname);
28: ps.setInt(3,avgmark);
29: rs = ps.executeUpdate();
thank u.
it mean that you have mistake in your jsp.
hai petr ,this is my jsp code could u plz tell me where the error occured
<%@page import="java.sql.*;" %>
<%!
Connection con=null;
PreparedStatement ps=null;
int rs=0;
%>
<%! public void jspInit()
{
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
con=DriverManager.getConnection("jdbc:oracle:thin: @localhost:1521:orcl","scott","tiger");
ps=con.prepareStatement("insert into students values(?,?,?)");
}
catch(Exception e)
{
e.printStackTrace();
}
}
%>
<% int sid=Integer.parseInt(request.getParameter("stdid") );
String sname=request.getParameter("stdname");
int avgmark=Integer.parseInt(request.getParameter("avg "));
ps.setInt(1,sid);
ps.setString(2,sname);
ps.setInt(3,avgmark);
rs = ps.executeUpdate();
if(rs!=0)
out.println("Record inserted successfully");
else
out.println("Record insertion failed");
%>
<%! public void jspDestroy()
{
try
{
con.close();
ps.close();
}
catch(Exception e)
{
e.printStackTrace();
}
}
%>
Can you show log from a server?
Yep.
I would bet that the creation of the PreparedStatement (or connection) has resulted in an exception, meaning ps is null. So ps.setInt() will be throwing a NullPointerException.
None of this code should be in a JSP.
It should be in its own layer (ie set of classes) and called from a Servlet.
hai petr, thanks for ur reply,
but i can't understand ur statement
is it means the errors occured at the running server or jsp equalent servlet program.
thanks.
How I guess you use Tomcat as jsp/servlet container. so tomcat compiles jsp page in run time, hence if you have mistake in jsp server will ask about your mistake. For it you need look in log file by server or use follows approach.
In descriptor your app (web.xml) you add follows statements
and add Error.jsp likeCode:<error-page>
<error-code>404</error-code>
<location>/jsp/Error.jsp</location>
</error-page>
<error-page>
<error-code>500</error-code>
<location>/jsp/Error.jsp</location>
</error-page>
The same way you can have whole stack trace and understand where you made mistake.Code:<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" isErrorPage="true"%>
<%@ page import="java.io.PrintWriter" %>
<%
if(exception instanceof ServletException)
if(exception.getCause() != null)
exception = exception.getCause();
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Error page</title>
</head>
<body>
<b><%=exception.getMessage()%></b><br>
<textarea name="stacktrace" style="height:500px;width:700px;" readonly="readonly"><%exception.printStackTrace(new PrintWriter(out));%></textarea>
</body>
</html>
Or, simply, don't do processing like this in a JSP page...
hello Petr thanks for ur concern,
i have added ur code to my application,but when i clicked on insert button nothing will be happened in browser window as well as in server.
Thank U.
I forget you need add follows statement on your page
in begin
Code:<%@ page buffer="128kb" errorPage="/jsp/Error.jsp" %>
Please go through this link.Quote:
Originally Posted by sudha333
db
Anyone got a convenient link on why not to do this stuff in a JSP?