JSP SQL Error

Ads
 

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=request.getParameter("username");
String Password=request.getParameter("password");
session.setAttribute("myusername", Username);
 Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
    Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:8084:dsn","system","tiger");  
           Statement st=null;
           PreparedStatement ps=null;
           ps=con.prepareStatement("select * from Users where USERID=? and PASSWORD=?");
           ps.setString(0, Username);
           ps.setString(1, Password);
           ResultSet rs=null;
           rs=ps.executeQuery();
           if(rs.next()){

                String redirectURL= "New.html";
                response.sendRedirect(redirectURL);

        }
                     else{
               out.println("no login");

                     }
                     }
    catch(Exception e){
    out.println(e);
}
%>
View Answers

Ads









Related Tutorials/Questions & Answers:
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
JSP error
JSP error  what is difference between global-exception and error-page in jsp. which condition they are use
Advertisements
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
SQL Error Version 5.5.15
SQL Error Version 5.5.15  SQL Error Version 5.5.15
error : not an sql expression statement
error : not an sql expression statement  hii I am gettin followin error in connecting to database SQLserver 2005 in Jdeveloper,i m usin struts and jsp my pogram: import java.sql.*; public class TaskBO { public TaskBO
SQL connection error in android
SQL connection error in android  hi, i am android developer . recently i made one application connect with sql server 2005 using jtds...:sql:Exception : BUFFERDIR connection property invalid. if you have any answer
SQL and JSP
SQL and JSP  1.sql database 1.store login and password details along with user name 2.list of employees with all relevant personal details... using sql data base.. 2.JSP pages 1.login screen which will have user id
sql syntax error help
sql syntax error help  this query show syntax error .. i am unable to figure it out insert into order (orderdate, dpname, paymethod, tamount...') where is the error ?   Please send the error details and the datatype
correct the sql error
correct the sql error  i am getting a SQL Error while retriving data from access to jframe called "datatype mismatch in criteria expression" plez do...(null,"Please enter the Student ID to Search","Error",0); } else { try
SQL QUERY ERROR
SQL QUERY ERROR  Im writing a query which shows error of INVALID... THE FORM IS THROWING THE ERROR OF INVALID CHARACTER BUT THE SAME QUERY IS RUNNING..._value'. . .); For more information, visit the following link: SQL Queries
foreign key error in sql
foreign key error in sql  create table matchdetails(mid varchar2(10),mdate date,team1 varchar2(10),team2 varchar2(10...) references matchdetails(mid)); ->for the above batsman table it shows error
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 sql server 2005 connectivity
jsp sql server 2005 connectivity  your jsp mysql tutorial is very help full.Please tell me how to connect jsp with SQL server 2005
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 Page Error
JSP 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 Error
JSP 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 Error
JSP 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
Programming error - JSP-Servlet
where if @ is not given or (dot). is not given etc then it should display error
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
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
Jsp error when i run this a jsp file
Jsp error when i run this a jsp file  hi I got this error when i run the jsp file in IDE and outside also please help me java.lang.NullPointerException org.apache.jsp.insertjsp.jspInit(insert_jsp.java:22
Dynamin Jfree chart in jsp---error
error details. Have a look at the following link: http://www.roseindia.net/jsp...Dynamin Jfree chart in jsp---error   While compiling this CODE...("Problem in creating chart."); } %> Generated error: <
Error while SQL Server connection to Java
Error while SQL Server connection to Java  import java.sql.*; public..."); con=DriverManager.getConnection("jdbc:odbc:SQL_SERVER;user=DTHOTA;password...("password", " "); con=DriverManager.getConnection("jdbc:odbc:SQL_SERVER", prop
Error while SQL Server connection to Java
Error while SQL Server connection to Java  import java.sql.*; public..."); con=DriverManager.getConnection("jdbc:odbc:SQL_SERVER;user=DTHOTA;password...("password", " "); con=DriverManager.getConnection("jdbc:odbc:SQL_SERVER", prop
Error page in JSP
Error page in JSP In this section we will discuss about "Error page... the JSP page a runtime error may occur inside the page or outside the page. JSP... in the directive in the originating JSP page by setting error page parameter like
correct the sql error and retrive data....plez
correct the sql error and retrive data....plez  i am getting a SQL Error while retriving data from access to jframe called "datatype mismatch...("")) { JOptionPane.showMessageDialog(null,"Please enter the Student ID to Search","Error",0
MY Sql Query Error - Not able to Understand the issue
MY Sql Query Error - Not able to Understand the issue  I am new... END I am getting an error as follow: Schema Creation Failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server
Java servlet with jsp on sql server
Java servlet with jsp on sql server  How to delete a user by an admin with check box in Java Servlet with jsp on Sql Server?   Here is a jsp example that can delete the multiple record from the database by selecting
Error testing in JSP
Error testing in JSP       This section illustrates you about the error testing in jsp. In JSP, you..." %>. The JSP page where the exception can occur specifies the error page name
Pagination in jsp using oracle and not sql
Pagination in jsp using oracle and not sql  I need the code for pagination in jsp using oracle. I already tried it with rownum between instead of limit in sql.Please do forward me the code as soon as possible.   JSP

Ads