Hi palanca,
You have to change your code this way
while(rsStudente.next())
{
String nome = rsStudente.getString("Nome");
String passw = rsUser.getString("Password");
}
problem is u should call next() method of resultset to advance pointer to
the
first row.If you have any problem feel free to ask me.
Shiva
----- Original Message -----
From: Elena Palanca <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, September 26, 2000 14:37
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
>
___________________________________________________________________________
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
