Probably nothing to with Java or JDBC.
ODBC settings I think.
Best guess you must set `DIrect Cursor' or the other option available
and try again in the windows panel.
--
Peter Pilgrim
Welcome to the "Me Too" generation.
---------------------------------------- Message History
----------------------------------------
From: [EMAIL PROTECTED] on 26/09/2000 09:07
Please respond to [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
cc:
Subject: ODBC problem
Hy,
I'm tried to connect in a servlet to an ACCESS database doing a select
operation and I have the following error:
[parseRequest]Errore 2:java.sql.SQLException: [Microsoft][ODBC Driver
Manager] Stato del cursore non valido. (Invalid Cursor State)
In the Access Table I have only a row with the field Nome and Password
My code is the following:
String userId = req.getParameter( "UserId" );
try{
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
Connection con = DriverManager.getConnection
("jdbc:odbc:Esami","","");
Statement stat= con.createStatement();
rsStudente= stat.executeQuery("SELECT Nome FROM Utenti");
String nome = rsStudente.getString("Nome");
String passw = rsUser.getString("Password");
if ((nome.equals(userId))) auth="true";
rsStudente.close();
stat.close();
}catch (Exception e) {
log( "[parseRequest]Errore 2:" + e.toString() );
}
Someone know what I'm doing wrong?
Thanks in advance
Elena
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
--
This e-mail may contain confidential and/or privileged information. If you are not the
intended recipient (or have received this e-mail in error) please notify the sender
immediately and destroy this e-mail. Any unauthorised copying, disclosure or
distribution of the material in this e-mail is strictly forbidden.
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
