Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa Java-Beginners Showing Error for Prepared stmt in a jsp

Have Programming Question? Ask it here!
 
 
 


M.Santosh kumar
Showing Error for Prepared stmt in a jsp
0 Answer(s)      a year and 8 months ago
Posted in : Java Beginners


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)

Advertisement
View Answers

Related Tutorials/Questions & Answers:
Showing Error for Prepared stmt in a jsp
Showing 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 jsp
Showing 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 error
compiled 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
Showing error in the driver declaration.Please suggest
Showing error in the driver declaration.Please suggest  org.apache.jasper.JasperException: Exception in JSP: /LogIn/8June.jsp:15 12: String driver = "org.gjt.mm.mysql.Driver" 13: //String connectionURL = "jdbc:mysql
SHOWING ERROR CODE 1064 WHILE TRYING TO EXECUTE PROCEDURE
SHOWING 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
Usage of setDate() in prepared Statement - JDBC
Usage 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
JSP error
JSP error  what is difference between global-exception and error-page in jsp. which condition they are use
how to add Arraylist filter for a jsp page showing results from a servlet
how to add Arraylist filter for a jsp page showing results from a servlet  hello sir/mam, in my project i have an arraylist showing results in a jsp... visit the following link: http://roseindia.net/jsp/servlet-jsp-data-list.shtml
jsp error
jsp error  <p>hi, could please help whenever i run jsp file in my eclipse i got this error.my jsp file is</p> &lt;%@ page language... encountered an internal error () that prevented it from fulfilling this request
Insert data in mysql database through jsp using prepared statement
Insert data in mysql database through jsp using prepared statement...; This is detailed jsp code that how to insert data into database by using prepared statement...; Save this code as a .jsp file named "prepared_statement_query.jsp"
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-Servlet
jsp 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-Servlet
jsp 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
JSP Error - JSP-Servlet
JSP 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
prepared statement
prepared statement  plese give me a code that have preparedstatement interface and uses a select query having condition date="s"; where s is the date, but this date parameter passed as the string
jsp error - JSP-Servlet
jsp error  how to remove below error:: exception org.apache.jasper.JasperException: java.lang.NullPointerException root cause...... newpo.jsp:   JSP Page
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 - JSP-Servlet
jsp 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
Insert data in mysql database through jsp using Prepared Statement ---- Please Resolve it
Insert data in mysql database through jsp using Prepared Statement ---- Please...;Please visit the following link: http://www.roseindia.net/jsp/prepared-statement... processing JSP page /databaseinsertion.jsp at line 117 114: 115: finally
JSP Translation error - JSP-Servlet
JSP 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
Insert data in mysql database through jsp using Prepared Statement ---- Please Resolve it
Insert data in mysql database through jsp using Prepared Statement ---- Please... link: http://www.roseindia.net/jsp/prepared-statement-query.shtml   ... occurred processing JSP page /databaseinsertion.jsp at line 117 114: 115
JScript error - JSP-Servlet
JScript 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 error page - JSP-Servlet
JSP 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 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 - JDBC
jsp 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
Prepared statement JDBC MYSQL
Prepared statement JDBC MYSQL  How to create a prepared statement in JDBC using MYSQL? Actually, I am looking for an example of prepared statement.   Selecting records using prepared statement in JDBC
jsp runtime error - JSP-Servlet
jsp 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
prepared statement in for loop - JDBC
prepared statement in for loop  Hi all, I am reding data from a jsp page and inserting into a table. For this i am using prepared statement...: sun.jdbc.odbc.JdbcOdbcBatchUpdateException: General error
JSP SQL Error
JSP 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
Script error - JSP-Servlet
running this it shows an error as "STACK OVERFLOW". Correct the code . The code... then send me jsp code. Thanks
jsp-servelet,error http404
jsp-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 process
Jsp 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 Error Page
JSP Error Page          JSP Error Page is used to specify the custom... directive. The page errorPage.jsp shows the error generated in calling the JSP page
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
Jsp Error - Development process
Jsp 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
output error - JSP-Servlet
output 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
Showing div at the center of the webpage
Showing div at the center of the webpage  Showing div at the center of the webpage
error message - JSP-Servlet
error 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
jsp-Hibernate Error - Hibernate
jsp-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
Programming Error - JSP-Servlet
(); } } }//End of class m geeting error in this can u please tell me whats the error nd how to solve
Programming Error - JSP-Servlet
integer.parseInt but its giving error. Please Reply me . Thank you
Error output - JSP-Servlet
Error 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
Programming Error - JSP-Servlet
is access). Then how to do this in jsp?? Please Reply me?? Please do Reply
Programming Error - JSP-Servlet
??? And when i tried its giving me error than cannot find variable.In
code error - JSP-Servlet
is error in this progrm. ss function describe() { window.status
jsp code error - JSP-Servlet
jsp 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 code error - JSP-Servlet
jsp code error  hello, is anyone here who can solve my problem. what happen experts where r u? r u not able to do
Programming Error - JSP-Servlet
("http://localhost:8080/examples/jsp/modify.jsp?filename="+filename
Programming Error - JSP-Servlet
statement in jsp i want to calculate the price of placing ad according to user
Advertisements
 

 

 

DMCA.com