Cursor state not valid.

[Luis Fernandes]

Hello,

I receive the following error :

    
java.sql.SQLException: Cursor state not valid.
 

here is my code :

    
 String sql_query = "INSERT INTO TABELA(CAMPO1, CAMPO2, CAMPO3) VALUES ( ?  ? , ? )";    
                 
               try {  
                     
                   Class.forName(driver);  
                   Connection connection = DriverManager.getConnection(URL);  
                   PreparedStatement prepared_statement = connection.prepareStatement(sql_query);  
                     
                   int i ;  
                     
                   for(i = 0; i < 10; i++) {  
                         
                       String u = (String)ptabela.getValueAt(i, 0);  
                 String uu = ptabela.getValueAt(i, 1).toString().trim();  
                String uuu = ptabela.getValueAt(i, 2).toString().trim();  
                       System.out.println(u);  
                       System.out.println(uu);  
                       System.out.println(uuu);  
   
                         
                         
                       prepared_statement.setString(1, u);  
                       prepared_statement.setString(2, uu);  
                      prepared_statement.setString(3, uuu);  
                       ResultSet rs = prepared_statement.executeQuery();   
                   }  
                    
                     
                     
                  
               } catch (Exception ex) {  
                     
                   ex.printStackTrace();  
                     
               } 

After the code insert the firt row , it send me the exception : java.sql.SQLException: Cursor state not valid.

I know that the source ( ptabela ) have 500 rows (in this case i only want 10 rows), but i dont know why, the code write in database the first rows and after that trows me the exception.

Whats wrong with my code ?

regards

[Akshay Kiran]

change the
ResultSet.. line to

boolean b= prepared_statement.execute() ;
think that should fix it.