How to insert autoincrement value?

[Marcin Kwiatkowski]

Hello, I've got a problem with this piece of code:

void addRow(String val1, String val2){
 try{
  cachedRowSet.moveToInsertRow();
  //cachedRowSet.updateInt(1, ?);                                    
  cachedRowSet.updateString(2, val1); 
  cachedRowSet.updateString(3, val2);
  cachedRowSet.insertRow();
  cachedRowSet.moveToCurrentRow();
  cachedRowSet.acceptChanges():
 }catch(SQLException ex){
  ex.printStackTrace();
 }
}

after I call this method SQLException is thrown: "Failed on insert row"

[Paul Sturrock]

Don't include the autoincrement column in your insert statement and it should work fine.

[Marcin Kwiatkowski]

well... when i dont include first column i got this exception :/

[Paul Sturrock]

Count the number of '?' in your insert statement. Are you trying to define one for the autoincrement column? The number of parameters to be bound should be one less than the number of fields in the table (since the database will populate the autoincrement field, you don't have to).

[Sylven Yip]

set the auto increment field to null
e.g.
suppose id is an auto increment field
insert into table(id,name) values(null,"aldsf");

if preparedstatement
insert into table(id,name) values(null,?);

pStmt.setString(1,"aldsf");