Re: ODBC problem

[Vikas Buber]

U R getting an invalid cursor state.The cursor is before the first row when
obtained for the first time.
write the following statement after executing the query:
        rs.next() ;

Please convey the outcome.

Regards
Vikas

-----Original Message-----
From: Elena Palanca [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 26, 2000 2:37 PM
To: [EMAIL PROTECTED]
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");
          rs.next();
       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