Showing Error for Prepared stmt in a jsp
i hav a task to connect jsp to oracel database using preparestatement and gettin an error showin dat prepared statement obj cant be created pstmt is nt resloved here are the files
index.jsp
<!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=ISO-8859-1">
<script language="JavaScript" type="text/JavaScript">
function validateForm()
{
var x=document.forms["myForm"]["Login"].value;
if (x==null || x=="")
{
alert("Login must be filled out");
return false;
}
}
</script>
</head>
<body bgcolor=pink>
<center><h1>DiggIn</h1>
<p><b>Welcome to DiggIn</b> </p>
<form action="Display.jsp" method="post">
<table width="276" height="74" border="0">
<tr>
<td width="60" height="53">Login</td>
<td>:</td>
<td width="199"><input type="text" name="Login" /></td>
</tr>
<tr>
<td width="60" height="42">Password</td>
<td>:</td>
<td><input type="password" name="Password" /></td>
</tr>
<tr>
<td width="60" height="42">Qualification</td>
<td>:</td>
<td><input type="text" name="Qualification" /></td>
</tr>
<tr>
<td width="60" height="42">City</td>
<td>:</td>
<td><input type="text" name="City" /></td>
</tr>
</table><form action=""><input type="submit" value="SignUp!"></form>
<form action=""><input type="button" name="SignIn" value="SignIn" /></form>
</center>
</form>
</body>
</html>
Display.jsp
<html>
<head>
</head>
<%@ page import="java.sql.*"%>
<body bgcolor="aqua">
<center>
<%
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","abc");
PreparedStatement pstmt=null;
String SQL="Insert into Login values(?,?,?,?)";
pstmt=con.prepareStatement(SQL);
}
catch(Exception e){
e.printStackTrace();
}
String Login=request.getParameter("Login");
String Password=request.getParameter("Password");
String Qualification=request.getParameter("Qualification");
String City=request.getParameter("City");
out.println(Login);
out.println(Password);
out.println(Qualification);
out.println(City);
pstmt.setString(1,Login);
pstmt.setString(2,Password);
pstmt.setString(3,Qualification);
pstmt.setString(4,City);
String result=pstmt.executeUpdate();
%>
<a href="user.html">Update</a>
</center>
</body>
</html>
Error:
HTTP Status 500 -
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: Unable to compile class for JSP:
An error occurred at line: 26 in the jsp file: /Display.jsp
pstmt cannot be resolved
23: out.println(Password);
24: out.println(Qualification);
25: out.println(City);
26: pstmt.setString(1,Login);
27: pstmt.setString(2,Password);
28: pstmt.setString(3,Qualification);
29: pstmt.setString(4,City);
An error occurred at line: 27 in the jsp file: /Display.jsp
pstmt cannot be resolved
24: out.println(Qualification);
25: out.println(City);
26: pstmt.setString(1,Login);
27: pstmt.setString(2,Password);
28: pstmt.setString(3,Qualification);
29: pstmt.setString(4,City);
30: String result=pstmt.executeUpdate();
An error occurred at line: 28 in the jsp file: /Display.jsp
pstmt cannot be resolved
25: out.println(City);
26: pstmt.setString(1,Login);
27: pstmt.setString(2,Password);
28: pstmt.setString(3,Qualification);
29: pstmt.setString(4,City);
30: String result=pstmt.executeUpdate();
31: %>
An error occurred at line: 29 in the jsp file: /Display.jsp
pstmt cannot be resolved
26: pstmt.setString(1,Login);
27: pstmt.setString(2,Password);
28: pstmt.setString(3,Qualification);
29: pstmt.setString(4,City);
30: String result=pstmt.executeUpdate();
31: %>
32: <a href="user.html">Update</a>
An error occurred at line: 30 in the jsp file: /Display.jsp
pstmt cannot be resolved
27: pstmt.setString(2,Password);
28: pstmt.setString(3,Qualification);
29: pstmt.setString(4,City);
30: String result=pstmt.executeUpdate();
31: %>
32: <a href="user.html">Update</a>
33: </center>
Stacktrace:
org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:92)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:330)
org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:439)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:349)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:327)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:314)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:592)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:317)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
View Answers
Related Tutorials/Questions & Answers:
Showing Error for Prepared stmt in a jspShowing Error for
Prepared stmt in a jsp i hav a task to connect
jsp...
org.apache.jasper.JasperException: Unable to compile class for
JSP:
An
error occurred...=pstmt.executeUpdate();
31: %>
An
error occurred at line: 29 in the
jsp file
Showing Error for Prepared stmt in a jspShowing Error for
Prepared stmt in a jsp i hav a task to connect
jsp...
org.apache.jasper.JasperException: Unable to compile class for
JSP:
An
error occurred...=pstmt.executeUpdate();
31: %>
An
error occurred at line: 29 in the
jsp file
Advertisements
why the program is showing error?;
It is
showing the
error:
An
error occurred at line: 33 in the
jsp file...why the program is
showing error? <%@page import="java.sql.*"%>...=Integer.parseInt(rs1.getString(10));
36: i=i+k;
An
error occurred at line
compiled but showing below errorcompiled but
showing below error Good morning,
By using axis api, am getting the following
error but the wsdl file is generating.
what is the mistake I done.
Unable to find required classes (javax.activation.DataHandler
JSP errorJSP error what is difference between global-exception and
error-page in
jsp. which condition they are use
jsp errorjsp error <p>hi, could please help whenever i run
jsp file in my eclipse i got this error.my
jsp file is</p>
<%@ page language... encountered an internal
error () that prevented it from fulfilling this request
jsp error - JSP-Servletjsp error Hello, my name is sreedhar. i wrote a
jsp application... and
showing the data base code and the connecction code. please help me to come... in detail.
Visit for more information.
http://www.roseindia.net/
jsp/
Thanks
jsp error - JSP-Servletjsp error HTTP Status 404 - /
jsp...
message /
jsp/
description The requested resource (/
jsp/) is not available...,
The 404 or Not Found
error message is an HTTP standard response code indicating
Servlet Error - JSP-Servlet.
Error showing ==>Admin/FirstServlet is not a servlet
Sincerely
Prakash Hi prakash
servlet-api.jar
jsp-api.jar
mysql-connector.../lib folder if database is mysql.
servlet-api.jar
jsp-api.jar
mysql-connector
JSP Error - JSP-ServletJSP Error When i am running my registration.jsp getting following
error.
HTTP Status 500...
description The server encountered an internal
error () that prevented it from fulfilling
jsp error - JSP-Servletjsp error how to remove below
error::
exception
org.apache.jasper.JasperException: java.lang.NullPointerException
root cause......
newpo.jsp:
JSP Page
jsp error - JSP-Servletjsp error To Upload and insert the file into oracle Database with Current Date and Time In
JSP
and my project is online library management system plz help how to store some books in particular folder and after how retrive
SHOWING ERROR CODE 1064 WHILE TRYING TO EXECUTE PROCEDURESHOWING ERROR CODE 1064 WHILE TRYING TO EXECUTE PROCEDURE I AM... IT. IT IS
SHOWING ERRORS. I TRIED REMOVING THE DELIMITER KEYWORD, BUT IT IS STILL THE SAME. I AM ALSO PUTTING THE GENERATED
ERROR.
(0 row(s)affected)
(0 ms taken)
(0 row(s
Programming Error - JSP-Servlet("");
}
catch(SQLException se)
{
out.println("Database
Error :"+se.getMessage());
}
catch(Exception e)
{
out.println("General
Error :"+e.getMessage... ServletException,IOException
{doPost(req,res);}
}
There is some
error JSP error page - JSP-ServletJSP error page Hi i have 1000 of
JSP. but we coded it without adding... the exception occured in
JSP. is there any short cut i can do? do not want to add this line.../DAO/bean layer and not in the
JSP.
let me know if you have any idea.
Thanks
JSP Translation error - JSP-ServletJSP Translation error Hello friends,
In a new file declared first variable shows the following
error.
-----------------------------------------------
An
error occurred at line: 2 in the
jsp file: /stud
jsp runtime error - JSP-Servletjsp runtime error sir, when i am running ur prog...
from this website....
http://www.roseindia.net/
jsp/poi/readingWriting.shtml
i did the same as per guidelines...but i got
error..!!!!
org.apache.jasper.JasperException
jsp code error - JSP-Servletjsp code error hello,
is anyone here who can solve my problem.
what happen experts where r u? r u not able to do
jsp code error - JSP-Servletjsp code error hello,
is anyone here who can solve my problem.
what happen experts where r u?
or
u r not able to do
jsp error - JDBCjsp error
in this code the else part is nt executing atall... of that a
error is like-----------"java.sql.SQLException: [Microsoft][ODBC Driver Manager... the line is not getting incremented u r getting that
error just
do this change
JScript error - JSP-ServletJScript error Hello friends,
I am doing
jsp... logins while updating profile it will not show any
error. But, in many logins it shows
error as unterminated string.
I am not able
jsp code error - JSP-Servletjsp code error I have a
jsp page named "tMastDepartment".which has some table row containing text box like 'project code','Departmentcode','employee_id',
'address', and 'city' and a one dropdown list which contains department
jsp-Hibernate Error - JSP-Servletjsp-Hibernate Error hi, my problem is, I designed an Interface where i am tring to listing the all rows of a table using Iterator and putted a link for deleting each row. I am deleteing row using row id of that record.it delete
Script error - JSP-Servlet running this it shows an
error as "STACK OVERFLOW".
Correct the code . The code... any problem then send me
jsp code.
Thanks
JSP SQL ErrorJSP SQL Error Hi While trying to execute the below code i'm getting the following
error "java.sql.SQLException: Io exception: Got minus one from a read call ". please help me out.
<%
try{
String Username
jsp-servelet,error http404jsp-servelet,
error http404 I am using mysql commandclient to connect with eclipse using
jsp and servelet.
I keep getting the
error hhtp 404.
Register.jsp
Name:<input type="text" name="userName"/><
Jsp Error - Development processJsp Error Hi, While executing Add_Data.jsp , am getting following
error.
"Data type mismatch in criteria expression."
"View_Data.jsp...)
at
jsp_servlet.__add_data._jspService(__add_data.java:146
jsp-Hibernate Error - Hibernatejsp-Hibernate Error hi, my problem is, I designed an Interface where i am tring to listing the all rows of a table using Iterator and putted a link for deleting each row. I am deleteing row using row id of that record.it delete
JSP Error 500
JSP Error 500
JSP Error 500 is to generate
error status 500 in
jsp. The
Error 500
occurred when the server encounter an internal
error Jsp Error - Development processJsp Error Hi, While executing following code "View_Service.jsp" , am getting
Internal Server
Error
java.sql.SQLException: [Microsoft][ODBC...(JdbcOdbcStatement.java:288)
at
jsp_servlet.__add_data._jspService(__add_data.java:146
Programming Error - JSP-ServletProgramming Error How to validate login page using
jsp where it checks for username whether it is empty or not or is it including number or not if it is the paste alert message.
Hi Friend,
Try the following
insertion error - JSP-Servletinsertion error my first
jsp page :
In this i m getting all the values through a method called getAllDetails,the values are getting inserted... into table.
below is the codeof
jsp and java pages;
function
JSP Page ErrorJSP Page Error Hello Sir.
I m using Oracle 10g as a database n tomcat server
DSN name : NB
Username NB
Password EBS
Table name consumer
When i run
jsp page on the browser it only shows the code nothing else..
I have
JSP Page ErrorJSP Page Error Hello Sir.
I m using Oracle 10g as a database n tomcat server
DSN name : NB
Username NB
Password EBS
Table name consumer
When i run
jsp page on the browser it only shows the code nothing else..
I have
JSP Page ErrorJSP Page Error Hello Sir.
I m using Oracle 10g as a database n tomcat server
DSN name : NB
Username NB
Password EBS
Table name consumer
When i run
jsp page on the browser it only shows the code nothing else..
I have
Usage of setDate() in prepared Statement - JDBCUsage of setDate in
prepared Statement Hi, I have created a
jsp...() of
prepared statement,the following
error is displayed: setDate() not available in
prepared statement. Basically, I need to accept the date dynamically
Tomcat error - JSP-Servlet the
error :-this is non microsoft product please see event log . what might be the reason of such error HI,
Can you paste the
error log here.We
output error - JSP-Servletoutput error /*hi friends, the given below is my servlet program
error? How can i solve this problem? */
HTTP Status 500... report
message
description The server encountered an internal
error error message - JSP-Servleterror message hi, friends
after complete my servlet programe i can type http://localhost:8080 on the browser. the servlet program is insert data into dbms. but i have errormessage that is "window can not access the specified
Error output - JSP-ServletError output Can anyone please assist me; The printed output should be:
The product is 10. But instead of it I got; The product is undefined.
Can anyone trace what went wrong of my code pls