SQLite autoincrement - How to insert values?

Question

I generate a SQLite table (in java):

create table participants (ROWID INTEGER PRIMARY KEY AUTOINCREMENT, col1,col2); 

afterwards I try to add rows using the INSERT comand:

insert into participants values ("bla","blub"); 

i get the error:

java.sql.SQLException: table participants has 3 columns but 2 values were supplied 

I thought the row id would be generated automatically, but it seems that I miss anything.

---

I tried another solution:

PreparedStatement prep = conn.prepareStatement("insert into participants values (?,?,?);"); Integer n = null; prep.setInt(1,n); prep.setString(2, "bla"); prep.setString(3, "blub"); prep.addBatch(); prep.executeBatch(); 

as result I received a null pointer exception at "prep.setInt(1,n);"

Do you see the fault?

Answer 1

Have you tried indicating to which fields of the table the parameters you are passing are supposed to be related?

INSERT INTO table_name (column1, column2, column3,...) VALUES (value1, value2, value3,...) 

In your case maybe something like:

INSERT INTO participants(col1, col2) VALUES ("bla","blub");