Visual J# Developer Center > Visual J# Forums > Visual J# General > Error row when i update resultset using JAVA JDBC-ODBC Bridge e Microsoft Access
Ask a questionAsk a question
 

QuestionError row when i update resultset using JAVA JDBC-ODBC Bridge e Microsoft Access

  • Monday, August 24, 2009 10:35 PMDiego Queres Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     

    When i execute this code:

                PreparedStatement ps = getConexao().prepareStatement(
    
                        "select * from customers",
    
                        ResultSet.TYPE_SCROLL_SENSITIVE,
    
                        ResultSet.CONCUR_UPDATABLE );
    
    
    
                
    
                ResultSet rs = ps.executeQuery();
    
    
    
                while (rs.next()) {
    
    
    
                                rs.updateString(3, empresa.getRazaoSocial());
    
                                rs.updateRow();
    
    
    
                }



    error code: 0
    occurs the folow error:

    java.sql.SQLException: [Microsoft][Driver ODBC para Microsoft Access]Error in row
            at sun.jdbc.odbc.JdbcOdbcResultSet.setPos(JdbcOdbcResultSet.java:5271)
            at sun.jdbc.odbc.JdbcOdbcResultSet.updateRow(JdbcOdbcResultSet.java:4171)